DBA Data[Home] [Help]

APPS.JTY_TERR_TRIGGER_HANDLERS dependencies on JTY_CHANGED_DEA_TERRS_S

Line 75: jty_changed_dea_terrs_s.nextval

71: ,PROCESS_ATTR_VALUES_FLAG
72: ,MATCHING_SQL_FLAG
73: ,HIER_PROCESSING_FLAG)
74: VALUES (
75: jty_changed_dea_terrs_s.nextval
76: ,0
77: ,p_terr_id
78: ,'CREATE'
79: ,'Y'

Line 152: jty_changed_dea_terrs_s.nextval

148: ,A.PROCESS_ATTR_VALUES_FLAG
149: ,A.MATCHING_SQL_FLAG
150: ,A.HIER_PROCESSING_FLAG)
151: VALUES (
152: jty_changed_dea_terrs_s.nextval
153: ,0
154: ,S.terr_id
155: ,S.source_id
156: ,'UPDATE'

Line 230: jty_changed_dea_terrs_s.nextval

226: ,A.PROCESS_ATTR_VALUES_FLAG
227: ,A.MATCHING_SQL_FLAG
228: ,A.HIER_PROCESSING_FLAG)
229: VALUES (
230: jty_changed_dea_terrs_s.nextval
231: ,0
232: ,S.terr_id
233: ,S.source_id
234: ,'UPDATE'

Line 296: jty_changed_dea_terrs_s.nextval

292: ,A.PROCESS_ATTR_VALUES_FLAG
293: ,A.MATCHING_SQL_FLAG
294: ,A.HIER_PROCESSING_FLAG)
295: VALUES (
296: jty_changed_dea_terrs_s.nextval
297: ,0
298: ,S.terr_id
299: ,S.source_id
300: ,'UPDATE'

Line 364: jty_changed_dea_terrs_s.nextval

360: ,A.PROCESS_ATTR_VALUES_FLAG
361: ,A.MATCHING_SQL_FLAG
362: ,A.HIER_PROCESSING_FLAG)
363: VALUES (
364: jty_changed_dea_terrs_s.nextval
365: ,0
366: ,S.terr_id
367: ,S.source_id
368: ,'UPDATE'

Line 431: jty_changed_dea_terrs_s.nextval

427: ,A.PROCESS_ATTR_VALUES_FLAG
428: ,A.MATCHING_SQL_FLAG
429: ,A.HIER_PROCESSING_FLAG)
430: VALUES (
431: jty_changed_dea_terrs_s.nextval
432: ,0
433: ,S.terr_id
434: ,S.source_id
435: ,'UPDATE'

Line 495: jty_changed_dea_terrs_s.nextval

491: ,A.PROCESS_ATTR_VALUES_FLAG
492: ,A.MATCHING_SQL_FLAG
493: ,A.HIER_PROCESSING_FLAG)
494: VALUES (
495: jty_changed_dea_terrs_s.nextval
496: ,0
497: ,S.terr_id
498: ,S.source_id
499: ,'UPDATE'

Line 527: jty_changed_dea_terrs_s.nextval

523: ,A.PROCESS_ATTR_VALUES_FLAG
524: ,A.MATCHING_SQL_FLAG
525: ,A.HIER_PROCESSING_FLAG)
526: VALUES (
527: jty_changed_dea_terrs_s.nextval
528: ,0
529: ,S.terr_id
530: ,S.source_id
531: ,'UPDATE'

Line 591: jty_changed_dea_terrs_s.nextval

587: ,A.PROCESS_ATTR_VALUES_FLAG
588: ,A.MATCHING_SQL_FLAG
589: ,A.HIER_PROCESSING_FLAG)
590: VALUES (
591: jty_changed_dea_terrs_s.nextval
592: ,0
593: ,S.terr_id
594: ,'DELETE'
595: ,'N'

Line 716: jty_changed_dea_terrs_s.nextval

712: ,PROCESS_ATTR_VALUES_FLAG
713: ,MATCHING_SQL_FLAG
714: ,HIER_PROCESSING_FLAG)
715: VALUES (
716: jty_changed_dea_terrs_s.nextval
717: ,0
718: ,l_terr_id
719: ,l_source_id
720: ,'UPDATE'

Line 807: jty_changed_dea_terrs_s.nextval

803: ,PROCESS_ATTR_VALUES_FLAG
804: ,MATCHING_SQL_FLAG
805: ,HIER_PROCESSING_FLAG)
806: VALUES (
807: jty_changed_dea_terrs_s.nextval
808: ,0
809: ,p_terr_id
810: ,l_source_id
811: ,'UPDATE'

Line 921: jty_changed_dea_terrs_s.nextval

917: ,PROCESS_ATTR_VALUES_FLAG
918: ,MATCHING_SQL_FLAG
919: ,HIER_PROCESSING_FLAG)
920: VALUES (
921: jty_changed_dea_terrs_s.nextval
922: ,0
923: ,p_terr_id
924: ,l_source_id
925: ,'UPDATE'

Line 1023: jty_changed_dea_terrs_s.nextval

1019: ,PROCESS_ATTR_VALUES_FLAG
1020: ,MATCHING_SQL_FLAG
1021: ,HIER_PROCESSING_FLAG)
1022: VALUES (
1023: jty_changed_dea_terrs_s.nextval
1024: ,0
1025: ,l_terr_id
1026: ,l_source_id
1027: ,'UPDATE'

Line 1131: jty_changed_dea_terrs_s.nextval

1127: ,PROCESS_ATTR_VALUES_FLAG
1128: ,MATCHING_SQL_FLAG
1129: ,HIER_PROCESSING_FLAG)
1130: VALUES (
1131: jty_changed_dea_terrs_s.nextval
1132: ,0
1133: ,p_terr_id
1134: ,l_source_id
1135: ,'UPDATE'

Line 1207: jty_changed_dea_terrs_s.nextval

1203: ,A.PROCESS_ATTR_VALUES_FLAG
1204: ,A.MATCHING_SQL_FLAG
1205: ,A.HIER_PROCESSING_FLAG)
1206: VALUES (
1207: jty_changed_dea_terrs_s.nextval
1208: ,0
1209: ,S.terr_id
1210: ,S.source_id
1211: ,'CREATE'

Line 1263: jty_changed_dea_terrs_s.nextval

1259: ,A.PROCESS_ATTR_VALUES_FLAG
1260: ,A.MATCHING_SQL_FLAG
1261: ,A.HIER_PROCESSING_FLAG)
1262: VALUES (
1263: jty_changed_dea_terrs_s.nextval
1264: ,0
1265: ,S.terr_id
1266: ,S.source_id
1267: ,'DELETE'