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_BPEL_SYNCBILLOFMATERIALSLI dependencies on BOM_BO_PUB

Line 64: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)

60: RETURN l_org_id;
61: END;
62: FUNCTION PL_TO_SQL_HEAD_REC
63: (
64: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
65: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE
66: IS
67: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE;
68: BEGIN

Line 65: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE

61: END;
62: FUNCTION PL_TO_SQL_HEAD_REC
63: (
64: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
65: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE
66: IS
67: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE;
68: BEGIN
69: -- initialize the object

Line 67: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE;

63: (
64: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
65: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE
66: IS
67: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE;
68: BEGIN
69: -- initialize the object
70: aSqlItem := BOM_BO_PUB_BOM_HEAD_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
71: aSqlItem.ASSEMBLY_ITEM_NAME := aPlsqlItem.ASSEMBLY_ITEM_NAME;

Line 70: aSqlItem := BOM_BO_PUB_BOM_HEAD_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

66: IS
67: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE;
68: BEGIN
69: -- initialize the object
70: aSqlItem := BOM_BO_PUB_BOM_HEAD_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
71: aSqlItem.ASSEMBLY_ITEM_NAME := aPlsqlItem.ASSEMBLY_ITEM_NAME;
72: aSqlItem.ORGANIZATION_ID := Get_Org_Id(aPlsqlItem.ORGANIZATION_CODE);
73: aSqlItem.ALTERNATE_BOM_CODE := aPlsqlItem.ALTERNATE_BOM_CODE;
74: aSqlItem.COMMON_ASSEMBLY_ITEM_NAME := aPlsqlItem.COMMON_ASSEMBLY_ITEM_NAME;

Line 105: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)

101: RETURN aSqlItem;
102: END PL_TO_SQL_HEAD_REC;
103: FUNCTION SQL_TO_PL_HEAD_REC
104: (
105: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
106: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE
107: IS
108: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE;
109: BEGIN

Line 106: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE

102: END PL_TO_SQL_HEAD_REC;
103: FUNCTION SQL_TO_PL_HEAD_REC
104: (
105: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
106: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE
107: IS
108: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE;
109: BEGIN
110: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;

Line 108: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE;

104: (
105: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
106: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE
107: IS
108: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE;
109: BEGIN
110: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;
111: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);
112: aPlsqlItem.ALTERNATE_BOM_CODE := aSqlItem.ALTERNATE_BOM_CODE;

Line 144: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)

140: RETURN aPlsqlItem;
141: END SQL_TO_PL_HEAD_REC;
142: FUNCTION PL_TO_SQL_REV_REC
143: (
144: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)
145: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE
146: IS
147: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE;
148: BEGIN

Line 145: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE

141: END SQL_TO_PL_HEAD_REC;
142: FUNCTION PL_TO_SQL_REV_REC
143: (
144: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)
145: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE
146: IS
147: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE;
148: BEGIN
149: -- initialize the object

Line 147: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE;

143: (
144: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)
145: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE
146: IS
147: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE;
148: BEGIN
149: -- initialize the object
150: aSqlItem := BOM_BO_PUB_BOM_REV_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
151: aSqlItem.ASSEMBLY_ITEM_NAME := aPlsqlItem.ASSEMBLY_ITEM_NAME;

Line 150: aSqlItem := BOM_BO_PUB_BOM_REV_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

146: IS
147: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE;
148: BEGIN
149: -- initialize the object
150: aSqlItem := BOM_BO_PUB_BOM_REV_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
151: aSqlItem.ASSEMBLY_ITEM_NAME := aPlsqlItem.ASSEMBLY_ITEM_NAME;
152: aSqlItem.ORGANIZATION_ID := Get_Org_Id(aPlsqlItem.ORGANIZATION_CODE);
153: aSqlItem.REVISION := aPlsqlItem.REVISION;
154: aSqlItem.REVISION_LABEL := aPlsqlItem.REVISION_LABEL;

Line 183: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)

179: RETURN aSqlItem;
180: END PL_TO_SQL_REV_REC;
181: FUNCTION SQL_TO_PL_REV_REC
182: (
183: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)
184: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE
185: IS
186: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE;
187: BEGIN

Line 184: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE

180: END PL_TO_SQL_REV_REC;
181: FUNCTION SQL_TO_PL_REV_REC
182: (
183: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)
184: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE
185: IS
186: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE;
187: BEGIN
188: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;

Line 186: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE;

182: (
183: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)
184: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE
185: IS
186: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE;
187: BEGIN
188: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;
189: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);
190: aPlsqlItem.REVISION := aSqlItem.REVISION;

Line 220: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)

216: RETURN aPlsqlItem;
217: END SQL_TO_PL_REV_REC;
218: FUNCTION PL_TO_SQL_REV_TBL
219: (
220: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)
221: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE
222: IS
223: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE;
224: BEGIN

Line 221: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE

217: END SQL_TO_PL_REV_REC;
218: FUNCTION PL_TO_SQL_REV_TBL
219: (
220: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)
221: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE
222: IS
223: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE;
224: BEGIN
225: -- initialize the table

Line 223: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE;

219: (
220: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)
221: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE
222: IS
223: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE;
224: BEGIN
225: -- initialize the table
226: aSqlItem := BOM_BO_PUB_BOM_REV_TBL_TYPE();
227: IF aPlsqlItem.COUNT > 0 THEN

Line 226: aSqlItem := BOM_BO_PUB_BOM_REV_TBL_TYPE();

222: IS
223: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE;
224: BEGIN
225: -- initialize the table
226: aSqlItem := BOM_BO_PUB_BOM_REV_TBL_TYPE();
227: IF aPlsqlItem.COUNT > 0 THEN
228: aSqlItem.EXTEND(aPlsqlItem.COUNT);
229: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST
230: LOOP

Line 238: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)

234: RETURN aSqlItem;
235: END PL_TO_SQL_REV_TBL;
236: FUNCTION SQL_TO_PL_REV_TBL
237: (
238: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)
239: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE
240: IS
241: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
242: BEGIN

Line 239: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE

235: END PL_TO_SQL_REV_TBL;
236: FUNCTION SQL_TO_PL_REV_TBL
237: (
238: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)
239: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE
240: IS
241: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
242: BEGIN
243: FOR I IN 1..aSqlItem.COUNT

Line 241: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE;

237: (
238: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)
239: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE
240: IS
241: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
242: BEGIN
243: FOR I IN 1..aSqlItem.COUNT
244: LOOP
245: aPlsqlItem(I) := SQL_TO_PL_REV_REC(aSqlItem(I));

Line 251: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)

247: RETURN aPlsqlItem;
248: END SQL_TO_PL_REV_TBL;
249: FUNCTION PL_TO_SQL_COMPS_REC
250: (
251: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)
252: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE
253: IS
254: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE;
255: BEGIN

Line 252: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE

248: END SQL_TO_PL_REV_TBL;
249: FUNCTION PL_TO_SQL_COMPS_REC
250: (
251: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)
252: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE
253: IS
254: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE;
255: BEGIN
256: -- initialize the object

Line 254: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE;

250: (
251: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)
252: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE
253: IS
254: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE;
255: BEGIN
256: -- initialize the object
257: aSqlItem := BOM_BO_PUB_BOM_COMPS_REC_TYPE(NULL,
258: NULL, NULL, NULL, NULL, NULL, NULL,

Line 257: aSqlItem := BOM_BO_PUB_BOM_COMPS_REC_TYPE(NULL,

253: IS
254: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE;
255: BEGIN
256: -- initialize the object
257: aSqlItem := BOM_BO_PUB_BOM_COMPS_REC_TYPE(NULL,
258: NULL, NULL, NULL, NULL, NULL, NULL,
259: NULL, NULL, NULL, NULL, NULL, NULL,
260: NULL, NULL, NULL, NULL, NULL, NULL,
261: NULL, NULL, NULL, NULL, NULL, NULL,

Line 330: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)

326: RETURN aSqlItem;
327: END PL_TO_SQL_COMPS_REC;
328: FUNCTION SQL_TO_PL_COMPS_REC
329: (
330: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)
331: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE
332: IS
333: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE;
334: BEGIN

Line 331: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE

327: END PL_TO_SQL_COMPS_REC;
328: FUNCTION SQL_TO_PL_COMPS_REC
329: (
330: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)
331: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE
332: IS
333: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE;
334: BEGIN
335: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);

Line 333: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE;

329: (
330: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)
331: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE
332: IS
333: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE;
334: BEGIN
335: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);
336: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;
337: aPlsqlItem.START_EFFECTIVE_DATE := aSqlItem.START_EFFECTIVE_DATE;

Line 397: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)

393: RETURN aPlsqlItem;
394: END SQL_TO_PL_COMPS_REC;
395: FUNCTION PL_TO_SQL_COMPS_TBL
396: (
397: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)
398: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE
399: IS
400: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
401: BEGIN

Line 398: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE

394: END SQL_TO_PL_COMPS_REC;
395: FUNCTION PL_TO_SQL_COMPS_TBL
396: (
397: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)
398: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE
399: IS
400: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
401: BEGIN
402: -- initialize the table

Line 400: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE;

396: (
397: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)
398: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE
399: IS
400: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
401: BEGIN
402: -- initialize the table
403: aSqlItem := BOM_BO_PUB_BOM_COMPS_TBL_TYPE();
404: IF aPlsqlItem.COUNT > 0 THEN

Line 403: aSqlItem := BOM_BO_PUB_BOM_COMPS_TBL_TYPE();

399: IS
400: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
401: BEGIN
402: -- initialize the table
403: aSqlItem := BOM_BO_PUB_BOM_COMPS_TBL_TYPE();
404: IF aPlsqlItem.COUNT > 0 THEN
405: aSqlItem.EXTEND(aPlsqlItem.COUNT);
406: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST
407: LOOP

Line 415: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)

411: RETURN aSqlItem;
412: END PL_TO_SQL_COMPS_TBL;
413: FUNCTION SQL_TO_PL_COMPS_TBL
414: (
415: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)
416: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE
417: IS
418: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
419: BEGIN

Line 416: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE

412: END PL_TO_SQL_COMPS_TBL;
413: FUNCTION SQL_TO_PL_COMPS_TBL
414: (
415: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)
416: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE
417: IS
418: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
419: BEGIN
420: FOR I IN 1..aSqlItem.COUNT

Line 418: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE;

414: (
415: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)
416: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE
417: IS
418: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
419: BEGIN
420: FOR I IN 1..aSqlItem.COUNT
421: LOOP
422: aPlsqlItem(I) := SQL_TO_PL_COMPS_REC(aSqlItem(I));

Line 428: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)

424: RETURN aPlsqlItem;
425: END SQL_TO_PL_COMPS_TBL;
426: FUNCTION PL_TO_SQL_RF_DES_REC
427: (
428: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)
429: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE
430: IS
431: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
432: BEGIN

Line 429: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE

425: END SQL_TO_PL_COMPS_TBL;
426: FUNCTION PL_TO_SQL_RF_DES_REC
427: (
428: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)
429: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE
430: IS
431: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
432: BEGIN
433: -- initialize the object

Line 431: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE;

427: (
428: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)
429: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE
430: IS
431: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
432: BEGIN
433: -- initialize the object
434: aSqlItem := BOM_BO_PUB_BOM_RF_DES_REC_TYPE(NULL, NULL,
435: NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 434: aSqlItem := BOM_BO_PUB_BOM_RF_DES_REC_TYPE(NULL, NULL,

430: IS
431: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
432: BEGIN
433: -- initialize the object
434: aSqlItem := BOM_BO_PUB_BOM_RF_DES_REC_TYPE(NULL, NULL,
435: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
436: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
437: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
438: NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Line 473: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)

469: RETURN aSqlItem;
470: END PL_TO_SQL_RF_DES_REC;
471: FUNCTION SQL_TO_PL_RF_DES_REC
472: (
473: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)
474: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
475: IS
476: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;
477: BEGIN

Line 474: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE

470: END PL_TO_SQL_RF_DES_REC;
471: FUNCTION SQL_TO_PL_RF_DES_REC
472: (
473: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)
474: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
475: IS
476: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;
477: BEGIN
478: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);

Line 476: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;

472: (
473: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)
474: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
475: IS
476: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;
477: BEGIN
478: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);
479: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;
480: aPlsqlItem.START_EFFECTIVE_DATE := aSqlItem.START_EFFECTIVE_DATE;

Line 512: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)

508: RETURN aPlsqlItem;
509: END SQL_TO_PL_RF_DES_REC;
510: FUNCTION PL_TO_SQL_RF_DES_TBL
511: (
512: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)
513: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE
514: IS
515: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
516: BEGIN

Line 513: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE

509: END SQL_TO_PL_RF_DES_REC;
510: FUNCTION PL_TO_SQL_RF_DES_TBL
511: (
512: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)
513: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE
514: IS
515: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
516: BEGIN
517: -- initialize the table

Line 515: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;

511: (
512: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)
513: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE
514: IS
515: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
516: BEGIN
517: -- initialize the table
518: aSqlItem := BOM_BO_PUB_BOM_RF_DES_TBL_TYPE();
519: IF aPlsqlItem.COUNT > 0 THEN

Line 518: aSqlItem := BOM_BO_PUB_BOM_RF_DES_TBL_TYPE();

514: IS
515: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
516: BEGIN
517: -- initialize the table
518: aSqlItem := BOM_BO_PUB_BOM_RF_DES_TBL_TYPE();
519: IF aPlsqlItem.COUNT > 0 THEN
520: aSqlItem.EXTEND(aPlsqlItem.COUNT);
521: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST
522: LOOP

Line 530: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)

526: RETURN aSqlItem;
527: END PL_TO_SQL_RF_DES_TBL;
528: FUNCTION SQL_TO_PL_RF_DES_TBL
529: (
530: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)
531: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
532: IS
533: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
534: BEGIN

Line 531: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE

527: END PL_TO_SQL_RF_DES_TBL;
528: FUNCTION SQL_TO_PL_RF_DES_TBL
529: (
530: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)
531: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
532: IS
533: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
534: BEGIN
535: FOR I IN 1..aSqlItem.COUNT

Line 533: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;

529: (
530: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)
531: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
532: IS
533: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
534: BEGIN
535: FOR I IN 1..aSqlItem.COUNT
536: LOOP
537: aPlsqlItem(I) := SQL_TO_PL_RF_DES_REC(aSqlItem(I));

Line 543: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)

539: RETURN aPlsqlItem;
540: END SQL_TO_PL_RF_DES_TBL;
541: FUNCTION PL_TO_SQL_SUB_COMP_REC
542: (
543: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)
544: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE
545: IS
546: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
547: BEGIN

Line 544: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE

540: END SQL_TO_PL_RF_DES_TBL;
541: FUNCTION PL_TO_SQL_SUB_COMP_REC
542: (
543: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)
544: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE
545: IS
546: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
547: BEGIN
548: -- initialize the object

Line 546: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;

542: (
543: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)
544: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE
545: IS
546: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
547: BEGIN
548: -- initialize the object
549: aSqlItem := BOM_BO_PUB_BOM_SUBCMP_REC_TYPE(NULL,
550: NULL, NULL, NULL, NULL, NULL, NULL,

Line 549: aSqlItem := BOM_BO_PUB_BOM_SUBCMP_REC_TYPE(NULL,

545: IS
546: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
547: BEGIN
548: -- initialize the object
549: aSqlItem := BOM_BO_PUB_BOM_SUBCMP_REC_TYPE(NULL,
550: NULL, NULL, NULL, NULL, NULL, NULL,
551: NULL, NULL, NULL, NULL, NULL, NULL,
552: NULL, NULL, NULL, NULL, NULL, NULL,
553: NULL, NULL, NULL, NULL, NULL, NULL,

Line 592: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)

588: RETURN aSqlItem;
589: END PL_TO_SQL_SUB_COMP_REC;
590: FUNCTION SQL_TO_PL_SUB_COMP_REC
591: (
592: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)
593: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
594: IS
595: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;
596: BEGIN

Line 593: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE

589: END PL_TO_SQL_SUB_COMP_REC;
590: FUNCTION SQL_TO_PL_SUB_COMP_REC
591: (
592: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)
593: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
594: IS
595: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;
596: BEGIN
597: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);

Line 595: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;

591: (
592: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)
593: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
594: IS
595: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;
596: BEGIN
597: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);
598: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;
599: aPlsqlItem.START_EFFECTIVE_DATE := aSqlItem.START_EFFECTIVE_DATE;

Line 633: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)

629: RETURN aPlsqlItem;
630: END SQL_TO_PL_SUB_COMP_REC;
631: FUNCTION PL_TO_SQL_SUB_COMP_TBL
632: (
633: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)
634: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE
635: IS
636: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
637: BEGIN

Line 634: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE

630: END SQL_TO_PL_SUB_COMP_REC;
631: FUNCTION PL_TO_SQL_SUB_COMP_TBL
632: (
633: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)
634: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE
635: IS
636: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
637: BEGIN
638: -- initialize the table

Line 636: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;

632: (
633: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)
634: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE
635: IS
636: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
637: BEGIN
638: -- initialize the table
639: aSqlItem := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();
640: IF aPlsqlItem.COUNT > 0 THEN

Line 639: aSqlItem := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();

635: IS
636: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
637: BEGIN
638: -- initialize the table
639: aSqlItem := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();
640: IF aPlsqlItem.COUNT > 0 THEN
641: aSqlItem.EXTEND(aPlsqlItem.COUNT);
642: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST
643: LOOP

Line 651: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)

647: RETURN aSqlItem;
648: END PL_TO_SQL_SUB_COMP_TBL;
649: FUNCTION SQL_TO_PL_SUB_COMP_TBL
650: (
651: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)
652: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
653: IS
654: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
655: BEGIN

Line 652: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE

648: END PL_TO_SQL_SUB_COMP_TBL;
649: FUNCTION SQL_TO_PL_SUB_COMP_TBL
650: (
651: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)
652: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
653: IS
654: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
655: BEGIN
656: FOR I IN 1..aSqlItem.COUNT

Line 654: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;

650: (
651: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)
652: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
653: IS
654: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
655: BEGIN
656: FOR I IN 1..aSqlItem.COUNT
657: LOOP
658: aPlsqlItem(I) := SQL_TO_PL_SUB_COMP_REC(aSqlItem(I));

Line 664: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)

660: RETURN aPlsqlItem;
661: END SQL_TO_PL_SUB_COMP_TBL;
662: FUNCTION PL_TO_SQL_COMP_OPS_REC
663: (
664: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)
665: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE
666: IS
667: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
668: BEGIN

Line 665: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE

661: END SQL_TO_PL_SUB_COMP_TBL;
662: FUNCTION PL_TO_SQL_COMP_OPS_REC
663: (
664: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)
665: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE
666: IS
667: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
668: BEGIN
669: -- initialize the object

Line 667: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE;

663: (
664: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)
665: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE
666: IS
667: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
668: BEGIN
669: -- initialize the object
670: aSqlItem := BOM_BO_PUB_BOM_COMPOP_REC_TYPE(NULL,
671: NULL, NULL, NULL, NULL, NULL, NULL,

Line 670: aSqlItem := BOM_BO_PUB_BOM_COMPOP_REC_TYPE(NULL,

666: IS
667: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
668: BEGIN
669: -- initialize the object
670: aSqlItem := BOM_BO_PUB_BOM_COMPOP_REC_TYPE(NULL,
671: NULL, NULL, NULL, NULL, NULL, NULL,
672: NULL, NULL, NULL, NULL, NULL, NULL,
673: NULL, NULL, NULL, NULL, NULL, NULL,
674: NULL, NULL, NULL, NULL, NULL, NULL,

Line 709: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)

705: RETURN aSqlItem;
706: END PL_TO_SQL_COMP_OPS_REC;
707: FUNCTION SQL_TO_PL_COMP_OPS_REC
708: (
709: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)
710: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
711: IS
712: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;
713: BEGIN

Line 710: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE

706: END PL_TO_SQL_COMP_OPS_REC;
707: FUNCTION SQL_TO_PL_COMP_OPS_REC
708: (
709: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)
710: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
711: IS
712: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;
713: BEGIN
714: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);

Line 712: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;

708: (
709: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)
710: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
711: IS
712: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;
713: BEGIN
714: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);
715: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;
716: aPlsqlItem.START_EFFECTIVE_DATE := aSqlItem.START_EFFECTIVE_DATE;

Line 747: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)

743: RETURN aPlsqlItem;
744: END SQL_TO_PL_COMP_OPS_REC;
745: FUNCTION PL_TO_SQL_COMP_OPS_TBL
746: (
747: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)
748: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE
749: IS
750: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
751: BEGIN

Line 748: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE

744: END SQL_TO_PL_COMP_OPS_REC;
745: FUNCTION PL_TO_SQL_COMP_OPS_TBL
746: (
747: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)
748: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE
749: IS
750: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
751: BEGIN
752: -- initialize the table

Line 750: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;

746: (
747: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)
748: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE
749: IS
750: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
751: BEGIN
752: -- initialize the table
753: aSqlItem := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();
754: IF aPlsqlItem.COUNT > 0 THEN

Line 753: aSqlItem := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();

749: IS
750: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
751: BEGIN
752: -- initialize the table
753: aSqlItem := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();
754: IF aPlsqlItem.COUNT > 0 THEN
755: aSqlItem.EXTEND(aPlsqlItem.COUNT);
756: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST
757: LOOP

Line 765: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)

761: RETURN aSqlItem;
762: END PL_TO_SQL_COMP_OPS_TBL;
763: FUNCTION SQL_TO_PL_COMP_OPS_TBL
764: (
765: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)
766: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
767: IS
768: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
769: BEGIN

Line 766: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE

762: END PL_TO_SQL_COMP_OPS_TBL;
763: FUNCTION SQL_TO_PL_COMP_OPS_TBL
764: (
765: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)
766: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
767: IS
768: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
769: BEGIN
770: FOR I IN 1..aSqlItem.COUNT

Line 768: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;

764: (
765: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)
766: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
767: IS
768: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
769: BEGIN
770: FOR I IN 1..aSqlItem.COUNT
771: LOOP
772: aPlsqlItem(I) := SQL_TO_PL_COMP_OPS_REC(aSqlItem(I));

Line 778: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)

774: RETURN aPlsqlItem;
775: END SQL_TO_PL_COMP_OPS_TBL;
776: FUNCTION PL_TO_SQL_PROD_REC
777: (
778: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)
779: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE
780: IS
781: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE;
782: BEGIN

Line 779: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE

775: END SQL_TO_PL_COMP_OPS_TBL;
776: FUNCTION PL_TO_SQL_PROD_REC
777: (
778: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)
779: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE
780: IS
781: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE;
782: BEGIN
783: -- initialize the object

Line 781: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE;

777: (
778: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)
779: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE
780: IS
781: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE;
782: BEGIN
783: -- initialize the object
784: aSqlItem := BOM_BO_PUB_BOM_PROD_REC_TYPE(NULL, NULL, NULL,
785: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 784: aSqlItem := BOM_BO_PUB_BOM_PROD_REC_TYPE(NULL, NULL, NULL,

780: IS
781: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE;
782: BEGIN
783: -- initialize the object
784: aSqlItem := BOM_BO_PUB_BOM_PROD_REC_TYPE(NULL, NULL, NULL,
785: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
786: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
787: NULL, NULL, NULL, NULL);
788: aSqlItem.ASSEMBLY_ITEM_NAME := aPlsqlItem.ASSEMBLY_ITEM_NAME;

Line 815: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)

811: RETURN aSqlItem;
812: END PL_TO_SQL_PROD_REC;
813: FUNCTION SQL_TO_PL_PROD_REC
814: (
815: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)
816: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
817: IS
818: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;
819: BEGIN

Line 816: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE

812: END PL_TO_SQL_PROD_REC;
813: FUNCTION SQL_TO_PL_PROD_REC
814: (
815: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)
816: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
817: IS
818: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;
819: BEGIN
820: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;

Line 818: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;

814: (
815: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)
816: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
817: IS
818: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;
819: BEGIN
820: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;
821: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);
822: aPlsqlItem.ATTRIBUTE_CATEGORY := aSqlItem.ATTRIBUTE_CATEGORY;

Line 847: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)

843: RETURN aPlsqlItem;
844: END SQL_TO_PL_PROD_REC;
845: FUNCTION PL_TO_SQL_PROD_MEM_REC
846: (
847: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)
848: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE
849: IS
850: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
851: BEGIN

Line 848: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE

844: END SQL_TO_PL_PROD_REC;
845: FUNCTION PL_TO_SQL_PROD_MEM_REC
846: (
847: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)
848: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE
849: IS
850: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
851: BEGIN
852: -- initialize the object

Line 850: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;

846: (
847: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)
848: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE
849: IS
850: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
851: BEGIN
852: -- initialize the object
853: aSqlItem := BOM_BO_PUB_BOM_PRDMEM_REC_TYPE(NULL, NULL,
854: NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 853: aSqlItem := BOM_BO_PUB_BOM_PRDMEM_REC_TYPE(NULL, NULL,

849: IS
850: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
851: BEGIN
852: -- initialize the object
853: aSqlItem := BOM_BO_PUB_BOM_PRDMEM_REC_TYPE(NULL, NULL,
854: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
855: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
856: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
857: NULL, NULL, NULL, NULL, NULL, NULL);

Line 891: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)

887: RETURN aSqlItem;
888: END PL_TO_SQL_PROD_MEM_REC;
889: FUNCTION SQL_TO_PL_PROD_MEM_REC
890: (
891: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)
892: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
893: IS
894: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;
895: BEGIN

Line 892: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE

888: END PL_TO_SQL_PROD_MEM_REC;
889: FUNCTION SQL_TO_PL_PROD_MEM_REC
890: (
891: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)
892: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
893: IS
894: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;
895: BEGIN
896: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;

Line 894: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;

890: (
891: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)
892: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
893: IS
894: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;
895: BEGIN
896: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;
897: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);
898: aPlsqlItem.COMPONENT_ITEM_NAME := aSqlItem.COMPONENT_ITEM_NAME;

Line 929: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)

925: RETURN aPlsqlItem;
926: END SQL_TO_PL_PROD_MEM_REC;
927: FUNCTION PL_TO_SQL_PROD_MEM_TBL
928: (
929: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)
930: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE
931: IS
932: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
933: BEGIN

Line 930: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE

926: END SQL_TO_PL_PROD_MEM_REC;
927: FUNCTION PL_TO_SQL_PROD_MEM_TBL
928: (
929: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)
930: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE
931: IS
932: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
933: BEGIN
934: -- initialize the table

Line 932: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;

928: (
929: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)
930: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE
931: IS
932: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
933: BEGIN
934: -- initialize the table
935: aSqlItem := BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE();
936: IF aPlsqlItem.COUNT > 0 THEN

Line 935: aSqlItem := BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE();

931: IS
932: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
933: BEGIN
934: -- initialize the table
935: aSqlItem := BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE();
936: IF aPlsqlItem.COUNT > 0 THEN
937: aSqlItem.EXTEND(aPlsqlItem.COUNT);
938: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST
939: LOOP

Line 947: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)

943: RETURN aSqlItem;
944: END PL_TO_SQL_PROD_MEM_TBL;
945: FUNCTION SQL_TO_PL_PROD_MEM_TBL
946: (
947: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)
948: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
949: IS
950: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;
951: BEGIN

Line 948: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE

944: END PL_TO_SQL_PROD_MEM_TBL;
945: FUNCTION SQL_TO_PL_PROD_MEM_TBL
946: (
947: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)
948: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
949: IS
950: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;
951: BEGIN
952: FOR I IN 1..aSqlItem.COUNT

Line 950: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;

946: (
947: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)
948: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
949: IS
950: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;
951: BEGIN
952: FOR I IN 1..aSqlItem.COUNT
953: LOOP
954: aPlsqlItem(I) := SQL_TO_PL_PROD_MEM_REC(aSqlItem(I));

Line 960: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)

956: RETURN aPlsqlItem;
957: END SQL_TO_PL_PROD_MEM_TBL;
958: FUNCTION PL_TO_SQL_HEADER_TBL
959: (
960: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)
961: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE
962: IS
963: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
964: BEGIN

Line 961: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE

957: END SQL_TO_PL_PROD_MEM_TBL;
958: FUNCTION PL_TO_SQL_HEADER_TBL
959: (
960: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)
961: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE
962: IS
963: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
964: BEGIN
965: -- initialize the table

Line 963: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE;

959: (
960: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)
961: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE
962: IS
963: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
964: BEGIN
965: -- initialize the table
966: aSqlItem := BOM_BO_PUB_BOM_HEADER_TBL_TYPE();
967: IF aPlsqlItem.COUNT > 0 THEN

Line 966: aSqlItem := BOM_BO_PUB_BOM_HEADER_TBL_TYPE();

962: IS
963: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
964: BEGIN
965: -- initialize the table
966: aSqlItem := BOM_BO_PUB_BOM_HEADER_TBL_TYPE();
967: IF aPlsqlItem.COUNT > 0 THEN
968: aSqlItem.EXTEND(aPlsqlItem.COUNT);
969: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST
970: LOOP

Line 978: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)

974: RETURN aSqlItem;
975: END PL_TO_SQL_HEADER_TBL;
976: FUNCTION SQL_TO_PL_HEADER_TBL
977: (
978: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)
979: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE
980: IS
981: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
982: BEGIN

Line 979: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE

975: END PL_TO_SQL_HEADER_TBL;
976: FUNCTION SQL_TO_PL_HEADER_TBL
977: (
978: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)
979: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE
980: IS
981: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
982: BEGIN
983: FOR I IN 1..aSqlItem.COUNT

Line 981: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE;

977: (
978: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)
979: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE
980: IS
981: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
982: BEGIN
983: FOR I IN 1..aSqlItem.COUNT
984: LOOP
985: aPlsqlItem(I) := SQL_TO_PL_HEAD_REC(aSqlItem(I));

Line 989: PROCEDURE BOM_BO_PUB$PROCESS_BOM

985: aPlsqlItem(I) := SQL_TO_PL_HEAD_REC(aSqlItem(I));
986: END LOOP;
987: RETURN aPlsqlItem;
988: END SQL_TO_PL_HEADER_TBL;
989: PROCEDURE BOM_BO_PUB$PROCESS_BOM
990: (
991: P_BO_IDENTIFIER VARCHAR2,
992: P_API_VERSION_NUMBER NUMBER,
993: P_INIT_MSG_LIST INTEGER,

Line 994: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,

990: (
991: P_BO_IDENTIFIER VARCHAR2,
992: P_API_VERSION_NUMBER NUMBER,
993: P_INIT_MSG_LIST INTEGER,
994: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
995: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
996: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
997: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
998: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,

Line 995: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,

991: P_BO_IDENTIFIER VARCHAR2,
992: P_API_VERSION_NUMBER NUMBER,
993: P_INIT_MSG_LIST INTEGER,
994: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
995: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
996: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
997: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
998: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
999: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,

Line 996: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,

992: P_API_VERSION_NUMBER NUMBER,
993: P_INIT_MSG_LIST INTEGER,
994: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
995: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
996: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
997: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
998: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
999: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
1000: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,

Line 997: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,

993: P_INIT_MSG_LIST INTEGER,
994: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
995: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
996: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
997: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
998: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
999: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
1000: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
1001: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,

Line 998: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,

994: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
995: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
996: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
997: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
998: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
999: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
1000: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
1001: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
1002: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,

Line 999: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,

995: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
996: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
997: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
998: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
999: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
1000: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
1001: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
1002: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
1003: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,

Line 1000: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,

996: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
997: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
998: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
999: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
1000: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
1001: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
1002: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
1003: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
1004: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,

Line 1001: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,

997: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
998: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
999: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
1000: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
1001: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
1002: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
1003: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
1004: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
1005: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,

Line 1002: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,

998: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
999: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
1000: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
1001: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
1002: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
1003: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
1004: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
1005: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
1006: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,

Line 1003: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,

999: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
1000: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
1001: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
1002: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
1003: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
1004: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
1005: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
1006: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
1007: X_MSG_COUNT IN OUT NOCOPY NUMBER,

Line 1004: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,

1000: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
1001: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
1002: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
1003: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
1004: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
1005: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
1006: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
1007: X_MSG_COUNT IN OUT NOCOPY NUMBER,
1008: X_ERROR_MESSAGE IN OUT NOCOPY VARCHAR2,

Line 1005: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,

1001: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
1002: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
1003: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
1004: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
1005: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
1006: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
1007: X_MSG_COUNT IN OUT NOCOPY NUMBER,
1008: X_ERROR_MESSAGE IN OUT NOCOPY VARCHAR2,
1009: P_DEBUG VARCHAR2,

Line 1014: P_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL;

1010: P_OUTPUT_DIR VARCHAR2,
1011: P_DEBUG_FILENAME VARCHAR2)
1012: IS
1013: P_INIT_MSG_LIST_ BOOLEAN;
1014: P_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL;
1015: P_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
1016: P_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1017: P_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1018: P_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;

Line 1015: P_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;

1011: P_DEBUG_FILENAME VARCHAR2)
1012: IS
1013: P_INIT_MSG_LIST_ BOOLEAN;
1014: P_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL;
1015: P_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
1016: P_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1017: P_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1018: P_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1019: P_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;

Line 1016: P_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;

1012: IS
1013: P_INIT_MSG_LIST_ BOOLEAN;
1014: P_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL;
1015: P_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
1016: P_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1017: P_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1018: P_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1019: P_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
1020: X_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE;

Line 1017: P_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;

1013: P_INIT_MSG_LIST_ BOOLEAN;
1014: P_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL;
1015: P_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
1016: P_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1017: P_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1018: P_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1019: P_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
1020: X_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
1021: X_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE;

Line 1018: P_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;

1014: P_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL;
1015: P_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
1016: P_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1017: P_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1018: P_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1019: P_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
1020: X_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
1021: X_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
1022: X_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE;

Line 1019: P_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;

1015: P_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
1016: P_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1017: P_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1018: P_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1019: P_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
1020: X_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
1021: X_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
1022: X_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
1023: X_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;

Line 1020: X_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE;

1016: P_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1017: P_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1018: P_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1019: P_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
1020: X_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
1021: X_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
1022: X_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
1023: X_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
1024: X_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;

Line 1021: X_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE;

1017: P_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1018: P_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1019: P_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
1020: X_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
1021: X_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
1022: X_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
1023: X_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
1024: X_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
1025: X_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;

Line 1022: X_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE;

1018: P_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1019: P_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
1020: X_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
1021: X_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
1022: X_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
1023: X_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
1024: X_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
1025: X_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
1026: L_ERROR_MESSAGE_LIST ERROR_HANDLER.ERROR_TBL_TYPE;

Line 1023: X_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;

1019: P_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
1020: X_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
1021: X_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
1022: X_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
1023: X_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
1024: X_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
1025: X_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
1026: L_ERROR_MESSAGE_LIST ERROR_HANDLER.ERROR_TBL_TYPE;
1027: L_ERROR_MESSAGE VARCHAR2(4000);

Line 1024: X_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;

1020: X_BOM_HEADER_TBL_ BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
1021: X_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
1022: X_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
1023: X_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
1024: X_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
1025: X_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
1026: L_ERROR_MESSAGE_LIST ERROR_HANDLER.ERROR_TBL_TYPE;
1027: L_ERROR_MESSAGE VARCHAR2(4000);
1028: BEGIN

Line 1025: X_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;

1021: X_BOM_REVISION_TBL_ BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
1022: X_BOM_COMPONENT_TBL_ BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
1023: X_BOM_REF_DESIGNATOR_TBL_ BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
1024: X_BOM_SUB_COMPONENT_TBL_ BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
1025: X_BOM_COMP_OPS_TBL_ BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
1026: L_ERROR_MESSAGE_LIST ERROR_HANDLER.ERROR_TBL_TYPE;
1027: L_ERROR_MESSAGE VARCHAR2(4000);
1028: BEGIN
1029: Error_Handler.Initialize;

Line 1038: BOM_BO_PUB.PROCESS_BOM(P_BO_IDENTIFIER, P_API_VERSION_NUMBER, P_INIT_MSG_LIST_,

1034: P_BOM_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMPS_TBL(P_BOM_COMPONENT_TBL);
1035: P_BOM_REF_DESIGNATOR_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_RF_DES_TBL(P_BOM_REF_DESIGNATOR_TBL);
1036: P_BOM_SUB_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_SUB_COMP_TBL(P_BOM_SUB_COMPONENT_TBL);
1037: P_BOM_COMP_OPS_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMP_OPS_TBL(P_BOM_COMP_OPS_TBL);
1038: BOM_BO_PUB.PROCESS_BOM(P_BO_IDENTIFIER, P_API_VERSION_NUMBER, P_INIT_MSG_LIST_,
1039: P_BOM_HEADER_TBL_, P_BOM_REVISION_TBL_, P_BOM_COMPONENT_TBL_,
1040: P_BOM_REF_DESIGNATOR_TBL_, P_BOM_SUB_COMPONENT_TBL_, P_BOM_COMP_OPS_TBL_,
1041: X_BOM_HEADER_TBL_, X_BOM_REVISION_TBL_, X_BOM_COMPONENT_TBL_,
1042: X_BOM_REF_DESIGNATOR_TBL_, X_BOM_SUB_COMPONENT_TBL_, X_BOM_COMP_OPS_TBL_,

Line 1055: X_BOM_HEADER_TBL := BOM_BO_PUB_BOM_HEADER_TBL_TYPE();

1051:
1052: g_org_id := NULL;
1053: g_org_code := NULL;
1054: X_ERROR_MESSAGE := L_ERROR_MESSAGE;
1055: X_BOM_HEADER_TBL := BOM_BO_PUB_BOM_HEADER_TBL_TYPE();
1056: X_BOM_REVISION_TBL := BOM_BO_PUB_BOM_REV_TBL_TYPE();
1057: X_BOM_COMPONENT_TBL := BOM_BO_PUB_BOM_COMPS_TBL_TYPE();
1058: X_BOM_REF_DESIGNATOR_TBL := BOM_BO_PUB_BOM_RF_DES_TBL_TYPE();
1059: X_BOM_SUB_COMPONENT_TBL := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();

Line 1056: X_BOM_REVISION_TBL := BOM_BO_PUB_BOM_REV_TBL_TYPE();

1052: g_org_id := NULL;
1053: g_org_code := NULL;
1054: X_ERROR_MESSAGE := L_ERROR_MESSAGE;
1055: X_BOM_HEADER_TBL := BOM_BO_PUB_BOM_HEADER_TBL_TYPE();
1056: X_BOM_REVISION_TBL := BOM_BO_PUB_BOM_REV_TBL_TYPE();
1057: X_BOM_COMPONENT_TBL := BOM_BO_PUB_BOM_COMPS_TBL_TYPE();
1058: X_BOM_REF_DESIGNATOR_TBL := BOM_BO_PUB_BOM_RF_DES_TBL_TYPE();
1059: X_BOM_SUB_COMPONENT_TBL := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();
1060: X_BOM_COMP_OPS_TBL := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();

Line 1057: X_BOM_COMPONENT_TBL := BOM_BO_PUB_BOM_COMPS_TBL_TYPE();

1053: g_org_code := NULL;
1054: X_ERROR_MESSAGE := L_ERROR_MESSAGE;
1055: X_BOM_HEADER_TBL := BOM_BO_PUB_BOM_HEADER_TBL_TYPE();
1056: X_BOM_REVISION_TBL := BOM_BO_PUB_BOM_REV_TBL_TYPE();
1057: X_BOM_COMPONENT_TBL := BOM_BO_PUB_BOM_COMPS_TBL_TYPE();
1058: X_BOM_REF_DESIGNATOR_TBL := BOM_BO_PUB_BOM_RF_DES_TBL_TYPE();
1059: X_BOM_SUB_COMPONENT_TBL := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();
1060: X_BOM_COMP_OPS_TBL := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();
1061: X_BOM_HEADER_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_HEADER_TBL(X_BOM_HEADER_TBL_);

Line 1058: X_BOM_REF_DESIGNATOR_TBL := BOM_BO_PUB_BOM_RF_DES_TBL_TYPE();

1054: X_ERROR_MESSAGE := L_ERROR_MESSAGE;
1055: X_BOM_HEADER_TBL := BOM_BO_PUB_BOM_HEADER_TBL_TYPE();
1056: X_BOM_REVISION_TBL := BOM_BO_PUB_BOM_REV_TBL_TYPE();
1057: X_BOM_COMPONENT_TBL := BOM_BO_PUB_BOM_COMPS_TBL_TYPE();
1058: X_BOM_REF_DESIGNATOR_TBL := BOM_BO_PUB_BOM_RF_DES_TBL_TYPE();
1059: X_BOM_SUB_COMPONENT_TBL := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();
1060: X_BOM_COMP_OPS_TBL := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();
1061: X_BOM_HEADER_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_HEADER_TBL(X_BOM_HEADER_TBL_);
1062: X_BOM_REVISION_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_REV_TBL(X_BOM_REVISION_TBL_);

Line 1059: X_BOM_SUB_COMPONENT_TBL := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();

1055: X_BOM_HEADER_TBL := BOM_BO_PUB_BOM_HEADER_TBL_TYPE();
1056: X_BOM_REVISION_TBL := BOM_BO_PUB_BOM_REV_TBL_TYPE();
1057: X_BOM_COMPONENT_TBL := BOM_BO_PUB_BOM_COMPS_TBL_TYPE();
1058: X_BOM_REF_DESIGNATOR_TBL := BOM_BO_PUB_BOM_RF_DES_TBL_TYPE();
1059: X_BOM_SUB_COMPONENT_TBL := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();
1060: X_BOM_COMP_OPS_TBL := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();
1061: X_BOM_HEADER_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_HEADER_TBL(X_BOM_HEADER_TBL_);
1062: X_BOM_REVISION_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_REV_TBL(X_BOM_REVISION_TBL_);
1063: X_BOM_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMPS_TBL(X_BOM_COMPONENT_TBL_);

Line 1060: X_BOM_COMP_OPS_TBL := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();

1056: X_BOM_REVISION_TBL := BOM_BO_PUB_BOM_REV_TBL_TYPE();
1057: X_BOM_COMPONENT_TBL := BOM_BO_PUB_BOM_COMPS_TBL_TYPE();
1058: X_BOM_REF_DESIGNATOR_TBL := BOM_BO_PUB_BOM_RF_DES_TBL_TYPE();
1059: X_BOM_SUB_COMPONENT_TBL := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();
1060: X_BOM_COMP_OPS_TBL := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();
1061: X_BOM_HEADER_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_HEADER_TBL(X_BOM_HEADER_TBL_);
1062: X_BOM_REVISION_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_REV_TBL(X_BOM_REVISION_TBL_);
1063: X_BOM_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMPS_TBL(X_BOM_COMPONENT_TBL_);
1064: X_BOM_REF_DESIGNATOR_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_RF_DES_TBL(X_BOM_REF_DESIGNATOR_TBL_);

Line 1067: END BOM_BO_PUB$PROCESS_BOM;

1063: X_BOM_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMPS_TBL(X_BOM_COMPONENT_TBL_);
1064: X_BOM_REF_DESIGNATOR_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_RF_DES_TBL(X_BOM_REF_DESIGNATOR_TBL_);
1065: X_BOM_SUB_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_SUB_COMP_TBL(X_BOM_SUB_COMPONENT_TBL_);
1066: X_BOM_COMP_OPS_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMP_OPS_TBL(X_BOM_COMP_OPS_TBL_);
1067: END BOM_BO_PUB$PROCESS_BOM;
1068:
1069:
1070:
1071: