DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PVT dependencies on STANDARD

Line 917: -- Standard Start of API savepoint

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

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

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

Line 1026: -- Standard check of p_commit.

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

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

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

Line 1108: -- Standard Start of API savepoint

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

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

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

Line 1368: -- Standard check of p_commit.

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

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

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

Line 1548: -- Standard Start of API savepoint

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

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

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

Line 1622: -- Standard check of p_commit.

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

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

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

Line 1716: -- Standard Start of API savepoint

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

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

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

Line 1817: -- Standard check of p_commit.

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

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

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

Line 1922: -- Standard Start of API savepoint

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

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

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

Line 2156: -- Standard check of p_commit.

2152: x_loading_status := l_loading_status;
2153: END IF;
2154: END IF;
2155:
2156: -- Standard check of p_commit.
2157:
2158: IF FND_API.To_Boolean( p_commit ) THEN
2159: COMMIT WORK;
2160: END IF;

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

2158: IF FND_API.To_Boolean( p_commit ) THEN
2159: COMMIT WORK;
2160: END IF;
2161:
2162: -- Standard call to get message count and if count is 1, get message info
2163: FND_MSG_PUB.Count_And_Get
2164: (
2165: p_count => x_msg_count ,
2166: p_data => x_msg_data ,

Line 2259: -- Standard Start of API savepoint

2255:
2256:
2257: BEGIN
2258:
2259: -- Standard Start of API savepoint
2260:
2261: SAVEPOINT Delete_Mass_Asgn_Srp_Pmt_Plan;
2262:
2263: -- Standard call to check for call compatibility.

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

2259: -- Standard Start of API savepoint
2260:
2261: SAVEPOINT Delete_Mass_Asgn_Srp_Pmt_Plan;
2262:
2263: -- Standard call to check for call compatibility.
2264:
2265: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2266: p_api_version ,
2267: l_api_name ,

Line 2382: -- Standard check of p_commit.

2378: x_loading_status := l_loading_status;
2379:
2380: END IF;
2381:
2382: -- Standard check of p_commit.
2383:
2384: IF FND_API.To_Boolean( p_commit ) THEN
2385: COMMIT WORK;
2386: END IF;

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

2384: IF FND_API.To_Boolean( p_commit ) THEN
2385: COMMIT WORK;
2386: END IF;
2387:
2388: -- Standard call to get message count and if count is 1, get message info
2389: FND_MSG_PUB.Count_And_Get
2390: (
2391: p_count => x_msg_count ,
2392: p_data => x_msg_data ,