DBA Data[Home] [Help]

APPS.JTY_TERR_TRIGGER_HANDLERS dependencies on JTY_CHANGED_TERRS_S

Line 56: jty_changed_terrs_s.nextval

52: ,PROCESS_ATTR_VALUES_FLAG
53: ,MATCHING_SQL_FLAG
54: ,HIER_PROCESSING_FLAG)
55: VALUES (
56: jty_changed_terrs_s.nextval
57: ,0
58: ,p_terr_id
59: ,'CREATE'
60: ,'Y'

Line 115: jty_changed_terrs_s.nextval

111: ,A.PROCESS_ATTR_VALUES_FLAG
112: ,A.MATCHING_SQL_FLAG
113: ,A.HIER_PROCESSING_FLAG)
114: VALUES (
115: jty_changed_terrs_s.nextval
116: ,0
117: ,S.terr_id
118: ,S.source_id
119: ,'UPDATE'

Line 193: jty_changed_terrs_s.nextval

189: ,A.PROCESS_ATTR_VALUES_FLAG
190: ,A.MATCHING_SQL_FLAG
191: ,A.HIER_PROCESSING_FLAG)
192: VALUES (
193: jty_changed_terrs_s.nextval
194: ,0
195: ,S.terr_id
196: ,S.source_id
197: ,'UPDATE'

Line 265: jty_changed_terrs_s.nextval

261: ,A.PROCESS_ATTR_VALUES_FLAG
262: ,A.MATCHING_SQL_FLAG
263: ,A.HIER_PROCESSING_FLAG)
264: VALUES (
265: jty_changed_terrs_s.nextval
266: ,0
267: ,S.terr_id
268: ,S.source_id
269: ,'UPDATE'

Line 332: jty_changed_terrs_s.nextval

328: ,A.PROCESS_ATTR_VALUES_FLAG
329: ,A.MATCHING_SQL_FLAG
330: ,A.HIER_PROCESSING_FLAG)
331: VALUES (
332: jty_changed_terrs_s.nextval
333: ,0
334: ,S.terr_id
335: ,S.source_id
336: ,'UPDATE'

Line 399: jty_changed_terrs_s.nextval

395: ,A.PROCESS_ATTR_VALUES_FLAG
396: ,A.MATCHING_SQL_FLAG
397: ,A.HIER_PROCESSING_FLAG)
398: VALUES (
399: jty_changed_terrs_s.nextval
400: ,0
401: ,S.terr_id
402: ,S.source_id
403: ,'UPDATE'

Line 463: jty_changed_terrs_s.nextval

459: ,A.PROCESS_ATTR_VALUES_FLAG
460: ,A.MATCHING_SQL_FLAG
461: ,A.HIER_PROCESSING_FLAG)
462: VALUES (
463: jty_changed_terrs_s.nextval
464: ,0
465: ,S.terr_id
466: ,S.source_id
467: ,'UPDATE'

Line 561: jty_changed_terrs_s.nextval

557: ,A.PROCESS_ATTR_VALUES_FLAG
558: ,A.MATCHING_SQL_FLAG
559: ,A.HIER_PROCESSING_FLAG)
560: VALUES (
561: jty_changed_terrs_s.nextval
562: ,0
563: ,S.terr_id
564: ,'DELETE'
565: ,'N'

Line 673: jty_changed_terrs_s.nextval

669: ,PROCESS_ATTR_VALUES_FLAG
670: ,MATCHING_SQL_FLAG
671: ,HIER_PROCESSING_FLAG)
672: VALUES (
673: jty_changed_terrs_s.nextval
674: ,0
675: ,l_terr_id
676: ,l_source_id
677: ,'UPDATE'

Line 778: jty_changed_terrs_s.nextval

774: ,PROCESS_ATTR_VALUES_FLAG
775: ,MATCHING_SQL_FLAG
776: ,HIER_PROCESSING_FLAG)
777: VALUES (
778: jty_changed_terrs_s.nextval
779: ,0
780: ,p_terr_id
781: ,l_source_id
782: ,'UPDATE'

Line 877: jty_changed_terrs_s.nextval

873: ,PROCESS_ATTR_VALUES_FLAG
874: ,MATCHING_SQL_FLAG
875: ,HIER_PROCESSING_FLAG)
876: VALUES (
877: jty_changed_terrs_s.nextval
878: ,0
879: ,p_terr_id
880: ,l_source_id
881: ,'UPDATE'

Line 994: jty_changed_terrs_s.nextval

990: ,PROCESS_ATTR_VALUES_FLAG
991: ,MATCHING_SQL_FLAG
992: ,HIER_PROCESSING_FLAG)
993: VALUES (
994: jty_changed_terrs_s.nextval
995: ,0
996: ,l_terr_id
997: ,l_source_id
998: ,'UPDATE'

Line 1088: jty_changed_terrs_s.nextval

1084: ,PROCESS_ATTR_VALUES_FLAG
1085: ,MATCHING_SQL_FLAG
1086: ,HIER_PROCESSING_FLAG)
1087: VALUES (
1088: jty_changed_terrs_s.nextval
1089: ,0
1090: ,p_terr_id
1091: ,l_source_id
1092: ,'UPDATE'

Line 1179: jty_changed_terrs_s.nextval

1175: ,A.PROCESS_ATTR_VALUES_FLAG
1176: ,A.MATCHING_SQL_FLAG
1177: ,A.HIER_PROCESSING_FLAG)
1178: VALUES (
1179: jty_changed_terrs_s.nextval
1180: ,0
1181: ,S.terr_id
1182: ,S.source_id
1183: ,'CREATE'

Line 1235: jty_changed_terrs_s.nextval

1231: ,A.PROCESS_ATTR_VALUES_FLAG
1232: ,A.MATCHING_SQL_FLAG
1233: ,A.HIER_PROCESSING_FLAG)
1234: VALUES (
1235: jty_changed_terrs_s.nextval
1236: ,0
1237: ,S.terr_id
1238: ,S.source_id
1239: ,'DELETE'