eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERR_TRIGGER_HANDLERS dependencies on JTF_CHANGED_TERR

Line 84: -- only add / modify records in jtf_changed_terr all

80: -- l_terr_value_id := terr_value_id;
81: --l_parent_territory_id := o_parent_territory_id;
82:
83: -- check source of current territory
84: -- only add / modify records in jtf_changed_terr all
85: BEGIN
86: --dbms_output.put_line('JTF_TERR_TRIGGER_HANDLER: (TERR_VAL) terr_id = ' || l_terr_id);
87: Select source_id into l_source_id
88: from jtf_terr_usgs

Line 101: from JTF_CHANGED_TERR

97: -- CHECK IF CHANGED_TERR record already exist
98: -- Terr_id header change record
99: BEGIN
100: Select terr_id into exist_terr_id
101: from JTF_CHANGED_TERR
102: where terr_id = l_terr_id
103: and terr_rsc_id is null
104: and terr_qtype_usg_id is null
105: and terr_rsc_access_id is null

Line 120: -- Write to JTF_CHANGED_TERR table in appropriate fasion

116: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error checking for existing terr record(1): ' || sqlerrm);
117: null;
118: End;
119:
120: -- Write to JTF_CHANGED_TERR table in appropriate fasion
121: If Trigger_Mode = 'ON-INSERT' then
122: --dbms_output.put_line('Terr_Exist: ' || Terr_Exist);
123:
124: If Changed_Terr_rec_Exist = 'True' then

Line 125: --dbms_output.put_line('JTDT- Updating record to JTF_CHANGED_TERR');

121: If Trigger_Mode = 'ON-INSERT' then
122: --dbms_output.put_line('Terr_Exist: ' || Terr_Exist);
123:
124: If Changed_Terr_rec_Exist = 'True' then
125: --dbms_output.put_line('JTDT- Updating record to JTF_CHANGED_TERR');
126: -- TEST results:
127: -- This should nver happen
128: BEGIN
129: UPDATE JTF_CHANGED_TERR

Line 129: UPDATE JTF_CHANGED_TERR

125: --dbms_output.put_line('JTDT- Updating record to JTF_CHANGED_TERR');
126: -- TEST results:
127: -- This should nver happen
128: BEGIN
129: UPDATE JTF_CHANGED_TERR
130: SET -- terr_id = terr_id,
131: Action = 'UPDATE_RECORD',
132: Trigger_mode = 'ON-INSERT',
133: NEW_last_update_date = n_last_update_date,

Line 159: --dbms_output.put_line('JTDT- Inserting record to JTF_CHANGED_TERR');

155: End;
156: Else -- Terr_Exist = False -- New Territory Added
157: -- TEST results:
158: BEGIN
159: --dbms_output.put_line('JTDT- Inserting record to JTF_CHANGED_TERR');
160: INSERT INTO JTF_CHANGED_TERR
161: (terr_id, org_id, Action, Trigger_mode, NEW_last_update_date, NEW_last_updated_by,
162: NEW_creation_date, NEW_created_by, NEW_last_update_login, NEW_start_date_active,
163: NEW_end_date_active, NEW_rank, NEW_update_flag, NEW_num_winners, NEW_parent_territory_id)

Line 160: INSERT INTO JTF_CHANGED_TERR

156: Else -- Terr_Exist = False -- New Territory Added
157: -- TEST results:
158: BEGIN
159: --dbms_output.put_line('JTDT- Inserting record to JTF_CHANGED_TERR');
160: INSERT INTO JTF_CHANGED_TERR
161: (terr_id, org_id, Action, Trigger_mode, NEW_last_update_date, NEW_last_updated_by,
162: NEW_creation_date, NEW_created_by, NEW_last_update_login, NEW_start_date_active,
163: NEW_end_date_active, NEW_rank, NEW_update_flag, NEW_num_winners, NEW_parent_territory_id)
164: values

Line 179: -- Execute_SQL_STRING := 'UPDATE JTF_CHANGED_TERR SET ';

175: -- (Territory Modified) items that may change:
176: -- start_date_active, end_date_active, rank, update_flag
177: -- Build update string based on what has actually been modified
178: -- If something didn't get modified, we'd still have it in the new field, so forget this dynamic SQL generation
179: -- Execute_SQL_STRING := 'UPDATE JTF_CHANGED_TERR SET ';
180: If Changed_Terr_rec_Exist = 'True' then
181: BEGIN
182: UPDATE JTF_CHANGED_TERR
183: SET Action = 'UPDATED_RECORD',

Line 182: UPDATE JTF_CHANGED_TERR

178: -- If something didn't get modified, we'd still have it in the new field, so forget this dynamic SQL generation
179: -- Execute_SQL_STRING := 'UPDATE JTF_CHANGED_TERR SET ';
180: If Changed_Terr_rec_Exist = 'True' then
181: BEGIN
182: UPDATE JTF_CHANGED_TERR
183: SET Action = 'UPDATED_RECORD',
184: Trigger_mode = 'ON-UPDATE',
185: -- OLD_last_update_date = o_last_update_date,
186: -- OLD_last_updated_by = o_last_updated_by,

Line 224: INSERT INTO JTF_CHANGED_TERR

220: Else -- Changed_Terr_rec_Exist = 'False'
221: -- New Territory Added
222: -- TEST results:
223: BEGIN
224: INSERT INTO JTF_CHANGED_TERR
225: (terr_id, org_id, Action, Trigger_mode,
226: OLD_last_update_date, OLD_last_updated_by,
227: OLD_creation_date, OLD_created_by, OLD_last_update_login, OLD_start_date_active,
228: OLD_end_date_active, OLD_rank, OLD_update_flag, OLD_num_winners, OLD_parent_territory_id,

Line 252: DELETE from JTF_CHANGED_TERR

248: If Changed_Terr_rec_Exist = 'True' then
249: -- This means that there exists either a INSERT or MODIFY changed_terr record.
250: -- We delete this record of the INSERT or MODIFY, it is no longer needed
251: BEGIN
252: DELETE from JTF_CHANGED_TERR
253: WHERE terr_id = l_terr_id
254: /* -- because we want to kill all records relating to this deleted territory
255: and terr_rsc_id is null
256: and terr_qtype_usg_id is null

Line 266: -- Now insert the jtf_changed_terr record documenting the deletion of this territory.

262: null;
263: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr' || sqlerrm);
264: End;
265: Else -- Changed_Terr_rec_Exist = 'False'
266: -- Now insert the jtf_changed_terr record documenting the deletion of this territory.
267: BEGIN
268: INSERT INTO JTF_CHANGED_TERR
269: (terr_id, org_id, Action, Trigger_mode, OLD_last_update_date, OLD_last_updated_by,
270: OLD_creation_date, OLD_created_by, OLD_last_update_login, OLD_start_date_active,

Line 268: INSERT INTO JTF_CHANGED_TERR

264: End;
265: Else -- Changed_Terr_rec_Exist = 'False'
266: -- Now insert the jtf_changed_terr record documenting the deletion of this territory.
267: BEGIN
268: INSERT INTO JTF_CHANGED_TERR
269: (terr_id, org_id, Action, Trigger_mode, OLD_last_update_date, OLD_last_updated_by,
270: OLD_creation_date, OLD_created_by, OLD_last_update_login, OLD_start_date_active,
271: OLD_end_date_active, OLD_rank, OLD_update_flag, OLD_num_winners, OLD_parent_territory_id)
272: values

Line 354: -- extracted terr_id, needed for jtf_changed_terr table

350:
351: l_terr_value_id := p_terr_value_id;
352: l_seeded_qualifier_id := l_seeded_qualifier_id;
353:
354: -- extracted terr_id, needed for jtf_changed_terr table
355: If TRIGGER_MODE = 'ON-DELETE' then
356: l_terr_qual_id := o_TERR_QUAL_ID;
357: Else
358: l_terr_qual_id := n_TERR_QUAL_ID;

Line 378: -- only add / modify records in jtf_changed_terr all

374: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while fetching terr_id from terr_value_id: ' || sqlerrm);
375:
376: End;
377: -- check source of current territory
378: -- only add / modify records in jtf_changed_terr all
379: BEGIN
380: --dbms_output.put_line('JTF_TERR_TRIGGER_HANDLER: (TERR_VAL) terr_id = ' || l_terr_id);
381: Select source_id into l_source_id
382: from jtf_terr_usgs

Line 396: from JTF_CHANGED_TERR

392: --dbms_output.put_line('JTDT- l_terr_id = ' || l_terr_id);
393: -- Check if CHANGED_TERR record already exists
394: BEGIN
395: Select terr_value_id into exist_terr_value_id
396: from JTF_CHANGED_TERR
397: where terr_rsc_id is null
398: and terr_qtype_usg_id is null
399: and terr_rsc_access_id is null
400: and terr_id = l_terr_id

Line 424: INSERT INTO JTF_CHANGED_TERR

420: null;
421: else -- Changed_Terr_Value_Rec_Exists = 'False'
422: -- Insert record
423: BEGIN
424: INSERT INTO JTF_CHANGED_TERR
425: (TERR_ID, TERR_VALUE_ID, ORG_ID, ACTION, TRIGGER_MODE,
426: OLD_LAST_UPDATED_BY, OLD_LAST_UPDATE_DATE, OLD_CREATED_BY, OLD_CREATION_DATE,
427: OLD_LAST_UPDATE_LOGIN, OLD_TERR_QUAL_ID, OLD_INCLUDE_FLAG, OLD_COMPARISON_OPERATOR,
428: OLD_ID_USED_FLAG, OLD_LOW_VALUE_CHAR_ID, OLD_LOW_VALUE_CHAR, OLD_HIGH_VALUE_CHAR,

Line 458: UPDATE JTF_CHANGED_TERR

454: elsif Trigger_mode = 'ON-UPDATE' then
455: If Changed_Terr_Value_Rec_Exists = 'True' then
456: -- Update only
457: BEGIN
458: UPDATE JTF_CHANGED_TERR
459: SET -- TERR_ID cannot be changed, as it is primary key
460: -- TERR_VALUE_ID = l_terr_value_id,
461: ACTION = 'UPDATED_RECORD',
462: TRIGGER_MODE = 'ON-UPDATE',

Line 516: INSERT INTO JTF_CHANGED_TERR

512: else
513: -- Changed_Terr_Value_Rec_Exists = 'False'
514: -- Insert record
515: BEGIN
516: INSERT INTO JTF_CHANGED_TERR
517: (TERR_ID, TERR_VALUE_ID, ACTION, TRIGGER_MODE,
518: OLD_LAST_UPDATED_BY, OLD_LAST_UPDATE_DATE, OLD_CREATED_BY, OLD_CREATION_DATE,
519: OLD_LAST_UPDATE_LOGIN, OLD_TERR_QUAL_ID, OLD_INCLUDE_FLAG, OLD_COMPARISON_OPERATOR,
520: OLD_ID_USED_FLAG, OLD_LOW_VALUE_CHAR_ID, OLD_LOW_VALUE_CHAR, OLD_HIGH_VALUE_CHAR,

Line 553: DELETE from JTF_CHANGED_TERR

549: If Changed_Terr_Value_Rec_Exists = 'True' then
550: -- This means that there exists either a INSERT or MODIFY changed_terr record.
551: -- We delete this record of the INSERT or MODIFY, it is no longer needed
552: BEGIN
553: DELETE from JTF_CHANGED_TERR
554: WHERE terr_id = l_terr_id
555: and TERR_VALUE_ID = l_TERR_VALUE_ID
556: and terr_rsc_id is null
557: and terr_qtype_usg_id is null

Line 568: INSERT INTO JTF_CHANGED_TERR

564: End;
565: else -- Changed_Terr_Value_Rec_Exists = 'False'
566: -- Insert record
567: BEGIN
568: INSERT INTO JTF_CHANGED_TERR
569: (TERR_ID, TERR_VALUE_ID, ACTION, TRIGGER_MODE,
570: OLD_LAST_UPDATED_BY, OLD_LAST_UPDATE_DATE, OLD_CREATED_BY, OLD_CREATION_DATE,
571: OLD_LAST_UPDATE_LOGIN, OLD_TERR_QUAL_ID, OLD_INCLUDE_FLAG, OLD_COMPARISON_OPERATOR,
572: OLD_ID_USED_FLAG, OLD_LOW_VALUE_CHAR_ID, OLD_LOW_VALUE_CHAR, OLD_HIGH_VALUE_CHAR,

Line 658: -- only add / modify records in jtf_changed_terr all

654: l_terr_id := p_terr_id;
655: l_terr_rsc_id := p_terr_rsc_id;
656:
657: -- check source of current territory
658: -- only add / modify records in jtf_changed_terr all
659: BEGIN
660: --dbms_output.put_line('JTF_TERR_TRIGGER_HANDLER: (TERR_RSC) terr_id = ' || l_terr_id);
661: Select source_id into l_source_id
662: from jtf_terr_usgs

Line 675: from JTF_CHANGED_TERR

671:
672: -- check if terr_rsc record exists
673: BEGIN
674: Select terr_rsc_id into exist_terr_rsc_id
675: from JTF_CHANGED_TERR
676: where terr_value_id is null
677: and terr_qtype_usg_id is null
678: and terr_rsc_access_id is null
679: and terr_rsc_id = l_terr_rsc_id

Line 698: INSERT INTO JTF_CHANGED_TERR

694: null;
695: else -- Changed_Terr_Value_Rec_Exists = 'False'
696: -- Insert record
697: BEGIN
698: INSERT INTO JTF_CHANGED_TERR
699: (TERR_ID, TERR_RSC_ID, ORG_ID, ACTION, TRIGGER_MODE,
700: OLD_LAST_UPDATE_DATE, OLD_LAST_UPDATED_BY, OLD_CREATION_DATE, OLD_CREATED_BY,
701: OLD_LAST_UPDATE_LOGIN, OLD_RESOURCE_ID, OLD_GROUP_ID, OLD_RESOURCE_TYPE,
702: OLD_ROLE, OLD_PRIMARY_CONTACT_FLAG, OLD_START_DATE_ACTIVE, OLD_END_DATE_ACTIVE,

Line 726: UPDATE JTF_CHANGED_TERR

722: elsif Trigger_mode = 'ON-UPDATE' then
723: If Terr_Rsc_Rec_Exists = 'True' then
724: -- Update only
725: BEGIN
726: UPDATE JTF_CHANGED_TERR
727: SET
728: -- TERR_RSC_ID = l_terr_rsc_id,
729: ACTION = 'UPDATED_RECORD',
730: Trigger_Mode = 'ON-UPDATE',

Line 771: INSERT INTO JTF_CHANGED_TERR

767: else
768: -- Changed_Terr_Value_Rec_Exists = 'False'
769: -- Insert record
770: BEGIN
771: INSERT INTO JTF_CHANGED_TERR
772: (TERR_ID, TERR_RSC_ID, ORG_ID, ACTION, TRIGGER_MODE,
773: OLD_LAST_UPDATE_DATE, OLD_LAST_UPDATED_BY, OLD_CREATION_DATE, OLD_CREATED_BY,
774: OLD_LAST_UPDATE_LOGIN, OLD_RESOURCE_ID, OLD_GROUP_ID, OLD_RESOURCE_TYPE,
775: OLD_ROLE, OLD_PRIMARY_CONTACT_FLAG, OLD_START_DATE_ACTIVE, OLD_END_DATE_ACTIVE,

Line 797: DELETE from JTF_CHANGED_TERR

793: End if;
794: else -- Trigger_mode = 'ON-DELETE'
795: If Terr_Rsc_Rec_Exists = 'True' then
796: BEGIN
797: DELETE from JTF_CHANGED_TERR
798: WHERE terr_id = l_terr_id
799: and TERR_RSC_ID = l_terr_rsc_id
800: and TERR_VALUE_ID is null
801: and terr_qtype_usg_id is null

Line 811: INSERT INTO JTF_CHANGED_TERR

807: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr rsc' || sqlerrm);
808: End;
809: else -- Changed_Terr_Value_Rec_Exists = 'False'
810: BEGIN
811: INSERT INTO JTF_CHANGED_TERR
812: (TERR_ID, TERR_RSC_ID, ORG_ID, ACTION, TRIGGER_MODE,
813: OLD_LAST_UPDATE_DATE, OLD_LAST_UPDATED_BY, OLD_CREATION_DATE, OLD_CREATED_BY,
814: OLD_LAST_UPDATE_LOGIN, OLD_RESOURCE_ID, OLD_GROUP_ID, OLD_RESOURCE_TYPE,
815: OLD_ROLE, OLD_PRIMARY_CONTACT_FLAG, OLD_START_DATE_ACTIVE, OLD_END_DATE_ACTIVE,

Line 884: -- only add / modify records in jtf_changed_terr all

880: l_terr_id := p_terr_id;
881: l_terr_qtype_usg_id := p_terr_qtype_usg_id;
882:
883: -- check source of current territory
884: -- only add / modify records in jtf_changed_terr all
885: BEGIN
886: --dbms_output.put_line('JTF_TERR_TRIGGER_HANDLER: (TERR_QTYPE) terr_id = ' || l_terr_id);
887: Select source_id into l_source_id
888: from jtf_terr_usgs

Line 902: from JTF_CHANGED_TERR

898:
899: -- Check if record already exists in changed_terr table
900: BEGIN
901: Select terr_qtype_usg_id into exist_terr_qtype_id
902: from JTF_CHANGED_TERR
903: where terr_value_id is null
904: and terr_rsc_id is null
905: and terr_rsc_access_id is null
906: and terr_qtype_usg_id = l_terr_qtype_usg_id

Line 930: INSERT INTO JTF_CHANGED_TERR

926: null;
927: else -- Changed_Terr_Value_Rec_Exists = 'False'
928: -- Insert record
929: BEGIN
930: INSERT INTO JTF_CHANGED_TERR
931: (TERR_ID, TERR_QTYPE_USG_ID, ORG_ID, ACTION, TRIGGER_MODE,
932: OLD_LAST_UPDATE_DATE, OLD_LAST_UPDATED_BY, OLD_CREATION_DATE, OLD_CREATED_BY, OLD_LAST_UPDATE_LOGIN,
933: NEW_LAST_UPDATE_DATE, NEW_LAST_UPDATED_BY, NEW_CREATION_DATE, NEW_CREATED_BY, NEW_LAST_UPDATE_LOGIN,
934: OLD_qual_type_usg_id, NEW_qual_type_usg_id)

Line 951: UPDATE JTF_CHANGED_TERR

947: elsif Trigger_mode = 'ON-UPDATE' then
948: If Changed_Terr_QType_Rec_Exists = 'True' then
949: -- Update only
950: BEGIN
951: UPDATE JTF_CHANGED_TERR
952: SET -- TERR_ID cannot be changed, as it is primary key
953: --TERR_QTYPE_USG_ID = l_terr_qtype_usg_id,
954: ACTION = 'UPDATED_RECORD',
955: Trigger_Mode = 'ON-UPDATE',

Line 983: INSERT INTO JTF_CHANGED_TERR

979: else
980: -- Changed_Terr_Value_Rec_Exists = 'False'
981: -- Insert record
982: BEGIN
983: INSERT INTO JTF_CHANGED_TERR
984: (TERR_ID, TERR_QTYPE_USG_ID, ORG_ID, ACTION, TRIGGER_MODE,
985: OLD_LAST_UPDATE_DATE, OLD_LAST_UPDATED_BY, OLD_CREATION_DATE, OLD_CREATED_BY, OLD_LAST_UPDATE_LOGIN,
986: NEW_LAST_UPDATE_DATE, NEW_LAST_UPDATED_BY, NEW_CREATION_DATE, NEW_CREATED_BY, NEW_LAST_UPDATE_LOGIN,
987: OLD_qual_type_usg_id, NEW_qual_type_usg_id)

Line 1003: DELETE from JTF_CHANGED_TERR

999: else
1000: -- Trigger_mode = 'ON-DELETE'
1001: If Changed_Terr_QType_Rec_Exists = 'True' then
1002: BEGIN
1003: DELETE from JTF_CHANGED_TERR
1004: WHERE terr_id = l_terr_id
1005: and terr_qtype_usg_id = l_terr_qtype_usg_id
1006: and TERR_RSC_ID is null
1007: and TERR_VALUE_ID is null

Line 1018: INSERT INTO JTF_CHANGED_TERR

1014: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr rsc' || sqlerrm);
1015: End;
1016: else -- Changed_Terr_Value_Rec_Exists = 'False'
1017: BEGIN
1018: INSERT INTO JTF_CHANGED_TERR
1019: (TERR_ID, TERR_QTYPE_USG_ID, ORG_ID, ACTION, TRIGGER_MODE,
1020: OLD_LAST_UPDATE_DATE, OLD_LAST_UPDATED_BY, OLD_CREATION_DATE, OLD_CREATED_BY, OLD_LAST_UPDATE_LOGIN,
1021: NEW_LAST_UPDATE_DATE, NEW_LAST_UPDATED_BY, NEW_CREATION_DATE, NEW_CREATED_BY, NEW_LAST_UPDATE_LOGIN,
1022: OLD_qual_type_usg_id, NEW_qual_type_usg_id)

Line 1096: -- only add / modify records in jtf_changed_terr all

1092: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error while fetching terr_id from terr_rsc_access_id: ' || sqlerrm);
1093: End;
1094:
1095: -- check source of current territory
1096: -- only add / modify records in jtf_changed_terr all
1097: BEGIN
1098: --dbms_output.put_line('JTF_TERR_TRIGGER_HANDLER: (TERR_RSC_ACCESS) terr_id = ' || l_terr_id);
1099: Select source_id into l_source_id
1100: from jtf_terr_usgs

Line 1114: from JTF_CHANGED_TERR

1110: --dbms_output.put_line('JTDT- l_terr_id = ' || l_terr_id);
1111: -- Check if record already exists in changed_terr table
1112: BEGIN
1113: Select terr_rsc_access_id into l_terr_rsc_access_id
1114: from JTF_CHANGED_TERR
1115: where terr_value_id is null
1116: and terr_rsc_id is null
1117: and terr_qtype_usg_id is null
1118: and terr_rsc_access_id = l_terr_rsc_access_id

Line 1142: INSERT INTO JTF_CHANGED_TERR

1138: null;
1139: else -- Changed_Terr_RscAccess_Rec_Exists = 'False'
1140: -- Insert record
1141: BEGIN
1142: INSERT INTO JTF_CHANGED_TERR
1143: (TERR_ID, TERR_RSC_ACCESS_ID, ORG_ID, ACTION, TRIGGER_MODE,
1144: OLD_LAST_UPDATE_DATE, OLD_LAST_UPDATED_BY, OLD_CREATION_DATE, OLD_CREATED_BY, OLD_LAST_UPDATE_LOGIN,
1145: NEW_LAST_UPDATE_DATE, NEW_LAST_UPDATED_BY, NEW_CREATION_DATE, NEW_CREATED_BY, NEW_LAST_UPDATE_LOGIN,
1146: OLD_ACCESS_TYPE, NEW_ACCESS_TYPE)

Line 1163: UPDATE JTF_CHANGED_TERR

1159: elsif Trigger_mode = 'ON-UPDATE' then
1160: If Changed_Terr_RscAcc_Rec_Exists = 'True' then
1161: -- Update only
1162: BEGIN
1163: UPDATE JTF_CHANGED_TERR
1164: SET -- TERR_ID cannot be changed, as it is primary key
1165: --TERR_RSC_ACCESS_ID = l_terr_rsc_access_id,
1166: ACTION = 'UPDATED_RECORD',
1167: Trigger_Mode = 'ON-UPDATE',

Line 1195: INSERT INTO JTF_CHANGED_TERR

1191: else
1192: -- Changed_Terr_RscAccess_Rec_Exists = 'False'
1193: -- Insert record
1194: BEGIN
1195: INSERT INTO JTF_CHANGED_TERR
1196: (TERR_ID, TERR_RSC_ACCESS_ID, ORG_ID, ACTION, TRIGGER_MODE,
1197: OLD_LAST_UPDATE_DATE, OLD_LAST_UPDATED_BY, OLD_CREATION_DATE, OLD_CREATED_BY, OLD_LAST_UPDATE_LOGIN,
1198: NEW_LAST_UPDATE_DATE, NEW_LAST_UPDATED_BY, NEW_CREATION_DATE, NEW_CREATED_BY, NEW_LAST_UPDATE_LOGIN,
1199: OLD_ACCESS_TYPE, NEW_ACCESS_TYPE)

Line 1215: DELETE from JTF_CHANGED_TERR

1211: else
1212: -- Trigger_mode = 'ON-DELETE'
1213: If Changed_Terr_RscAcc_Rec_Exists = 'True' then
1214: BEGIN
1215: DELETE from JTF_CHANGED_TERR
1216: WHERE terr_id = l_terr_id
1217: and TERR_RSC_ID is null
1218: and terr_rsc_access_id = l_terr_rsc_access_id
1219: and terr_qtype_usg_id is null

Line 1229: INSERT INTO JTF_CHANGED_TERR

1225: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr rsc' || sqlerrm);
1226: End;
1227: else -- Changed_Terr_RscAccess_Rec_Exists = 'False'
1228: BEGIN
1229: INSERT INTO JTF_CHANGED_TERR
1230: (TERR_ID, TERR_RSC_ACCESS_ID, ORG_ID, ACTION, TRIGGER_MODE,
1231: OLD_LAST_UPDATE_DATE, OLD_LAST_UPDATED_BY, OLD_CREATION_DATE, OLD_CREATED_BY, OLD_LAST_UPDATE_LOGIN,
1232: NEW_LAST_UPDATE_DATE, NEW_LAST_UPDATED_BY, NEW_CREATION_DATE, NEW_CREATED_BY, NEW_LAST_UPDATE_LOGIN,
1233: OLD_ACCESS_TYPE, NEW_ACCESS_TYPE)