eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_MULTI_RATE_SCHEDULES_PUB dependencies on STANDARD

Line 192: -- Standard Start of API savepoint

188: l_org_id NUMBER;
189: l_status VARCHAR2(1);
190: -- End - MOAC Change
191: BEGIN
192: -- Standard Start of API savepoint
193: SAVEPOINT Create_Schedule;
194: -- Standard call to check for call compatibility.
195: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
196: p_api_version ,

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

190: -- End - MOAC Change
191: BEGIN
192: -- Standard Start of API savepoint
193: SAVEPOINT Create_Schedule;
194: -- Standard call to check for call compatibility.
195: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
196: p_api_version ,
197: l_api_name ,
198: G_PKG_NAME )

Line 306: -- Standard check of p_commit.

302: end if;
303:
304: -- End of API body.
305:
306: -- Standard check of p_commit.
307: IF FND_API.To_Boolean( p_commit ) THEN
308: COMMIT WORK;
309: END IF;
310: -- Standard call to get message count and if count is 1, get message info.

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

306: -- Standard check of p_commit.
307: IF FND_API.To_Boolean( p_commit ) THEN
308: COMMIT WORK;
309: END IF;
310: -- Standard call to get message count and if count is 1, get message info.
311: FND_MSG_PUB.Count_And_Get
312: (p_count => x_msg_count ,
313: p_data => x_msg_data ,
314: p_encoded => FND_API.G_FALSE );

Line 376: -- Standard Start of API savepoint

372: -- Start - MOAC Change
373: l_org_id NUMBER;
374: -- End - MOAC Change
375: BEGIN
376: -- Standard Start of API savepoint
377: SAVEPOINT Update_Schedule;
378: -- Standard call to check for call compatibility.
379: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
380: p_api_version ,

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

374: -- End - MOAC Change
375: BEGIN
376: -- Standard Start of API savepoint
377: SAVEPOINT Update_Schedule;
378: -- Standard call to check for call compatibility.
379: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
380: p_api_version ,
381: l_api_name ,
382: G_PKG_NAME )

Line 519: -- Standard check of p_commit.

515: end if;
516:
517: -- End of API body.
518:
519: -- Standard check of p_commit.
520: IF FND_API.To_Boolean( p_commit ) THEN
521: COMMIT WORK;
522: END IF;
523: -- Standard call to get message count and if count is 1, get message info.

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

519: -- Standard check of p_commit.
520: IF FND_API.To_Boolean( p_commit ) THEN
521: COMMIT WORK;
522: END IF;
523: -- Standard call to get message count and if count is 1, get message info.
524: FND_MSG_PUB.count_and_get
525: (p_count => x_msg_count ,
526: p_data => x_msg_data ,
527: p_encoded => FND_API.G_FALSE );

Line 577: -- Standard Start of API savepoint

573: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE := 0;
574: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Schedule';
575: l_api_version CONSTANT NUMBER := 1.0;
576: BEGIN
577: -- Standard Start of API savepoint
578: SAVEPOINT Delete_Schedule;
579: -- Standard call to check for call compatibility.
580: IF NOT FND_API.Compatible_API_Call
581: (l_api_version ,

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

575: l_api_version CONSTANT NUMBER := 1.0;
576: BEGIN
577: -- Standard Start of API savepoint
578: SAVEPOINT Delete_Schedule;
579: -- Standard call to check for call compatibility.
580: IF NOT FND_API.Compatible_API_Call
581: (l_api_version ,
582: p_api_version ,
583: l_api_name ,

Line 661: -- Standard check of p_commit.

657: end if;
658:
659: -- End of API body.
660:
661: -- Standard check of p_commit.
662: IF FND_API.To_Boolean( p_commit ) THEN
663: COMMIT WORK;
664: END IF;
665: -- Standard call to get message count and if count is 1, get message info.

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

661: -- Standard check of p_commit.
662: IF FND_API.To_Boolean( p_commit ) THEN
663: COMMIT WORK;
664: END IF;
665: -- Standard call to get message count and if count is 1, get message info.
666: FND_MSG_PUB.count_and_get
667: (p_count => x_msg_count ,
668: p_data => x_msg_data ,
669: p_encoded => FND_API.G_FALSE );

Line 727: -- Standard Start of API savepoint

723: l_status VARCHAR2(1);
724: -- End - MOAC Change
725:
726: BEGIN
727: -- Standard Start of API savepoint
728: SAVEPOINT Create_Dimension_Assign;
729: -- Standard call to check for call compatibility.
730: IF NOT FND_API.Compatible_API_Call
731: (l_api_version ,

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

725:
726: BEGIN
727: -- Standard Start of API savepoint
728: SAVEPOINT Create_Dimension_Assign;
729: -- Standard call to check for call compatibility.
730: IF NOT FND_API.Compatible_API_Call
731: (l_api_version ,
732: p_api_version ,
733: l_api_name ,

Line 834: -- Standard check of p_commit.

830: end if;
831:
832: -- End of API body.
833:
834: -- Standard check of p_commit.
835: IF FND_API.To_Boolean( p_commit ) THEN
836: COMMIT WORK;
837: END IF;
838: -- Standard call to get message count and if count is 1, get message info.

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

834: -- Standard check of p_commit.
835: IF FND_API.To_Boolean( p_commit ) THEN
836: COMMIT WORK;
837: END IF;
838: -- Standard call to get message count and if count is 1, get message info.
839: FND_MSG_PUB.Count_And_Get
840: (p_count => x_msg_count ,
841: p_data => x_msg_data ,
842: p_encoded => FND_API.G_FALSE );

Line 903: -- Standard Start of API savepoint

899: -- Start - MOAC Change
900: l_org_id NUMBER;
901: -- End - MOAC Change
902: BEGIN
903: -- Standard Start of API savepoint
904: SAVEPOINT Update_Dimension_Assign;
905: -- Standard call to check for call compatibility.
906: IF NOT FND_API.Compatible_API_Call
907: (l_api_version ,

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

901: -- End - MOAC Change
902: BEGIN
903: -- Standard Start of API savepoint
904: SAVEPOINT Update_Dimension_Assign;
905: -- Standard call to check for call compatibility.
906: IF NOT FND_API.Compatible_API_Call
907: (l_api_version ,
908: p_api_version ,
909: l_api_name ,

Line 1046: -- Standard check of p_commit.

1042: end if;
1043:
1044: -- End of API body.
1045:
1046: -- Standard check of p_commit.
1047: IF FND_API.To_Boolean( p_commit ) THEN
1048: COMMIT WORK;
1049: END IF;
1050: -- Standard call to get message count and if count is 1, get message info.

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

1046: -- Standard check of p_commit.
1047: IF FND_API.To_Boolean( p_commit ) THEN
1048: COMMIT WORK;
1049: END IF;
1050: -- Standard call to get message count and if count is 1, get message info.
1051: FND_MSG_PUB.Count_And_Get
1052: (p_count => x_msg_count ,
1053: p_data => x_msg_data ,
1054: p_encoded => FND_API.G_FALSE );

Line 1106: -- Standard Start of API savepoint

1102: l_rate_schedule_id CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE;
1103: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
1104: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
1105: BEGIN
1106: -- Standard Start of API savepoint
1107: SAVEPOINT Delete_Dimension_Assign;
1108: -- Standard call to check for call compatibility.
1109: IF NOT FND_API.Compatible_API_Call
1110: (l_api_version ,

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

1104: l_rate_sch_dim_id CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE;
1105: BEGIN
1106: -- Standard Start of API savepoint
1107: SAVEPOINT Delete_Dimension_Assign;
1108: -- Standard call to check for call compatibility.
1109: IF NOT FND_API.Compatible_API_Call
1110: (l_api_version ,
1111: p_api_version ,
1112: l_api_name ,

Line 1196: -- Standard check of p_commit.

1192: end if;
1193:
1194: -- End of API body.
1195:
1196: -- Standard check of p_commit.
1197: IF FND_API.To_Boolean( p_commit ) THEN
1198: COMMIT WORK;
1199: END IF;
1200: -- Standard call to get message count and if count is 1, get message info.

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

1196: -- Standard check of p_commit.
1197: IF FND_API.To_Boolean( p_commit ) THEN
1198: COMMIT WORK;
1199: END IF;
1200: -- Standard call to get message count and if count is 1, get message info.
1201: FND_MSG_PUB.Count_And_Get
1202: (p_count => x_msg_count ,
1203: p_data => x_msg_data ,
1204: p_encoded => FND_API.G_FALSE );

Line 1265: -- Standard Start of API savepoint

1261: l_org_id NUMBER;
1262: -- End - MOAC Change
1263:
1264: BEGIN
1265: -- Standard Start of API savepoint
1266: SAVEPOINT Update_Rate;
1267: -- Standard call to check for call compatibility.
1268: IF NOT FND_API.Compatible_API_Call
1269: (l_api_version ,

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

1263:
1264: BEGIN
1265: -- Standard Start of API savepoint
1266: SAVEPOINT Update_Rate;
1267: -- Standard call to check for call compatibility.
1268: IF NOT FND_API.Compatible_API_Call
1269: (l_api_version ,
1270: p_api_version ,
1271: l_api_name ,

Line 1392: -- Standard check of p_commit.

1388: end if;
1389:
1390: -- End of API body.
1391:
1392: -- Standard check of p_commit.
1393: IF FND_API.To_Boolean( p_commit ) THEN
1394: COMMIT WORK;
1395: END IF;
1396: -- Standard call to get message count and if count is 1, get message info.

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

1392: -- Standard check of p_commit.
1393: IF FND_API.To_Boolean( p_commit ) THEN
1394: COMMIT WORK;
1395: END IF;
1396: -- Standard call to get message count and if count is 1, get message info.
1397: FND_MSG_PUB.Count_And_Get
1398: (p_count => x_msg_count ,
1399: p_data => x_msg_data ,
1400: p_encoded => FND_API.G_FALSE );

Line 1459: -- Standard Start of API savepoint

1455: -- End - MOAC Change
1456:
1457: BEGIN
1458:
1459: -- Standard Start of API savepoint
1460: SAVEPOINT Create_Dimension;
1461: -- Standard call to check for call compatibility.
1462: IF NOT FND_API.Compatible_API_Call
1463: (l_api_version ,

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

1457: BEGIN
1458:
1459: -- Standard Start of API savepoint
1460: SAVEPOINT Create_Dimension;
1461: -- Standard call to check for call compatibility.
1462: IF NOT FND_API.Compatible_API_Call
1463: (l_api_version ,
1464: p_api_version ,
1465: l_api_name ,

Line 1579: -- Standard check of p_commit.

1575: end if;
1576:
1577: -- End of API body.
1578:
1579: -- Standard check of p_commit.
1580: IF FND_API.To_Boolean( p_commit ) THEN
1581: COMMIT WORK;
1582: END IF;
1583: -- Standard call to get message count and if count is 1, get message info.

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

1579: -- Standard check of p_commit.
1580: IF FND_API.To_Boolean( p_commit ) THEN
1581: COMMIT WORK;
1582: END IF;
1583: -- Standard call to get message count and if count is 1, get message info.
1584: FND_MSG_PUB.Count_And_Get
1585: (p_count => x_msg_count ,
1586: p_data => x_msg_data ,
1587: p_encoded => FND_API.G_FALSE );

Line 1658: -- Standard Start of API savepoint

1654: where rate_dimension_id = p_rate_dimension_id
1655: and tier_sequence = p_tier_sequence;
1656:
1657: BEGIN
1658: -- Standard Start of API savepoint
1659: SAVEPOINT Update_Dimension;
1660: -- Standard call to check for call compatibility.
1661: IF NOT FND_API.Compatible_API_Call
1662: (l_api_version ,

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

1656:
1657: BEGIN
1658: -- Standard Start of API savepoint
1659: SAVEPOINT Update_Dimension;
1660: -- Standard call to check for call compatibility.
1661: IF NOT FND_API.Compatible_API_Call
1662: (l_api_version ,
1663: p_api_version ,
1664: l_api_name ,

Line 1814: -- Standard check of p_commit.

1810: end if;
1811:
1812: -- End of API body.
1813:
1814: -- Standard check of p_commit.
1815: IF FND_API.To_Boolean( p_commit ) THEN
1816: COMMIT WORK;
1817: END IF;
1818: -- Standard call to get message count and if count is 1, get message info.

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

1814: -- Standard check of p_commit.
1815: IF FND_API.To_Boolean( p_commit ) THEN
1816: COMMIT WORK;
1817: END IF;
1818: -- Standard call to get message count and if count is 1, get message info.
1819: FND_MSG_PUB.count_and_get
1820: (p_count => x_msg_count ,
1821: p_data => x_msg_data ,
1822: p_encoded => FND_API.G_FALSE );

Line 1872: -- Standard Start of API savepoint

1868: l_api_version CONSTANT NUMBER := 1.0;
1869: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
1870:
1871: BEGIN
1872: -- Standard Start of API savepoint
1873: SAVEPOINT Delete_Dimension;
1874: -- Standard call to check for call compatibility.
1875: IF NOT FND_API.Compatible_API_Call
1876: (l_api_version ,

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

1870:
1871: BEGIN
1872: -- Standard Start of API savepoint
1873: SAVEPOINT Delete_Dimension;
1874: -- Standard call to check for call compatibility.
1875: IF NOT FND_API.Compatible_API_Call
1876: (l_api_version ,
1877: p_api_version ,
1878: l_api_name ,

Line 1955: -- Standard check of p_commit.

1951: end if;
1952:
1953: -- End of API body.
1954:
1955: -- Standard check of p_commit.
1956: IF FND_API.To_Boolean( p_commit ) THEN
1957: COMMIT WORK;
1958: END IF;
1959: -- Standard call to get message count and if count is 1, get message info.

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

1955: -- Standard check of p_commit.
1956: IF FND_API.To_Boolean( p_commit ) THEN
1957: COMMIT WORK;
1958: END IF;
1959: -- Standard call to get message count and if count is 1, get message info.
1960: FND_MSG_PUB.count_and_get
1961: (p_count => x_msg_count ,
1962: p_data => x_msg_data ,
1963: p_encoded => FND_API.G_FALSE );

Line 2027: -- Standard Start of API savepoint

2023: l_status VARCHAR2(1);
2024: -- End - MOAC Change
2025:
2026: BEGIN
2027: -- Standard Start of API savepoint
2028: SAVEPOINT Create_tier;
2029: -- Standard call to check for call compatibility.
2030: IF NOT FND_API.Compatible_API_Call
2031: (l_api_version ,

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

2025:
2026: BEGIN
2027: -- Standard Start of API savepoint
2028: SAVEPOINT Create_tier;
2029: -- Standard call to check for call compatibility.
2030: IF NOT FND_API.Compatible_API_Call
2031: (l_api_version ,
2032: p_api_version ,
2033: l_api_name ,

Line 2148: -- Standard check of p_commit.

2144: end if;
2145:
2146: -- End of API body.
2147:
2148: -- Standard check of p_commit.
2149: IF FND_API.To_Boolean( p_commit ) THEN
2150: COMMIT WORK;
2151: END IF;
2152: -- Standard call to get message count and if count is 1, get message info.

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

2148: -- Standard check of p_commit.
2149: IF FND_API.To_Boolean( p_commit ) THEN
2150: COMMIT WORK;
2151: END IF;
2152: -- Standard call to get message count and if count is 1, get message info.
2153: FND_MSG_PUB.Count_And_Get
2154: (p_count => x_msg_count ,
2155: p_data => x_msg_data ,
2156: p_encoded => FND_API.G_FALSE );

Line 2219: -- Standard Start of API savepoint

2215: -- Start - MOAC Change
2216: l_org_id NUMBER;
2217: -- End - MOAC Change
2218: BEGIN
2219: -- Standard Start of API savepoint
2220: SAVEPOINT Update_tier;
2221: -- Standard call to check for call compatibility.
2222: IF NOT FND_API.Compatible_API_Call
2223: (l_api_version ,

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

2217: -- End - MOAC Change
2218: BEGIN
2219: -- Standard Start of API savepoint
2220: SAVEPOINT Update_tier;
2221: -- Standard call to check for call compatibility.
2222: IF NOT FND_API.Compatible_API_Call
2223: (l_api_version ,
2224: p_api_version ,
2225: l_api_name ,

Line 2356: -- Standard check of p_commit.

2352: end if;
2353:
2354: -- End of API body.
2355:
2356: -- Standard check of p_commit.
2357: IF FND_API.To_Boolean( p_commit ) THEN
2358: COMMIT WORK;
2359: END IF;
2360: -- Standard call to get message count and if count is 1, get message info.

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

2356: -- Standard check of p_commit.
2357: IF FND_API.To_Boolean( p_commit ) THEN
2358: COMMIT WORK;
2359: END IF;
2360: -- Standard call to get message count and if count is 1, get message info.
2361: FND_MSG_PUB.Count_And_Get
2362: (p_count => x_msg_count ,
2363: p_data => x_msg_data ,
2364: p_encoded => FND_API.G_FALSE );

Line 2415: -- Standard Start of API savepoint

2411: l_api_version CONSTANT NUMBER := 1.0;
2412: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
2413: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
2414: BEGIN
2415: -- Standard Start of API savepoint
2416: SAVEPOINT Delete_Tier;
2417: -- Standard call to check for call compatibility.
2418: IF NOT FND_API.Compatible_API_Call
2419: (l_api_version ,

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

2413: l_rate_dim_tier_id CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE;
2414: BEGIN
2415: -- Standard Start of API savepoint
2416: SAVEPOINT Delete_Tier;
2417: -- Standard call to check for call compatibility.
2418: IF NOT FND_API.Compatible_API_Call
2419: (l_api_version ,
2420: p_api_version ,
2421: l_api_name ,

Line 2500: -- Standard check of p_commit.

2496: end if;
2497:
2498: -- End of API body.
2499:
2500: -- Standard check of p_commit.
2501: IF FND_API.To_Boolean( p_commit ) THEN
2502: COMMIT WORK;
2503: END IF;
2504: -- Standard call to get message count and if count is 1, get message info.

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

2500: -- Standard check of p_commit.
2501: IF FND_API.To_Boolean( p_commit ) THEN
2502: COMMIT WORK;
2503: END IF;
2504: -- Standard call to get message count and if count is 1, get message info.
2505: FND_MSG_PUB.Count_And_Get
2506: (p_count => x_msg_count ,
2507: p_data => x_msg_data ,
2508: p_encoded => FND_API.G_FALSE );