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.BOM_REFERENCE_DESIGNATOR_API dependencies on BOM_REF_DESGS_INTERFACE

Line 11: | BOM_REF_DESGS_INTERFACE table. |

7: | |
8: | File Name : BOMOIRDB.pls |
9: | DESCRIPTION : This package contains functions used to assign, validate |
10: | and transact Reference Designator data in the |
11: | BOM_REF_DESGS_INTERFACE table. |
12: | Parameters: org_id organization_id |
13: | all_org process all orgs or just current org |
14: | 1 - all orgs |
15: | 2 - only org_id |

Line 37: BOM_REF_DESGS_INTERFACE

33: table
34: REQUIRES
35: err_text out buffer to return error message
36: MODIFIES
37: BOM_REF_DESGS_INTERFACE
38: MTL_INTERFACE_ERRORS
39: RETURNS
40: 0 if successful
41: SQLCODE if unsuccessful

Line 77: FROM bom_ref_desgs_interface

73: assembly_item_number AIN, alternate_bom_designator ABD,
74: component_item_id CII, component_item_number CIN,
75: operation_seq_num OSN, transaction_type A,
76: to_char(effectivity_date,'YYYY/MM/DD HH24:MI:SS') ED
77: FROM bom_ref_desgs_interface
78: WHERE process_flag = 1
79: AND transaction_type in (G_Insert, G_Update, G_Delete)
80: AND (UPPER(interface_entity_type) = 'BILL'
81: OR interface_entity_type is null)

Line 93: FROM bom_ref_desgs_interface

89: */
90: CURSOR c2 IS
91: SELECT transaction_id TI, organization_id OI,
92: component_sequence_id CSI, transaction_type A
93: FROM bom_ref_desgs_interface
94: WHERE process_flag = 1
95: AND transaction_type in (G_Insert, G_Update, G_Delete)
96: AND (UPPER(interface_entity_type) = 'BILL'
97: OR interface_entity_type is null)

Line 109: FROM bom_ref_desgs_interface

105: */
106: /**************************** Removed code as a fix for 916428 ************
107: CURSOR c3 IS
108: SELECT component_sequence_id CSI
109: FROM bom_ref_desgs_interface
110: WHERE process_flag = 99
111: AND transaction_type in (G_Insert,G_Update)
112: AND (UPPER(interface_entity_type) = 'BILL'
113: OR interface_entity_type is null)

Line 124: UPDATE bom_ref_desgs_interface

120: BEGIN
121: /** G_INSERT is 'CREATE'. Update 'INSERT' to 'CREATE' **/
122: stmt_num := 0.5 ;
123: LOOP
124: UPDATE bom_ref_desgs_interface
125: SET transaction_type = G_Insert
126: WHERE process_flag = 1
127: AND upper(transaction_type) = 'INSERT'
128: AND rownum < G_rows_to_commit;

Line 138: UPDATE bom_ref_desgs_interface ori

134: ** ALL RECORDS - Assign Org Id
135: */
136: stmt_num := 1;
137: LOOP
138: UPDATE bom_ref_desgs_interface ori
139: SET organization_id = (SELECT organization_id
140: FROM mtl_parameters a
141: WHERE a.organization_code = ori.organization_code)
142: WHERE process_flag = 1

Line 161: UPDATE bom_ref_desgs_interface

157: ** ALL RECORDS - Assign transaction ids
158: */
159: stmt_num := 2;
160: LOOP
161: UPDATE bom_ref_desgs_interface
162: SET transaction_id = mtl_system_items_interface_s.nextval,
163: transaction_type = upper(transaction_type)
164: WHERE transaction_id is null
165: AND (UPPER(interface_entity_type) = 'BILL'

Line 196: tbl_name => 'BOM_REF_DESGS_INTERFACE',

192: prog_id => prog_id,
193: req_id => req_id,
194: trans_id => c1rec.TI,
195: error_text => err_text,
196: tbl_name => 'BOM_REF_DESGS_INTERFACE',
197: msg_name => 'BOM_ORG_ID_MISSING',
198: err_text => err_text);
199: UPDATE bom_ref_desgs_interface
200: SET process_flag = 3

Line 199: UPDATE bom_ref_desgs_interface

195: error_text => err_text,
196: tbl_name => 'BOM_REF_DESGS_INTERFACE',
197: msg_name => 'BOM_ORG_ID_MISSING',
198: err_text => err_text);
199: UPDATE bom_ref_desgs_interface
200: SET process_flag = 3
201: WHERE transaction_id = c1rec.TI;
202:
203: IF (ret_code <> 0) THEN

Line 231: tbl_name => 'BOM_REF_DESGS_INTERFACE',

227: prog_id => prog_id,
228: req_id => req_id,
229: trans_id => c1rec.TI,
230: error_text => err_text,
231: tbl_name => 'BOM_REF_DESGS_INTERFACE',
232: msg_name => 'BOM_ASSY_ITEM_MISSING',
233: err_text => err_text);
234: UPDATE bom_ref_desgs_interface
235: SET process_flag = 3

Line 234: UPDATE bom_ref_desgs_interface

230: error_text => err_text,
231: tbl_name => 'BOM_REF_DESGS_INTERFACE',
232: msg_name => 'BOM_ASSY_ITEM_MISSING',
233: err_text => err_text);
234: UPDATE bom_ref_desgs_interface
235: SET process_flag = 3
236: WHERE transaction_id = c1rec.TI;
237:
238: IF (ret_code <> 0) THEN

Line 269: tbl_name => 'BOM_REF_DESGS_INTERFACE',

265: prog_id => prog_id,
266: req_id => req_id,
267: trans_id => c1rec.TI,
268: error_text => err_text,
269: tbl_name => 'BOM_REF_DESGS_INTERFACE',
270: msg_name => 'BOM_BILL_SEQ_MISSING',
271: err_text => err_text);
272: UPDATE bom_ref_desgs_interface
273: SET process_flag = 3

Line 272: UPDATE bom_ref_desgs_interface

268: error_text => err_text,
269: tbl_name => 'BOM_REF_DESGS_INTERFACE',
270: msg_name => 'BOM_BILL_SEQ_MISSING',
271: err_text => err_text);
272: UPDATE bom_ref_desgs_interface
273: SET process_flag = 3
274: WHERE transaction_id = c1rec.TI;
275:
276: IF (ret_code <> 0) THEN

Line 305: tbl_name => 'BOM_REF_DESGS_INTERFACE',

301: prog_id => prog_id,
302: req_id => req_id,
303: trans_id => c1rec.TI,
304: error_text => err_text,
305: tbl_name => 'BOM_REF_DESGS_INTERFACE',
306: msg_name => 'BOM_COMP_ID_MISSING',
307: err_text => err_text);
308: UPDATE bom_ref_desgs_interface
309: SET process_flag = 3

Line 308: UPDATE bom_ref_desgs_interface

304: error_text => err_text,
305: tbl_name => 'BOM_REF_DESGS_INTERFACE',
306: msg_name => 'BOM_COMP_ID_MISSING',
307: err_text => err_text);
308: UPDATE bom_ref_desgs_interface
309: SET process_flag = 3
310: WHERE transaction_id = c1rec.TI;
311:
312: IF (ret_code <> 0) THEN

Line 342: tbl_name => 'BOM_REF_DESGS_INTERFACE',

338: prog_id => prog_id,
339: req_id => req_id,
340: trans_id => c1rec.TI,
341: error_text => err_text,
342: tbl_name => 'BOM_REF_DESGS_INTERFACE',
343: msg_name => 'BOM_COMP_SEQ_MISSING',
344: err_text => err_text);
345: UPDATE bom_ref_desgs_interface
346: SET process_flag = 3

Line 345: UPDATE bom_ref_desgs_interface

341: error_text => err_text,
342: tbl_name => 'BOM_REF_DESGS_INTERFACE',
343: msg_name => 'BOM_COMP_SEQ_MISSING',
344: err_text => err_text);
345: UPDATE bom_ref_desgs_interface
346: SET process_flag = 3
347: WHERE transaction_id = c1rec.TI;
348:
349: IF (ret_code <> 0) THEN

Line 356: UPDATE bom_ref_desgs_interface

352: GOTO continue_loop;
353: END;
354:
355: stmt_num := 8;
356: UPDATE bom_ref_desgs_interface
357: SET component_sequence_id = c1rec.CSI,
358: assembly_item_id = c1rec.AII,
359: component_item_id = c1rec.CII,
360: bill_sequence_id = c1rec.BSI,

Line 387: UPDATE bom_ref_desgs_interface

383: FOR c2rec in c2 LOOP
384: commit_cnt := commit_cnt + 1;
385: IF (c2rec.A = G_Insert) THEN
386: stmt_num := 11;
387: UPDATE bom_ref_desgs_interface
388: SET process_flag = 2, -- Changed from 99 to 2, bug 1342291
389: acd_type = null,
390: last_update_date = nvl(last_update_date,sysdate),
391: last_updated_by = nvl(last_updated_by,user_id),

Line 403: UPDATE bom_ref_desgs_interface

399: program_update_date = nvl(program_update_date, sysdate)
400: WHERE transaction_id = c2rec.TI;
401: ELSIF (c2rec.A = G_Update) THEN
402: stmt_num := 12;
403: UPDATE bom_ref_desgs_interface
404: SET process_flag = 2, -- Changed from 99 to 2, bug 1342291
405: last_update_date = nvl(last_update_date,sysdate),
406: last_updated_by = nvl(last_updated_by,user_id),
407: last_update_login = nvl(last_update_login, user_id)

Line 417: UPDATE bom_ref_desgs_interface

413: RETURN(SQLCODE);
414: END IF;
415: ELSIF (c2rec.A = G_Delete) THEN
416: stmt_num := 13;
417: UPDATE bom_ref_desgs_interface
418: SET process_flag = 2
419: WHERE transaction_id = c2rec.TI;
420:
421: IF (SQL%NOTFOUND) THEN

Line 455: UPDATE bom_ref_desgs_interface

451: stmt_num := 17;
452:
453: -- Only INSERTS and UPDATES have process_flag = 99
454:
455: UPDATE bom_ref_desgs_interface
456: SET transaction_id = dummy_txn,
457: process_flag = 2
458: WHERE component_sequence_id = c3rec.CSI
459: AND (UPPER(interface_entity_type) = 'BILL'

Line 516: FROM bom_reference_designators a, bom_ref_desgs_interface b

512: stmt_num := 1;
513: BEGIN
514: SELECT 1
515: INTO dummy
516: FROM bom_reference_designators a, bom_ref_desgs_interface b
517: WHERE b.transaction_id = trans_id
518: AND (b.transaction_type = G_Insert
519: OR (b.transaction_type= G_Update
520: AND b.new_designator is not null))

Line 541: FROM bom_ref_desgs_interface a

537: */
538: stmt_num := 2;
539: SELECT count(*)
540: INTO dummy
541: FROM bom_ref_desgs_interface a
542: WHERE transaction_id = trans_id
543: AND (transaction_type = G_Insert
544: OR (transaction_type= G_Update AND new_designator is not null))
545: AND (UPPER(a.interface_entity_type) = 'BILL'

Line 549: FROM bom_ref_desgs_interface b

545: AND (UPPER(a.interface_entity_type) = 'BILL'
546: OR a.interface_entity_type is null)
547: AND exists
548: (SELECT 'same designator'
549: FROM bom_ref_desgs_interface b
550: WHERE b.rowid <> a.rowid
551: AND (b.transaction_type = G_Insert
552: OR (b.transaction_type = G_Update
553: AND b.new_designator is not null))

Line 620: FROM bom_ref_desgs_interface

616:
617: stmt_num := 2;
618: SELECT count(*)
619: INTO int_ref_qty
620: FROM bom_ref_desgs_interface
621: WHERE component_sequence_id = cmp_seq_id
622: AND transaction_type = G_Insert
623: AND (UPPER(interface_entity_type) = 'BILL'
624: OR interface_entity_type is null)

Line 630: FROM bom_ref_desgs_interface

626:
627: stmt_num := 3;
628: SELECT count(*)
629: INTO int_del_ref_qty
630: FROM bom_ref_desgs_interface
631: WHERE component_sequence_id = cmp_seq_id
632: AND transaction_type = G_Delete
633: AND (UPPER(interface_entity_type) = 'BILL'
634: OR interface_entity_type is null)

Line 736: FROM bom_ref_desgs_interface

732: attribute14 A14,attribute15 A15,
733: request_id RI, program_application_id PAI, program_id PI,
734: program_update_date PUD, acd_type ACD,
735: transaction_id TI, transaction_type A
736: FROM bom_ref_desgs_interface
737: WHERE process_flag = 2
738: AND transaction_type in (G_Update, G_Delete)
739: AND (UPPER(interface_entity_type) = 'BILL'
740: OR interface_entity_type is null)

Line 749: FROM bom_ref_desgs_interface

745: CURSOR c1 IS
746: SELECT component_sequence_id CSI, count(*) CNT,
747: transaction_id TI, assembly_item_id AII,
748: organization_id OI
749: FROM bom_ref_desgs_interface
750: WHERE process_flag = 2
751: AND transaction_type in (G_Insert, G_Update)
752: AND (UPPER(interface_entity_type) = 'BILL'
753: OR interface_entity_type is null)

Line 762: FROM bom_ref_desgs_interface

758: */
759: CURSOR c3 IS
760: SELECT change_notice CN, transaction_id TI,
761: organization_id OI
762: FROM bom_ref_desgs_interface
763: WHERE process_flag = 2
764: AND transaction_type in (G_Insert)
765: AND (UPPER(interface_entity_type) = 'BILL'
766: OR interface_entity_type is null);

Line 825: tbl_name => 'BOM_REF_DESGS_INTERFACE',

821: prog_id => prog_id,
822: req_id => req_id,
823: trans_id => c2rec.TI,
824: error_text => err_text,
825: tbl_name => 'BOM_REF_DESGS_INTERFACE',
826: msg_name => 'BOM_REF_DESG_RECORD_MISSING',
827: err_text => err_text);
828:
829: UPDATE bom_ref_desgs_interface

Line 829: UPDATE bom_ref_desgs_interface

825: tbl_name => 'BOM_REF_DESGS_INTERFACE',
826: msg_name => 'BOM_REF_DESG_RECORD_MISSING',
827: err_text => err_text);
828:
829: UPDATE bom_ref_desgs_interface
830: SET process_flag = 3
831: WHERE transaction_id = c2rec.TI;
832:
833: IF (ret_code <> 0) THEN

Line 859: tbl_name => 'BOM_REF_DESGS_INTERFACE',

855: prog_id => prog_id,
856: req_id => req_id,
857: trans_id => c2rec.TI,
858: error_text => err_text,
859: tbl_name => 'BOM_REF_DESGS_INTERFACE',
860: msg_name => 'BOM_COLUMN_NOT_UPDATABLE',
861: err_text => err_text);
862:
863: UPDATE bom_ref_desgs_interface

Line 863: UPDATE bom_ref_desgs_interface

859: tbl_name => 'BOM_REF_DESGS_INTERFACE',
860: msg_name => 'BOM_COLUMN_NOT_UPDATABLE',
861: err_text => err_text);
862:
863: UPDATE bom_ref_desgs_interface
864: SET process_flag = 3
865: WHERE transaction_id = c2rec.TI;
866:
867: IF (ret_code <> 0) THEN

Line 876: UPDATE bom_ref_desgs_interface

872: /*
873: ** Update interface record with production record's values
874: */
875: stmt_num := 3;
876: UPDATE bom_ref_desgs_interface
877: SET creation_date = X_creation_date,
878: created_by = X_created_by,
879: ref_designator_comment = nvl(c2rec.RDC,
880: X_ref_designator_comment),

Line 945: tbl_name => 'BOM_REF_DESGS_INTERFACE',

941: prog_id => prog_id,
942: req_id => req_id,
943: trans_id => c2rec.TI,
944: error_text => err_text,
945: tbl_name => 'BOM_REF_DESGS_INTERFACE',
946: msg_name => 'BOM_REF_DESG_COUNT_INVALID',
947: err_text => err_text);
948: UPDATE bom_ref_desgs_interface
949: SET process_flag = 3

Line 948: UPDATE bom_ref_desgs_interface

944: error_text => err_text,
945: tbl_name => 'BOM_REF_DESGS_INTERFACE',
946: msg_name => 'BOM_REF_DESG_COUNT_INVALID',
947: err_text => err_text);
948: UPDATE bom_ref_desgs_interface
949: SET process_flag = 3
950: WHERE transaction_id = c2rec.TI;
951:
952: IF (ret_code <> 0) THEN

Line 962: UPDATE bom_ref_desgs_interface

958: /*
959: ** Set Process Flag to 4 for "Deletes"
960: */
961: stmt_num := 5;
962: UPDATE bom_ref_desgs_interface
963: SET process_flag = 4
964: WHERE transaction_id = c2rec.TI;
965: END IF;
966: <>

Line 1008: tbl_name => 'BOM_REF_DESGS_INTERFACE',

1004: prog_id => prog_id,
1005: req_id => req_id,
1006: trans_id => c3rec.TI,
1007: error_text => err_text,
1008: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1009: msg_name => 'ENG_PARENTECO_NOT_EXIST',
1010: err_text => err_text);
1011: UPDATE bom_ref_desgs_interface
1012: SET process_flag = 3

Line 1011: UPDATE bom_ref_desgs_interface

1007: error_text => err_text,
1008: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1009: msg_name => 'ENG_PARENTECO_NOT_EXIST',
1010: err_text => err_text);
1011: UPDATE bom_ref_desgs_interface
1012: SET process_flag = 3
1013: WHERE transaction_id = c3rec.TI;
1014:
1015: IF (ret_code <> 0) THEN

Line 1043: FROM bom_ref_desgs_interface

1039:
1040: commit_cnt := commit_cnt + 1;
1041: SELECT count(*)
1042: INTO dummy
1043: FROM bom_ref_desgs_interface
1044: WHERE transaction_id = c1rec.TI
1045: AND component_reference_designator is null;
1046:
1047: IF (dummy = 0) THEN

Line 1059: tbl_name => 'BOM_REF_DESGS_INTERFACE',

1055: prog_id => prog_id,
1056: req_id => req_id,
1057: trans_id => c1rec.TI,
1058: error_text => err_text,
1059: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1060: msg_name => 'BOM_NULL_REF_DESGS',
1061: err_text => err_text);
1062: UPDATE bom_ref_desgs_interface
1063: SET process_flag = 3

Line 1062: UPDATE bom_ref_desgs_interface

1058: error_text => err_text,
1059: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1060: msg_name => 'BOM_NULL_REF_DESGS',
1061: err_text => err_text);
1062: UPDATE bom_ref_desgs_interface
1063: SET process_flag = 3
1064: WHERE transaction_id = c1rec.TI;
1065:
1066: IF (ret_code <> 0) THEN

Line 1106: tbl_name => 'BOM_REF_DESGS_INTERFACE',

1102: prog_id => prog_id,
1103: req_id => req_id,
1104: trans_id => c1rec.TI,
1105: error_text => err_text,
1106: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1107: msg_name => 'BOM_COMP_SEQ_ID_INVALID',
1108: err_text => err_text);
1109: UPDATE bom_ref_desgs_interface
1110: SET process_flag = 3

Line 1109: UPDATE bom_ref_desgs_interface

1105: error_text => err_text,
1106: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1107: msg_name => 'BOM_COMP_SEQ_ID_INVALID',
1108: err_text => err_text);
1109: UPDATE bom_ref_desgs_interface
1110: SET process_flag = 3
1111: WHERE transaction_id = c1rec.TI;
1112:
1113: IF (ret_code <> 0) THEN

Line 1133: tbl_name => 'BOM_REF_DESGS_INTERFACE',

1129: prog_id => prog_id,
1130: req_id => req_id,
1131: trans_id => c1rec.TI,
1132: error_text => err_text,
1133: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1134: msg_name => 'BOM_NO_REF_DESGS_ALLOWED',
1135: err_text => err_text);
1136: UPDATE bom_ref_desgs_interface
1137: SET process_flag = 3

Line 1136: UPDATE bom_ref_desgs_interface

1132: error_text => err_text,
1133: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1134: msg_name => 'BOM_NO_REF_DESGS_ALLOWED',
1135: err_text => err_text);
1136: UPDATE bom_ref_desgs_interface
1137: SET process_flag = 3
1138: WHERE transaction_id = c1rec.TI;
1139:
1140: IF (ret_code <> 0) THEN

Line 1163: tbl_name => 'BOM_REF_DESGS_INTERFACE',

1159: prog_id => prog_id,
1160: req_id => req_id,
1161: trans_id => c1rec.TI,
1162: error_text => err_text,
1163: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1164: msg_name => 'BOM_DUPLICATE_REF_DESG',
1165: err_text => err_text);
1166: UPDATE bom_ref_desgs_interface
1167: SET process_flag = 3

Line 1166: UPDATE bom_ref_desgs_interface

1162: error_text => err_text,
1163: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1164: msg_name => 'BOM_DUPLICATE_REF_DESG',
1165: err_text => err_text);
1166: UPDATE bom_ref_desgs_interface
1167: SET process_flag = 3
1168: WHERE transaction_id = c1rec.TI;
1169:
1170: IF (ret_code <> 0) THEN

Line 1196: tbl_name => 'BOM_REF_DESGS_INTERFACE',

1192: prog_id => prog_id,
1193: req_id => req_id,
1194: trans_id => c1rec.TI,
1195: error_text => err_text,
1196: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1197: msg_name => 'BOM_REF_DESG_COUNT_INVALID',
1198: err_text => err_text);
1199: UPDATE bom_ref_desgs_interface
1200: SET process_flag = 3

Line 1199: UPDATE bom_ref_desgs_interface

1195: error_text => err_text,
1196: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1197: msg_name => 'BOM_REF_DESG_COUNT_INVALID',
1198: err_text => err_text);
1199: UPDATE bom_ref_desgs_interface
1200: SET process_flag = 3
1201: WHERE transaction_id = c1rec.TI;
1202:
1203: IF (ret_code <> 0) THEN

Line 1211: UPDATE bom_ref_desgs_interface

1207: END IF;
1208: END IF;
1209:
1210: stmt_num := 12;
1211: UPDATE bom_ref_desgs_interface
1212: SET process_flag = 4
1213: WHERE transaction_id = c1rec.TI;
1214:
1215: <>

Line 1240: table, BOM_REF_DESGS_INTERFACE, into the production table,

1236: NAME
1237: Transact_Reference_Designator
1238: DESCRIPTION
1239: Insert, update and delete reference designator data from the interface
1240: table, BOM_REF_DESGS_INTERFACE, into the production table,
1241: BOM_REFERENCE_DESIGNATORS.
1242: REQUIRES
1243: prog_appid Program application id
1244: prog_id Program id

Line 1250: BOM_REF_DESGS_INTERFACE

1246: user_id User id
1247: login_id Login id
1248: MODIFIES
1249: BOM_REFERENCE_DESIGNATORS
1250: BOM_REF_DESGS_INTERFACE
1251: RETURNS
1252: 0 if successful
1253: SQLCODE if error
1254: NOTES

Line 1284: FROM bom_ref_desgs_interface

1280: attribute11 A11, attribute12 A12, attribute13 A13,
1281: attribute14 A14, attribute15 A15, request_id RI,
1282: program_application_id PAI, program_id PI,
1283: program_update_date PUD, transaction_id TI
1284: FROM bom_ref_desgs_interface
1285: WHERE process_flag = 4
1286: AND transaction_type = G_Update
1287: AND (UPPER(interface_entity_type) = 'BILL'
1288: OR interface_entity_type is null)

Line 1296: FROM bom_ref_desgs_interface

1292: */
1293: CURSOR c2 IS
1294: SELECT component_sequence_id CSI, component_reference_designator CRD,
1295: transaction_id TI
1296: FROM bom_ref_desgs_interface
1297: WHERE process_flag = 4
1298: AND transaction_type = G_Delete
1299: AND (UPPER(interface_entity_type) = 'BILL'
1300: OR interface_entity_type is null)

Line 1371: FROM bom_ref_desgs_interface

1367: REQUEST_ID,
1368: PROGRAM_APPLICATION_ID,
1369: PROGRAM_ID ,
1370: PROGRAM_UPDATE_DATE
1371: FROM bom_ref_desgs_interface
1372: WHERE process_flag = 4
1373: AND transaction_type = G_Insert
1374: AND (UPPER(interface_entity_type) = 'BILL'
1375: OR interface_entity_type is null)

Line 1381: UPDATE bom_ref_desgs_interface brdi

1377:
1378: EXIT when SQL%NOTFOUND;
1379:
1380: stmt_num := 2;
1381: UPDATE bom_ref_desgs_interface brdi
1382: SET process_flag = 7
1383: WHERE process_flag = 4
1384: AND transaction_type = G_Insert
1385: AND (UPPER(interface_entity_type) = 'BILL'

Line 1400: Moved the UPDATE bom_ref_desgs_interface brdi outside

1396: END LOOP;
1397:
1398:
1399: /* Bug 1322500 :
1400: Moved the UPDATE bom_ref_desgs_interface brdi outside
1401: the LOOP as this was causing the Performance Issues when there are
1402: large number record in the interface table.
1403: This is due to the reason that for every 500 records inserted in
1404: the production table, the interface table is being updated once,

Line 1455: UPDATE bom_ref_desgs_interface

1451: WHERE component_sequence_id = c1rec.CSI
1452: AND component_reference_designator = c1rec.CRD;
1453:
1454: stmt_num := 4;
1455: UPDATE bom_ref_desgs_interface
1456: SET process_flag = 7
1457: WHERE transaction_id = c1rec.TI;
1458: END LOOP;
1459:

Line 1482: UPDATE bom_ref_desgs_interface

1478: WHERE component_sequence_id = c2rec.CSI
1479: AND component_reference_designator = c2rec.CRD;
1480:
1481: stmt_num := 7;
1482: UPDATE bom_ref_desgs_interface
1483: SET process_flag = 7
1484: WHERE transaction_id = c2rec.TI;
1485: END LOOP;
1486:

Line 1513: interface table, BOM_REF_DESGS_INTERFACE.

1509: NAME
1510: Import_Reference_Designator
1511: DESCRIPTION
1512: Assign, Validate, and Transact the Reference Designator record in the
1513: interface table, BOM_REF_DESGS_INTERFACE.
1514: REQUIRES
1515: err_text out buffer to return error message
1516: MODIFIES
1517: RETURNS

Line 1592: DELETE from bom_ref_desgs_interface

1588:
1589: stmt_num := 4;
1590: IF (del_rec_flag = 1) THEN
1591: LOOP
1592: DELETE from bom_ref_desgs_interface
1593: WHERE process_flag = 7
1594: AND (UPPER(interface_entity_type) = 'BILL'
1595: OR interface_entity_type is null)
1596: AND rownum < G_rows_to_commit;