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_ROLE_PLANS_PUB dependencies on JTF_USR_HKS

Line 1265: l_oai_array jtf_usr_hks.oai_data_array_type;

1261: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
1262: l_object_version_number cn_role_plans.object_version_number%TYPE := 1;
1263: -- Declaration for user hooks
1264: l_rec role_plan_rec_type;
1265: l_oai_array jtf_usr_hks.oai_data_array_type;
1266: l_bind_data_id NUMBER;
1267: l_org_id NUMBER;
1268: l_status VARCHAR2(1);
1269: l_note_msg VARCHAR2 (240);

Line 1323: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1319:
1320: -- User hooks
1321:
1322: -- Customer pre-processing section
1323: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1324: 'CREATE_ROLE_PLAN',
1325: 'B',
1326: 'C'
1327: )

Line 1351: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1347: END IF;
1348: END IF;
1349:
1350: -- Vertical industry pre-processing section
1351: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1352: 'CREATE_ROLE_PLAN',
1353: 'B',
1354: 'V'
1355: )

Line 1485: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1481:
1482: -- User hooks
1483:
1484: -- Customer post-processing section
1485: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1486: 'CREATE_ROLE_PLAN',
1487: 'A',
1488: 'V'
1489: )

Line 1513: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1509: END IF;
1510: END IF;
1511:
1512: -- Vertical industry post-processing section
1513: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1514: 'CREATE_ROLE_PLAN',
1515: 'A',
1516: 'C'
1517: )

Line 1541: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1537: END IF;
1538: END IF;
1539:
1540: -- Message enable hook
1541: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1542: 'CREATE_ROLE_PLAN',
1543: 'M',
1544: 'M'
1545: )

Line 1558: l_bind_data_id := jtf_usr_hks.get_bind_data_id;

1554: -- call this for all bind variables in the business object
1555: -- XMLGEN.setBindValue('SRP_PMT_PLAN_ID', x_srp_pmt_plan_id);
1556:
1557: -- Get a ID for workflow/ business object instance
1558: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
1559: -- Do this for all the bind variables in the Business Object
1560: jtf_usr_hks.load_bind_data (l_bind_data_id,
1561: 'ROLE_PLAN_ID',
1562: l_role_plan_id,

Line 1560: jtf_usr_hks.load_bind_data (l_bind_data_id,

1556:
1557: -- Get a ID for workflow/ business object instance
1558: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
1559: -- Do this for all the bind variables in the Business Object
1560: jtf_usr_hks.load_bind_data (l_bind_data_id,
1561: 'ROLE_PLAN_ID',
1562: l_role_plan_id,
1563: 'S',
1564: 'S'

Line 1567: jtf_usr_hks.generate_message (p_prod_code => 'CN',

1563: 'S',
1564: 'S'
1565: );
1566: -- Message generation API
1567: jtf_usr_hks.generate_message (p_prod_code => 'CN',
1568: p_bus_obj_code => 'ROLE_PLAN',
1569: p_bus_obj_name => 'ROLE_PLAN',
1570: p_action_code => 'I',
1571: p_bind_data_id => l_bind_data_id,

Line 1676: l_oai_array jtf_usr_hks.oai_data_array_type;

1672: l_date_update_only VARCHAR2 (1);
1673: -- Declaration for user hooks
1674: l_rec_old role_plan_rec_type;
1675: l_rec_new role_plan_rec_type;
1676: l_oai_array jtf_usr_hks.oai_data_array_type;
1677: l_bind_data_id NUMBER;
1678: l_org_id NUMBER;
1679: l_status VARCHAR2(1);
1680: l_note_msg VARCHAR2 (240);

Line 1793: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1789:
1790: -- User hooks
1791:
1792: -- Customer pre-processing section
1793: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1794: 'UPDATE_ROLE_PLAN',
1795: 'B',
1796: 'C'
1797: )

Line 1822: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1818: END IF;
1819: END IF;
1820:
1821: -- Vertical industry pre-processing section
1822: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1823: 'UPDATE_ROLE_PLAN',
1824: 'B',
1825: 'V'
1826: )

Line 2177: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2173:
2174: -- User hooks
2175:
2176: -- Customer post-processing section
2177: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2178: 'UPDATE_ROLE_PLAN',
2179: 'A',
2180: 'V'
2181: )

Line 2206: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2202: END IF;
2203: END IF;
2204:
2205: -- Vertical industry post-processing section
2206: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2207: 'UPDATE_ROLE_PLAN',
2208: 'A',
2209: 'C'
2210: )

Line 2235: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2231: END IF;
2232: END IF;
2233:
2234: -- Message enable hook
2235: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2236: 'UPDATE_ROLE_PLAN',
2237: 'M',
2238: 'M'
2239: )

Line 2252: l_bind_data_id := jtf_usr_hks.get_bind_data_id;

2248: -- call this for all bind variables in the business object
2249: -- XMLGEN.setBindValue('SRP_PMT_PLAN_ID', x_srp_pmt_plan_id);
2250:
2251: -- Get a ID for workflow/ business object instance
2252: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
2253: -- Do this for all the bind variables in the Business Object
2254: jtf_usr_hks.load_bind_data (l_bind_data_id,
2255: 'ROLE_PLAN_ID',
2256: l_role_plan_id_old,

Line 2254: jtf_usr_hks.load_bind_data (l_bind_data_id,

2250:
2251: -- Get a ID for workflow/ business object instance
2252: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
2253: -- Do this for all the bind variables in the Business Object
2254: jtf_usr_hks.load_bind_data (l_bind_data_id,
2255: 'ROLE_PLAN_ID',
2256: l_role_plan_id_old,
2257: 'S',
2258: 'S'

Line 2261: jtf_usr_hks.generate_message (p_prod_code => 'CN',

2257: 'S',
2258: 'S'
2259: );
2260: -- Message generation API
2261: jtf_usr_hks.generate_message (p_prod_code => 'CN',
2262: p_bus_obj_code => 'ROLE_PLAN',
2263: p_bus_obj_name => 'ROLE_PLAN',
2264: p_action_code => 'I',
2265: p_bind_data_id => l_bind_data_id,

Line 2350: l_oai_array jtf_usr_hks.oai_data_array_type;

2346: l_role_plan_id cn_role_plans.role_plan_id%TYPE;
2347: l_role_id cn_roles.role_id%TYPE;
2348: -- Declaration for user hooks
2349: l_rec role_plan_rec_type;
2350: l_oai_array jtf_usr_hks.oai_data_array_type;
2351: l_bind_data_id NUMBER;
2352: l_org_id NUMBER;
2353: l_status VARCHAR2(1);
2354: l_note_msg VARCHAR2 (240);

Line 2408: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2404:
2405: -- User hooks
2406:
2407: -- Customer pre-processing section
2408: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2409: 'DELETE_ROLE_PLAN',
2410: 'B',
2411: 'C'
2412: )

Line 2436: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2432: END IF;
2433: END IF;
2434:
2435: -- Vertical industry pre-processing section
2436: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2437: 'DELETE_ROLE_PLAN',
2438: 'B',
2439: 'V'
2440: )

Line 2565: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2561:
2562: -- User hooks
2563:
2564: -- Customer post-processing section
2565: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2566: 'DELETE_ROLE_PLAN',
2567: 'A',
2568: 'V'
2569: )

Line 2593: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2589: END IF;
2590: END IF;
2591:
2592: -- Vertical industry post-processing section
2593: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2594: 'DELETE_ROLE_PLAN',
2595: 'A',
2596: 'C'
2597: )

Line 2621: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2617: END IF;
2618: END IF;
2619:
2620: -- Message enable hook
2621: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2622: 'DELETE_ROLE_PLAN',
2623: 'M',
2624: 'M'
2625: )

Line 2638: l_bind_data_id := jtf_usr_hks.get_bind_data_id;

2634: -- call this for all bind variables in the business object
2635: -- XMLGEN.setBindValue('SRP_PMT_PLAN_ID', x_srp_pmt_plan_id);
2636:
2637: -- Get a ID for workflow/ business object instance
2638: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
2639: -- Do this for all the bind variables in the Business Object
2640: jtf_usr_hks.load_bind_data (l_bind_data_id,
2641: 'ROLE_PLAN_ID',
2642: l_role_plan_id,

Line 2640: jtf_usr_hks.load_bind_data (l_bind_data_id,

2636:
2637: -- Get a ID for workflow/ business object instance
2638: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
2639: -- Do this for all the bind variables in the Business Object
2640: jtf_usr_hks.load_bind_data (l_bind_data_id,
2641: 'ROLE_PLAN_ID',
2642: l_role_plan_id,
2643: 'S',
2644: 'S'

Line 2647: jtf_usr_hks.generate_message (p_prod_code => 'CN',

2643: 'S',
2644: 'S'
2645: );
2646: -- Message generation API
2647: jtf_usr_hks.generate_message (p_prod_code => 'CN',
2648: p_bus_obj_code => 'ROLE_PLAN',
2649: p_bus_obj_name => 'ROLE_PLAN',
2650: p_action_code => 'I',
2651: p_bind_data_id => l_bind_data_id,