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_SRP_HIER_PROC_PVT dependencies on STANDARD

Line 80: -- Standard Start of API savepoint

76: FROM cn_qm_group_hier
77: WHERE comp_group_id = p_group.group_id;
78:
79: BEGIN
80: -- Standard Start of API savepoint
81: SAVEPOINT get_ancestor_group;
82:
83: -- Standard call to check for call compatibility.
84: IF NOT FND_API.Compatible_API_Call

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

79: BEGIN
80: -- Standard Start of API savepoint
81: SAVEPOINT get_ancestor_group;
82:
83: -- Standard call to check for call compatibility.
84: IF NOT FND_API.Compatible_API_Call
85: (l_api_version ,
86: p_api_version ,
87: l_api_name ,

Line 132: -- Standard check of p_commit.

128: END LOOP;
129:
130: -- End of API body.
131:
132: -- Standard check of p_commit.
133: IF FND_API.To_Boolean( p_commit ) THEN
134: COMMIT WORK;
135: END IF;
136:

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

133: IF FND_API.To_Boolean( p_commit ) THEN
134: COMMIT WORK;
135: END IF;
136:
137: -- Standard call to get message count and if count is 1, get message info.
138: FND_MSG_PUB.Count_And_Get
139: (p_count => x_msg_count ,
140: p_data => x_msg_data );
141:

Line 230: -- Standard Start of API savepoint

226: FROM cn_qm_group_hier
227: WHERE parent_comp_group_id = p_group.group_id;
228:
229: BEGIN
230: -- Standard Start of API savepoint
231: SAVEPOINT get_descendant_group;
232:
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call

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

229: BEGIN
230: -- Standard Start of API savepoint
231: SAVEPOINT get_descendant_group;
232:
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call
235: (l_api_version ,
236: p_api_version ,
237: l_api_name ,

Line 282: -- Standard check of p_commit.

278: END LOOP;
279:
280: -- End of API body.
281:
282: -- Standard check of p_commit.
283: IF FND_API.To_Boolean( p_commit ) THEN
284: COMMIT WORK;
285: END IF;
286:

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

283: IF FND_API.To_Boolean( p_commit ) THEN
284: COMMIT WORK;
285: END IF;
286:
287: -- Standard call to get message count and if count is 1, get message info.
288: FND_MSG_PUB.Count_And_Get
289: (p_count => x_msg_count ,
290: p_data => x_msg_data );
291:

Line 405: -- Standard Start of API savepoint

401: AND (trunc(end_date_active) >= p_effective_date
402: OR end_date_active IS NULL);
403:
404: BEGIN
405: -- Standard Start of API savepoint
406: SAVEPOINT get_managers_pvt;
407: -- Standard call to check for call compatibility.
408: IF NOT FND_API.Compatible_API_Call
409: (l_api_version ,

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

403:
404: BEGIN
405: -- Standard Start of API savepoint
406: SAVEPOINT get_managers_pvt;
407: -- Standard call to check for call compatibility.
408: IF NOT FND_API.Compatible_API_Call
409: (l_api_version ,
410: p_api_version ,
411: l_api_name ,

Line 486: -- Standard check of p_commit.

482: END IF;
483: END IF;
484:
485: -- End of API body.
486: -- Standard check of p_commit.
487: IF FND_API.To_Boolean( p_commit ) THEN
488: COMMIT WORK;
489: END IF;
490: -- Standard call to get message count and if count is 1, get message info.

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

486: -- Standard check of p_commit.
487: IF FND_API.To_Boolean( p_commit ) THEN
488: COMMIT WORK;
489: END IF;
490: -- Standard call to get message count and if count is 1, get message info.
491: FND_MSG_PUB.Count_And_Get
492: (p_count => x_msg_count ,
493: p_data => x_msg_data ,
494: p_encoded => FND_API.G_FALSE );

Line 590: -- Standard Start of API savepoint

586: FROM cn_qm_srp_groups
587: WHERE comp_group_id = l_comp_group_id;
588:
589: BEGIN
590: -- Standard Start of API savepoint
591: SAVEPOINT get_salesreps_pvt;
592: -- Standard call to check for call compatibility.
593: IF NOT FND_API.Compatible_API_Call
594: (l_api_version ,

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

588:
589: BEGIN
590: -- Standard Start of API savepoint
591: SAVEPOINT get_salesreps_pvt;
592: -- Standard call to check for call compatibility.
593: IF NOT FND_API.Compatible_API_Call
594: (l_api_version ,
595: p_api_version ,
596: l_api_name ,

Line 642: -- Standard check of p_commit.

638: END IF;
639: END LOOP;
640:
641: -- End of API body.
642: -- Standard check of p_commit.
643: IF FND_API.To_Boolean( p_commit ) THEN
644: COMMIT WORK;
645: END IF;
646: -- Standard call to get message count and if count is 1, get message info.

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

642: -- Standard check of p_commit.
643: IF FND_API.To_Boolean( p_commit ) THEN
644: COMMIT WORK;
645: END IF;
646: -- Standard call to get message count and if count is 1, get message info.
647: FND_MSG_PUB.Count_And_Get
648: (p_count => x_msg_count ,
649: p_data => x_msg_data ,
650: p_encoded => FND_API.G_FALSE );

Line 748: -- Standard Start of API savepoint

744: FROM cn_qm_mgr_srp_groups
745: WHERE comp_group_id = p_group_id;
746:
747: BEGIN
748: -- Standard Start of API savepoint
749: SAVEPOINT get_ancestor_salesrep;
750:
751: -- Standard call to check for call compatibility.
752: IF NOT FND_API.Compatible_API_Call

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

747: BEGIN
748: -- Standard Start of API savepoint
749: SAVEPOINT get_ancestor_salesrep;
750:
751: -- Standard call to check for call compatibility.
752: IF NOT FND_API.Compatible_API_Call
753: (l_api_version ,
754: p_api_version ,
755: l_api_name ,

Line 870: -- Standard check of p_commit.

866:
867:
868: -- End of API body.
869:
870: -- Standard check of p_commit.
871: IF FND_API.To_Boolean( p_commit ) THEN
872: COMMIT WORK;
873: END IF;
874:

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

871: IF FND_API.To_Boolean( p_commit ) THEN
872: COMMIT WORK;
873: END IF;
874:
875: -- Standard call to get message count and if count is 1, get message info.
876: FND_MSG_PUB.Count_And_Get
877: (p_count => x_msg_count ,
878: p_data => x_msg_data );
879:

Line 980: -- Standard Start of API savepoint

976: AND (trunc(start_date_active) <= p_srp.effective_date)
977: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);
978:
979: BEGIN
980: -- Standard Start of API savepoint
981: SAVEPOINT get_descendant_salesreps;
982:
983: -- Standard call to check for call compatibility.
984: IF NOT FND_API.Compatible_API_Call

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

979: BEGIN
980: -- Standard Start of API savepoint
981: SAVEPOINT get_descendant_salesreps;
982:
983: -- Standard call to check for call compatibility.
984: IF NOT FND_API.Compatible_API_Call
985: (l_api_version ,
986: p_api_version ,
987: l_api_name ,

Line 1090: -- Standard check of p_commit.

1086: END IF; -- end of IF (l_mgr_flag = 'Y') THEN
1087:
1088: -- End of API body.
1089:
1090: -- Standard check of p_commit.
1091: IF FND_API.To_Boolean( p_commit ) THEN
1092: COMMIT WORK;
1093: END IF;
1094:

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

1091: IF FND_API.To_Boolean( p_commit ) THEN
1092: COMMIT WORK;
1093: END IF;
1094:
1095: -- Standard call to get message count and if count is 1, get message info.
1096: FND_MSG_PUB.Count_And_Get
1097: (p_count => x_msg_count ,
1098: p_data => x_msg_data );
1099:

Line 1239: -- Standard Start of API savepoint

1235: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);
1236:
1237:
1238: BEGIN
1239: -- Standard Start of API savepoint
1240: SAVEPOINT Get_Descendant_group_mbrs;
1241:
1242:
1243: -- Standard call to check for call compatibility.

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

1239: -- Standard Start of API savepoint
1240: SAVEPOINT Get_Descendant_group_mbrs;
1241:
1242:
1243: -- Standard call to check for call compatibility.
1244: IF NOT FND_API.Compatible_API_Call
1245: (l_api_version ,
1246: p_api_version ,
1247: l_api_name ,

Line 1342: -- Standard check of p_commit.

1338: END IF; -- If salesrep is a manager
1339:
1340: -- End of API body.
1341:
1342: -- Standard check of p_commit.
1343: IF FND_API.To_Boolean( p_commit ) THEN
1344: COMMIT WORK;
1345: END IF;
1346:

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

1343: IF FND_API.To_Boolean( p_commit ) THEN
1344: COMMIT WORK;
1345: END IF;
1346:
1347: -- Standard call to get message count and if count is 1, get message info.
1348: FND_MSG_PUB.Count_And_Get
1349: (p_count => x_msg_count ,
1350: p_data => x_msg_data );
1351:

Line 1525: -- Standard Start of API savepoint

1521: grp_mgr_rc RC_TYPE;
1522:
1523:
1524: BEGIN
1525: -- Standard Start of API savepoint
1526: SAVEPOINT Get_MO_Descendant_group_mbrs;
1527:
1528:
1529: -- Standard call to check for call compatibility.

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

1525: -- Standard Start of API savepoint
1526: SAVEPOINT Get_MO_Descendant_group_mbrs;
1527:
1528:
1529: -- Standard call to check for call compatibility.
1530: IF NOT FND_API.Compatible_API_Call
1531: (l_api_version ,
1532: p_api_version ,
1533: l_api_name ,

Line 1708: -- Standard check of p_commit.

1704: END IF; -- If salesrep is a manager
1705:
1706: -- End of API body.
1707:
1708: -- Standard check of p_commit.
1709: IF FND_API.To_Boolean( p_commit ) THEN
1710: COMMIT WORK;
1711: END IF;
1712:

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

1709: IF FND_API.To_Boolean( p_commit ) THEN
1710: COMMIT WORK;
1711: END IF;
1712:
1713: -- Standard call to get message count and if count is 1, get message info.
1714: FND_MSG_PUB.Count_And_Get
1715: (p_count => x_msg_count ,
1716: p_data => x_msg_data );
1717:

Line 1829: -- Standard Start of API savepoint

1825: AND (trunc(start_date_active) <= p_srp.effective_date)
1826: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);
1827:
1828: BEGIN
1829: -- Standard Start of API savepoint
1830: SAVEPOINT get_desc_role_info;
1831:
1832: -- Standard call to check for call compatibility.
1833: IF NOT FND_API.Compatible_API_Call

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

1828: BEGIN
1829: -- Standard Start of API savepoint
1830: SAVEPOINT get_desc_role_info;
1831:
1832: -- Standard call to check for call compatibility.
1833: IF NOT FND_API.Compatible_API_Call
1834: (l_api_version ,
1835: p_api_version ,
1836: 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:

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

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

Line 2120: -- Standard Start of API savepoint

2116:
2117: mgr_check_rc RC_TYPE;
2118: members_csr_rc RET_RC_TYPE;
2119: BEGIN
2120: -- Standard Start of API savepoint
2121: SAVEPOINT Get_MO_desc_role_info;
2122:
2123: -- Standard call to check for call compatibility.
2124: IF NOT FND_API.Compatible_API_Call

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

2119: BEGIN
2120: -- Standard Start of API savepoint
2121: SAVEPOINT Get_MO_desc_role_info;
2122:
2123: -- Standard call to check for call compatibility.
2124: IF NOT FND_API.Compatible_API_Call
2125: (l_api_version ,
2126: p_api_version ,
2127: l_api_name ,

Line 2390: -- Standard check of p_commit.

2386: END IF;
2387:
2388: -- End of API body.
2389:
2390: -- Standard check of p_commit.
2391: IF FND_API.To_Boolean( p_commit ) THEN
2392: COMMIT WORK;
2393: END IF;
2394:

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

2391: IF FND_API.To_Boolean( p_commit ) THEN
2392: COMMIT WORK;
2393: END IF;
2394:
2395: -- Standard call to get message count and if count is 1, get message info.
2396: FND_MSG_PUB.Count_And_Get
2397: (p_count => x_msg_count ,
2398: p_data => x_msg_data );
2399:

Line 2507: -- Standard Start of API savepoint

2503: AND manager_srp_id <> p_srp.salesrep_id
2504: AND manager_flag = 'Y';
2505:
2506: BEGIN
2507: -- Standard Start of API savepoint
2508: SAVEPOINT get_all_managers;
2509:
2510: -- Standard call to check for call compatibility.
2511: IF NOT FND_API.Compatible_API_Call

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

2506: BEGIN
2507: -- Standard Start of API savepoint
2508: SAVEPOINT get_all_managers;
2509:
2510: -- Standard call to check for call compatibility.
2511: IF NOT FND_API.Compatible_API_Call
2512: (l_api_version ,
2513: p_api_version ,
2514: l_api_name ,

Line 2615: -- Standard check of p_commit.

2611:
2612:
2613: -- End of API body.
2614:
2615: -- Standard check of p_commit.
2616: IF FND_API.To_Boolean( p_commit ) THEN
2617: COMMIT WORK;
2618: END IF;
2619:

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

2616: IF FND_API.To_Boolean( p_commit ) THEN
2617: COMMIT WORK;
2618: END IF;
2619:
2620: -- Standard call to get message count and if count is 1, get message info.
2621: FND_MSG_PUB.Count_And_Get
2622: (p_count => x_msg_count ,
2623: p_data => x_msg_data );
2624: