DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PVT dependencies on STANDARD

Line 918: -- Standard Start of API savepoint

914: where r.role_id = rpp.role_id
915: and rpp.role_pmt_plan_id = p_pmt_plan_assign_rec.role_pmt_plan_id;
916:
917: BEGIN
918: -- Standard Start of API savepoint
919:
920: SAVEPOINT Create_Srp_Pmt_Plan;
921:
922: -- Standard call to check for call compatibility.

Line 922: -- Standard call to check for call compatibility.

918: -- Standard Start of API savepoint
919:
920: SAVEPOINT Create_Srp_Pmt_Plan;
921:
922: -- Standard call to check for call compatibility.
923:
924: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
925: p_api_version ,
926: l_api_name ,

Line 1027: -- Standard check of p_commit.

1023: WHERE srp_pmt_plan_id = p_pmt_plan_assign_rec.srp_pmt_plan_id;
1024:
1025: -- End of API body
1026:
1027: -- Standard check of p_commit.
1028:
1029: IF FND_API.To_Boolean( p_commit ) THEN
1030: COMMIT WORK;
1031: END IF;

Line 1033: -- Standard call to get message count and if count is 1, get message info

1029: IF FND_API.To_Boolean( p_commit ) THEN
1030: COMMIT WORK;
1031: END IF;
1032:
1033: -- Standard call to get message count and if count is 1, get message info
1034: FND_MSG_PUB.Count_And_Get
1035: (
1036: p_count => x_msg_count ,
1037: p_data => x_msg_data ,

Line 1109: -- Standard Start of API savepoint

1105: l_notemsg VARCHAR2(2000);
1106:
1107:
1108: BEGIN
1109: -- Standard Start of API savepoint
1110:
1111: SAVEPOINT Update_Srp_Pmt_Plan;
1112:
1113: -- Standard call to check for call compatibility.

Line 1113: -- Standard call to check for call compatibility.

1109: -- Standard Start of API savepoint
1110:
1111: SAVEPOINT Update_Srp_Pmt_Plan;
1112:
1113: -- Standard call to check for call compatibility.
1114:
1115: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1116: p_api_version ,
1117: l_api_name ,

Line 1369: -- Standard check of p_commit.

1365: FROM cn_srp_pmt_plans_all
1366: WHERE srp_pmt_plan_id = p_pmt_plan_assign_rec.srp_pmt_plan_id;
1367: -- End of API body.
1368:
1369: -- Standard check of p_commit.
1370:
1371: IF FND_API.To_Boolean( p_commit ) THEN
1372: COMMIT WORK;
1373: END IF;

Line 1375: -- Standard call to get message count and if count is 1, get message info

1371: IF FND_API.To_Boolean( p_commit ) THEN
1372: COMMIT WORK;
1373: END IF;
1374:
1375: -- Standard call to get message count and if count is 1, get message info
1376: FND_MSG_PUB.Count_And_Get
1377: (
1378: p_count => x_msg_count ,
1379: p_data => x_msg_data ,

Line 1549: -- Standard Start of API savepoint

1545:
1546: spp_info spp_info_cur%ROWTYPE;
1547:
1548: BEGIN
1549: -- Standard Start of API savepoint
1550: SAVEPOINT delete_srp_pmt_plan;
1551:
1552: -- Standard call to check for call compatibility.
1553:

Line 1552: -- Standard call to check for call compatibility.

1548: BEGIN
1549: -- Standard Start of API savepoint
1550: SAVEPOINT delete_srp_pmt_plan;
1551:
1552: -- Standard call to check for call compatibility.
1553:
1554: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1555: p_api_version ,
1556: l_api_name ,

Line 1623: -- Standard check of p_commit.

1619: p_pmt_plan_assign_rec => l_pmt_plan_assign_rec);
1620:
1621: -- End of API body
1622:
1623: -- Standard check of p_commit.
1624:
1625: IF FND_API.To_Boolean( p_commit ) THEN
1626: COMMIT WORK;
1627: END IF;

Line 1630: -- Standard call to get message count and if count is 1, get message info.

1626: COMMIT WORK;
1627: END IF;
1628:
1629:
1630: -- Standard call to get message count and if count is 1, get message info.
1631:
1632: FND_MSG_PUB.Count_And_Get
1633: (
1634: p_count => x_msg_count ,

Line 1717: -- Standard Start of API savepoint

1713: l_end_date cn_srp_pmt_plans.start_date%TYPE;
1714:
1715: BEGIN
1716:
1717: -- Standard Start of API savepoint
1718:
1719: SAVEPOINT Create_Mass_Asgn_Srp_Pmt_Plan;
1720:
1721: -- Standard call to check for call compatibility.

Line 1721: -- Standard call to check for call compatibility.

1717: -- Standard Start of API savepoint
1718:
1719: SAVEPOINT Create_Mass_Asgn_Srp_Pmt_Plan;
1720:
1721: -- Standard call to check for call compatibility.
1722:
1723: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1724: p_api_version ,
1725: l_api_name ,

Line 1818: -- Standard check of p_commit.

1814: x_loading_status := l_loading_status;
1815:
1816: -- END IF;
1817:
1818: -- Standard check of p_commit.
1819:
1820: IF FND_API.To_Boolean( p_commit ) THEN
1821: COMMIT WORK;
1822: END IF;

Line 1824: -- Standard call to get message count and if count is 1, get message info

1820: IF FND_API.To_Boolean( p_commit ) THEN
1821: COMMIT WORK;
1822: END IF;
1823:
1824: -- Standard call to get message count and if count is 1, get message info
1825: FND_MSG_PUB.Count_And_Get
1826: (
1827: p_count => x_msg_count ,
1828: p_data => x_msg_data ,

Line 1923: -- Standard Start of API savepoint

1919: l_end_of_time CONSTANT DATE := To_date('31-12-9999', 'DD-MM-YYYY');
1920:
1921: BEGIN
1922:
1923: -- Standard Start of API savepoint
1924:
1925: SAVEPOINT Update_Mass_Asgn_Srp_Pmt_plan;
1926:
1927: -- Standard call to check for call compatibility.

Line 1927: -- Standard call to check for call compatibility.

1923: -- Standard Start of API savepoint
1924:
1925: SAVEPOINT Update_Mass_Asgn_Srp_Pmt_plan;
1926:
1927: -- Standard call to check for call compatibility.
1928:
1929: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1930: p_api_version ,
1931: l_api_name ,

Line 2182: -- Standard check of p_commit.

2178: x_loading_status := l_loading_status;
2179: END IF;
2180: END IF;
2181:
2182: -- Standard check of p_commit.
2183:
2184: IF FND_API.To_Boolean( p_commit ) THEN
2185: COMMIT WORK;
2186: END IF;

Line 2188: -- Standard call to get message count and if count is 1, get message info

2184: IF FND_API.To_Boolean( p_commit ) THEN
2185: COMMIT WORK;
2186: END IF;
2187:
2188: -- Standard call to get message count and if count is 1, get message info
2189: FND_MSG_PUB.Count_And_Get
2190: (
2191: p_count => x_msg_count ,
2192: p_data => x_msg_data ,

Line 2285: -- Standard Start of API savepoint

2281:
2282:
2283: BEGIN
2284:
2285: -- Standard Start of API savepoint
2286:
2287: SAVEPOINT Delete_Mass_Asgn_Srp_Pmt_Plan;
2288:
2289: -- Standard call to check for call compatibility.

Line 2289: -- Standard call to check for call compatibility.

2285: -- Standard Start of API savepoint
2286:
2287: SAVEPOINT Delete_Mass_Asgn_Srp_Pmt_Plan;
2288:
2289: -- Standard call to check for call compatibility.
2290:
2291: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2292: p_api_version ,
2293: l_api_name ,

Line 2408: -- Standard check of p_commit.

2404: x_loading_status := l_loading_status;
2405:
2406: END IF;
2407:
2408: -- Standard check of p_commit.
2409:
2410: IF FND_API.To_Boolean( p_commit ) THEN
2411: COMMIT WORK;
2412: END IF;

Line 2414: -- Standard call to get message count and if count is 1, get message info

2410: IF FND_API.To_Boolean( p_commit ) THEN
2411: COMMIT WORK;
2412: END IF;
2413:
2414: -- Standard call to get message count and if count is 1, get message info
2415: FND_MSG_PUB.Count_And_Get
2416: (
2417: p_count => x_msg_count ,
2418: p_data => x_msg_data ,