121: --Make the pre processing call to the user hooks
122:
123: --Pre Call to the Customer Type User Hook
124:
125: IF jtf_usr_hks.ok_to_execute(
126: 'JTF_RS_SRP_TERRITORIES_PVT',
127: 'CREATE_RS_SRP_TERRITORIES',
128: 'B',
129: 'C')
149: END IF;
150:
151: --Pre Call to the Vertical Type User Hook
152:
153: IF jtf_usr_hks.ok_to_execute(
154: 'JTF_RS_SRP_TERRITORIES_PVT',
155: 'CREATE_RS_SRP_TERRITORIES',
156: 'B',
157: 'V')
177: END IF;
178:
179: --Pre Call to the Internal Type User Hook
180:
181: IF jtf_usr_hks.ok_to_execute(
182: 'JTF_RS_SRP_TERRITORIES_PVT',
183: 'CREATE_RS_SRP_TERRITORIES',
184: 'B',
185: 'I')
378: --Make the post processing call to the user hooks
379:
380: --Post Call to the Customer Type User Hook
381:
382: IF jtf_usr_hks.ok_to_execute(
383: 'JTF_RS_SRP_TERRITORIES_PVT',
384: 'CREATE_RS_SRP_TERRITORIES',
385: 'A',
386: 'C')
407: END IF;
408:
409: --Post Call to the Vertical Type User Hook
410:
411: IF jtf_usr_hks.ok_to_execute(
412: 'JTF_RS_SRP_TERRITORIES_PVT',
413: 'CREATE_RS_SRP_TERRITORIES',
414: 'A',
415: 'V')
436: END IF;
437:
438: --Post Call to the Internal Type User Hook
439:
440: IF jtf_usr_hks.ok_to_execute(
441: 'JTF_RS_SRP_TERRITORIES_PVT',
442: 'CREATE_RS_SRP_TERRITORIES',
443: 'A',
444: 'I')
464: END IF;
465:
466: /* Standard call for Message Generation */
467:
468: IF jtf_usr_hks.ok_to_execute(
469: 'JTF_RS_SRP_TERRITORIES_PVT',
470: 'CREATE_RS_SRP_TERRITORIES',
471: 'M',
472: 'M')
476: x_return_status => x_return_status) )
477: THEN
478:
479: /* Get the bind data id for the Business Object Instance */
480: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
481:
482: /* Set bind values for the bind variables in the Business Object SQL */
483: jtf_usr_hks.load_bind_data(l_bind_data_id, 'salesrep_territory_id', l_salesrep_territory_id, 'S', 'N');
484:
479: /* Get the bind data id for the Business Object Instance */
480: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
481:
482: /* Set bind values for the bind variables in the Business Object SQL */
483: jtf_usr_hks.load_bind_data(l_bind_data_id, 'salesrep_territory_id', l_salesrep_territory_id, 'S', 'N');
484:
485: /* Call the message generation API */
486: jtf_usr_hks.generate_message(
487: p_prod_code => 'JTF',
482: /* Set bind values for the bind variables in the Business Object SQL */
483: jtf_usr_hks.load_bind_data(l_bind_data_id, 'salesrep_territory_id', l_salesrep_territory_id, 'S', 'N');
484:
485: /* Call the message generation API */
486: jtf_usr_hks.generate_message(
487: p_prod_code => 'JTF',
488: p_bus_obj_code => 'RS_SRT',
489: p_action_code => 'I',
490: p_bind_data_id => l_bind_data_id,
653: --Make the pre processing call to the user hooks
654:
655: --Pre Call to the Customer Type User Hook
656:
657: IF jtf_usr_hks.ok_to_execute(
658: 'JTF_RS_SRP_TERRITORIES_PVT',
659: 'UPDATE_RS_SRP_TERRITORIES',
660: 'B',
661: 'C')
680: END IF;
681:
682: --Pre Call to the Vertical Type User Hook
683:
684: IF jtf_usr_hks.ok_to_execute(
685: 'JTF_RS_SRP_TERRITORIES_PVT',
686: 'UPDATE_RS_SRP_TERRITORIES',
687: 'B',
688: 'V')
707: END IF;
708:
709: --Pre Call to the Internal Type User Hook
710:
711: IF jtf_usr_hks.ok_to_execute(
712: 'JTF_RS_SRP_TERRITORIES_PVT',
713: 'UPDATE_RS_SRP_TERRITORIES',
714: 'B',
715: 'I')
929: --Make the post processing call to the user hooks
930:
931: --Post Call to the Customer Type User Hook
932:
933: IF jtf_usr_hks.ok_to_execute(
934: 'JTF_RS_SRP_TERRITORIES_PVT',
935: 'UPDATE_RS_SRP_TERRITORIES',
936: 'A',
937: 'C')
956: END IF;
957:
958: --Post Call to the Vertical Type User Hook
959:
960: IF jtf_usr_hks.ok_to_execute(
961: 'JTF_RS_SRP_TERRITORIES_PVT',
962: 'UPDATE_RS_SRP_TERRITORIES',
963: 'A',
964: 'V')
983: END IF;
984:
985: --Post Call to the Internal Type User Hook
986:
987: IF jtf_usr_hks.ok_to_execute(
988: 'JTF_RS_SRP_TERRITORIES_PVT',
989: 'UPDATE_RS_SRP_TERRITORIES',
990: 'A',
991: 'I')
1010: END IF;
1011:
1012: /* Standard call for Message Generation */
1013:
1014: IF jtf_usr_hks.ok_to_execute(
1015: 'JTF_RS_SRP_TERRITORIES_PVT',
1016: 'UPDATE_RS_SRP_TERRITORIES',
1017: 'M',
1018: 'M')
1022: x_return_status => x_return_status) )
1023: THEN
1024:
1025: /* Get the bind data id for the Business Object Instance */
1026: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
1027: /* Set bind values for the bind variables in the Business Object SQL */
1028: jtf_usr_hks.load_bind_data(l_bind_data_id, 'salesrep_territory_id', p_salesrep_territory_id, 'S', 'N');
1029:
1030: /* Call the message generation API */
1024:
1025: /* Get the bind data id for the Business Object Instance */
1026: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
1027: /* Set bind values for the bind variables in the Business Object SQL */
1028: jtf_usr_hks.load_bind_data(l_bind_data_id, 'salesrep_territory_id', p_salesrep_territory_id, 'S', 'N');
1029:
1030: /* Call the message generation API */
1031: jtf_usr_hks.generate_message(
1032: p_prod_code => 'JTF',
1027: /* Set bind values for the bind variables in the Business Object SQL */
1028: jtf_usr_hks.load_bind_data(l_bind_data_id, 'salesrep_territory_id', p_salesrep_territory_id, 'S', 'N');
1029:
1030: /* Call the message generation API */
1031: jtf_usr_hks.generate_message(
1032: p_prod_code => 'JTF',
1033: p_bus_obj_code => 'RS_SRT',
1034: p_action_code => 'U',
1035: p_bind_data_id => l_bind_data_id,