DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PUB dependencies on JTF_USR_HKS

Line 294: l_OAI_array JTF_USR_HKS.oai_data_array_type;

290: l_org_id NUMBER;
291: l_status VARCHAR2(1);
292:
293: -- Declaration for user hooks
294: l_OAI_array JTF_USR_HKS.oai_data_array_type;
295: l_bind_data_id NUMBER ;
296:
297: BEGIN
298: -- Standard Start of API savepoint

Line 379: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

375:
376: --
377: -- User hooks
378: --
379: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
380: 'CREATE_SRP_PMT_PLAN',
381: 'B',
382: 'C')
383: THEN

Line 406: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END IF;
404: END IF;
405:
406: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
407: 'CREATE_SRP_PMT_PLAN',
408: 'B',
409: 'V')
410: THEN

Line 470: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

466:
467: --
468: -- Post processing hooks
469: --
470: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
471: 'CREATE_SRP_PMT_PLAN',
472: 'A',
473: 'V')
474: THEN

Line 497: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: END IF;
495: END IF;
496:
497: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
498: 'CREATE_SRP_PMT_PLAN',
499: 'A',
500: 'C')
501: THEN

Line 527: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',

523:
524: --
525: -- Message enable hook
526: --
527: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',
528: 'CREATE_SRP_PMT_PLAN',
529: 'M',
530: 'M')
531: THEN

Line 543: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

539: -- call this for all bind variables in the business object
540: -- XMLGEN.setBindValue('SRP_PMT_PLAN_ID', x_srp_pmt_plan_id);
541:
542: -- Get a ID for workflow/ business object instance
543: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
544:
545: -- Do this for all the bind variables in the Business Object
546: JTF_USR_HKS.load_bind_data
547: ( l_bind_data_id, 'SRP_PMT_PLAN_ID', x_srp_pmt_plan_id, 'S', 'S');

Line 546: JTF_USR_HKS.load_bind_data

542: -- Get a ID for workflow/ business object instance
543: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
544:
545: -- Do this for all the bind variables in the Business Object
546: JTF_USR_HKS.load_bind_data
547: ( l_bind_data_id, 'SRP_PMT_PLAN_ID', x_srp_pmt_plan_id, 'S', 'S');
548:
549: -- Message generation API
550: JTF_USR_HKS.generate_message

Line 550: JTF_USR_HKS.generate_message

546: JTF_USR_HKS.load_bind_data
547: ( l_bind_data_id, 'SRP_PMT_PLAN_ID', x_srp_pmt_plan_id, 'S', 'S');
548:
549: -- Message generation API
550: JTF_USR_HKS.generate_message
551: (p_prod_code => 'CN',
552: p_bus_obj_code => 'SRP_PMTPLN',
553: p_bus_obj_name => 'SRP_PMT_PLAN',
554: p_action_code => 'I',

Line 661: l_OAI_array JTF_USR_HKS.oai_data_array_type;

657: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
658: l_update_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;
659:
660: -- Declaration for user hooks
661: l_OAI_array JTF_USR_HKS.oai_data_array_type;
662: l_bind_data_id NUMBER ;
663: l_check_lock VARCHAR2(1);
664:
665:

Line 811: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

807:
808: --
809: -- User hooks
810: --
811: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
812: 'UPDATE_SRP_PMT_PLAN',
813: 'B',
814: 'C')
815: THEN

Line 838: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836: END IF;
837:
838: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
839: 'UPDATE_SRP_PMT_PLAN',
840: 'B',
841: 'V')
842: THEN

Line 902: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

898:
899: --
900: -- Post processing hooks
901: --
902: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
903: 'UPDATE_SRP_PMT_PLAN',
904: 'A',
905: 'V')
906: THEN

Line 929: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: END IF;
927: END IF;
928:
929: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
930: 'UPDATE_SRP_PMT_PLAN',
931: 'A',
932: 'C')
933: THEN

Line 959: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',

955:
956: --
957: -- Message enable hook
958: --
959: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',
960: 'CREATE_SRP_PMT_PLAN',
961: 'M',
962: 'M')
963: THEN

Line 975: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

971: -- call this for all bind variables in the business object
972: -- XMLGEN.setBindValue('SRP_PMT_PLAN_ID', l_spp_row.srp_pmt_plan_id);
973:
974: -- Get a ID for workflow/ business object instance
975: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
976:
977: -- Do this for all the bind variables in the Business Object
978: JTF_USR_HKS.load_bind_data
979: ( l_bind_data_id, 'SRP_PMT_PLAN_ID',

Line 978: JTF_USR_HKS.load_bind_data

974: -- Get a ID for workflow/ business object instance
975: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
976:
977: -- Do this for all the bind variables in the Business Object
978: JTF_USR_HKS.load_bind_data
979: ( l_bind_data_id, 'SRP_PMT_PLAN_ID',
980: l_spp_row.srp_pmt_plan_id, 'S', 'S');
981:
982: -- Message generation API

Line 983: JTF_USR_HKS.generate_message

979: ( l_bind_data_id, 'SRP_PMT_PLAN_ID',
980: l_spp_row.srp_pmt_plan_id, 'S', 'S');
981:
982: -- Message generation API
983: JTF_USR_HKS.generate_message
984: (p_prod_code => 'CN',
985: p_bus_obj_code => 'SRP_PMTPLN',
986: p_bus_obj_name => 'SRP_PMT_PLAN',
987: p_action_code => 'I',

Line 1085: l_OAI_array JTF_USR_HKS.oai_data_array_type;

1081: l_org_id NUMBER;
1082: l_status VARCHAR2(1);
1083:
1084: -- Declaration for user hooks
1085: l_OAI_array JTF_USR_HKS.oai_data_array_type;
1086: l_bind_data_id NUMBER ;
1087: l_check_lock VARCHAR2(1);
1088:
1089: BEGIN

Line 1172: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

1168:
1169: --
1170: -- User hooks
1171: --
1172: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
1173: 'DELETE_SRP_PMT_PLAN',
1174: 'B',
1175: 'C')
1176: THEN

Line 1197: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: END IF;
1196:
1197: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
1198: 'DELETE_SRP_PMT_PLAN',
1199: 'B',
1200: 'V')
1201: THEN

Line 1247: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

1243:
1244: --
1245: -- Post processing hooks
1246: --
1247: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
1248: 'DELETE_SRP_PMT_PLAN',
1249: 'A',
1250: 'V')
1251: THEN

Line 1273: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270: END IF;
1271: END IF;
1272:
1273: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
1274: 'DELETE_SRP_PMT_PLAN',
1275: 'A',
1276: 'C')
1277: THEN

Line 1301: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',

1297: END IF;
1298: --
1299: -- Message enable hook
1300: --
1301: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',
1302: 'DELETE_SRP_PMT_PLAN',
1303: 'M',
1304: 'M')
1305: THEN

Line 1317: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

1313: -- call this for all bind variables in the business object
1314: -- XMLGEN.setBindValue('SRP_PMT_PLAN_ID', l_spp_row.srp_pmt_plan_id);
1315:
1316: -- Get a ID for workflow/ business object instance
1317: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1318:
1319: -- Do this for all the bind variables in the Business Object
1320: JTF_USR_HKS.load_bind_data
1321: ( l_bind_data_id, 'SRP_PMT_PLAN_ID',

Line 1320: JTF_USR_HKS.load_bind_data

1316: -- Get a ID for workflow/ business object instance
1317: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1318:
1319: -- Do this for all the bind variables in the Business Object
1320: JTF_USR_HKS.load_bind_data
1321: ( l_bind_data_id, 'SRP_PMT_PLAN_ID',
1322: l_spp_row.srp_pmt_plan_id, 'S', 'S');
1323:
1324: -- Message generation API

Line 1325: JTF_USR_HKS.generate_message

1321: ( l_bind_data_id, 'SRP_PMT_PLAN_ID',
1322: l_spp_row.srp_pmt_plan_id, 'S', 'S');
1323:
1324: -- Message generation API
1325: JTF_USR_HKS.generate_message
1326: (p_prod_code => 'CN',
1327: p_bus_obj_code => 'SRP_PMTPLN',
1328: p_bus_obj_name => 'SRP_PMT_PLAN',
1329: p_action_code => 'I',