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 96: jty_changed_terrs_s.nextval

92: ,A.PROCESS_ATTR_VALUES_FLAG
93: ,A.MATCHING_SQL_FLAG
94: ,A.HIER_PROCESSING_FLAG)
95: VALUES (
96: jty_changed_terrs_s.nextval
97: ,0
98: ,S.terr_id
99: ,S.source_id
100: ,'UPDATE'

Line 137: jty_changed_terrs_s.nextval

133: ,A.PROCESS_ATTR_VALUES_FLAG
134: ,A.MATCHING_SQL_FLAG
135: ,A.HIER_PROCESSING_FLAG)
136: VALUES (
137: jty_changed_terrs_s.nextval
138: ,0
139: ,S.terr_id
140: ,S.source_id
141: ,'UPDATE'

Line 172: jty_changed_terrs_s.nextval

168: ,A.PROCESS_ATTR_VALUES_FLAG
169: ,A.MATCHING_SQL_FLAG
170: ,A.HIER_PROCESSING_FLAG)
171: VALUES (
172: jty_changed_terrs_s.nextval
173: ,0
174: ,S.terr_id
175: ,S.source_id
176: ,'UPDATE'

Line 208: jty_changed_terrs_s.nextval

204: ,A.PROCESS_ATTR_VALUES_FLAG
205: ,A.MATCHING_SQL_FLAG
206: ,A.HIER_PROCESSING_FLAG)
207: VALUES (
208: jty_changed_terrs_s.nextval
209: ,0
210: ,S.terr_id
211: ,S.source_id
212: ,'UPDATE'

Line 243: jty_changed_terrs_s.nextval

239: ,A.PROCESS_ATTR_VALUES_FLAG
240: ,A.MATCHING_SQL_FLAG
241: ,A.HIER_PROCESSING_FLAG)
242: VALUES (
243: jty_changed_terrs_s.nextval
244: ,0
245: ,S.terr_id
246: ,S.source_id
247: ,'UPDATE'

Line 277: jty_changed_terrs_s.nextval

273: ,A.PROCESS_ATTR_VALUES_FLAG
274: ,A.MATCHING_SQL_FLAG
275: ,A.HIER_PROCESSING_FLAG)
276: VALUES (
277: jty_changed_terrs_s.nextval
278: ,0
279: ,S.terr_id
280: ,'DELETE'
281: ,'N'

Line 359: jty_changed_terrs_s.nextval

355: ,PROCESS_ATTR_VALUES_FLAG
356: ,MATCHING_SQL_FLAG
357: ,HIER_PROCESSING_FLAG)
358: VALUES (
359: jty_changed_terrs_s.nextval
360: ,0
361: ,l_terr_id
362: ,l_source_id
363: ,'UPDATE'

Line 420: jty_changed_terrs_s.nextval

416: ,PROCESS_ATTR_VALUES_FLAG
417: ,MATCHING_SQL_FLAG
418: ,HIER_PROCESSING_FLAG)
419: VALUES (
420: jty_changed_terrs_s.nextval
421: ,0
422: ,p_terr_id
423: ,l_source_id
424: ,'UPDATE'

Line 489: jty_changed_terrs_s.nextval

485: ,PROCESS_ATTR_VALUES_FLAG
486: ,MATCHING_SQL_FLAG
487: ,HIER_PROCESSING_FLAG)
488: VALUES (
489: jty_changed_terrs_s.nextval
490: ,0
491: ,p_terr_id
492: ,l_source_id
493: ,'UPDATE'

Line 562: jty_changed_terrs_s.nextval

558: ,PROCESS_ATTR_VALUES_FLAG
559: ,MATCHING_SQL_FLAG
560: ,HIER_PROCESSING_FLAG)
561: VALUES (
562: jty_changed_terrs_s.nextval
563: ,0
564: ,l_terr_id
565: ,l_source_id
566: ,'UPDATE'

Line 626: jty_changed_terrs_s.nextval

622: ,PROCESS_ATTR_VALUES_FLAG
623: ,MATCHING_SQL_FLAG
624: ,HIER_PROCESSING_FLAG)
625: VALUES (
626: jty_changed_terrs_s.nextval
627: ,0
628: ,p_terr_id
629: ,l_source_id
630: ,'UPDATE'

Line 674: jty_changed_terrs_s.nextval

670: ,A.PROCESS_ATTR_VALUES_FLAG
671: ,A.MATCHING_SQL_FLAG
672: ,A.HIER_PROCESSING_FLAG)
673: VALUES (
674: jty_changed_terrs_s.nextval
675: ,0
676: ,S.terr_id
677: ,S.source_id
678: ,'CREATE'

Line 702: jty_changed_terrs_s.nextval

698: ,A.PROCESS_ATTR_VALUES_FLAG
699: ,A.MATCHING_SQL_FLAG
700: ,A.HIER_PROCESSING_FLAG)
701: VALUES (
702: jty_changed_terrs_s.nextval
703: ,0
704: ,S.terr_id
705: ,S.source_id
706: ,'DELETE'