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.EGO_ITEM_AML_PVT dependencies on EGO_ITEM_PUB

Line 284: (EGO_ITEM_PUB.G_TTYPE_CREATE

280: SET process_flag = G_PS_INVALID_TRANS_TYPE
281: WHERE data_set_id = p_data_set_id
282: AND process_flag = G_PS_IN_PROCESS
283: AND transaction_type NOT IN
284: (EGO_ITEM_PUB.G_TTYPE_CREATE
285: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
286: ,EGO_ITEM_PUB.G_TTYPE_SYNC
287: ,EGO_ITEM_PUB.G_TTYPE_DELETE
288: );

Line 285: ,EGO_ITEM_PUB.G_TTYPE_UPDATE

281: WHERE data_set_id = p_data_set_id
282: AND process_flag = G_PS_IN_PROCESS
283: AND transaction_type NOT IN
284: (EGO_ITEM_PUB.G_TTYPE_CREATE
285: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
286: ,EGO_ITEM_PUB.G_TTYPE_SYNC
287: ,EGO_ITEM_PUB.G_TTYPE_DELETE
288: );
289: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT

Line 286: ,EGO_ITEM_PUB.G_TTYPE_SYNC

282: AND process_flag = G_PS_IN_PROCESS
283: AND transaction_type NOT IN
284: (EGO_ITEM_PUB.G_TTYPE_CREATE
285: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
286: ,EGO_ITEM_PUB.G_TTYPE_SYNC
287: ,EGO_ITEM_PUB.G_TTYPE_DELETE
288: );
289: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
290: ,p_module => l_api_name

Line 287: ,EGO_ITEM_PUB.G_TTYPE_DELETE

283: AND transaction_type NOT IN
284: (EGO_ITEM_PUB.G_TTYPE_CREATE
285: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
286: ,EGO_ITEM_PUB.G_TTYPE_SYNC
287: ,EGO_ITEM_PUB.G_TTYPE_DELETE
288: );
289: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
290: ,p_module => l_api_name
291: ,p_message => ' Transaction type validation complete'

Line 298: AND NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

294: UPDATE ego_aml_intf aml_intf
295: SET process_flag = G_PS_SD_GT_ED_ERROR
296: WHERE data_set_id = p_data_set_id
297: AND process_flag = G_PS_IN_PROCESS
298: AND NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
299: > NVL(end_date,NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE));
300: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
301: ,p_module => l_api_name
302: ,p_message => ' Start Date - End Date validation complete'

Line 299: > NVL(end_date,NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE));

295: SET process_flag = G_PS_SD_GT_ED_ERROR
296: WHERE data_set_id = p_data_set_id
297: AND process_flag = G_PS_IN_PROCESS
298: AND NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
299: > NVL(end_date,NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE));
300: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
301: ,p_module => l_api_name
302: ,p_message => ' Start Date - End Date validation complete'
303: );

Line 309: AND transaction_type <> EGO_ITEM_PUB.G_TTYPE_DELETE

305: UPDATE ego_aml_intf aml_intf
306: SET process_flag = G_PS_FA_STATUS_ERR
307: WHERE data_set_id = p_data_set_id
308: AND process_flag = G_PS_IN_PROCESS
309: AND transaction_type <> EGO_ITEM_PUB.G_TTYPE_DELETE
310: AND ( ( NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
311: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
312: AND
313: first_article_status NOT IN

Line 310: AND ( ( NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

306: SET process_flag = G_PS_FA_STATUS_ERR
307: WHERE data_set_id = p_data_set_id
308: AND process_flag = G_PS_IN_PROCESS
309: AND transaction_type <> EGO_ITEM_PUB.G_TTYPE_DELETE
310: AND ( ( NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
311: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
312: AND
313: first_article_status NOT IN
314: (SELECT lookup_code

Line 311: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

307: WHERE data_set_id = p_data_set_id
308: AND process_flag = G_PS_IN_PROCESS
309: AND transaction_type <> EGO_ITEM_PUB.G_TTYPE_DELETE
310: AND ( ( NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
311: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
312: AND
313: first_article_status NOT IN
314: (SELECT lookup_code
315: FROM fnd_lookup_values fa_lookup

Line 322: NVL(first_article_status_meaning,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

318: )
319: OR
320: ( first_article_status IS NULL
321: AND
322: NVL(first_article_status_meaning,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
323: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
324: AND
325: first_article_status_meaning NOT IN
326: (SELECT meaning

Line 323: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

319: OR
320: ( first_article_status IS NULL
321: AND
322: NVL(first_article_status_meaning,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
323: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
324: AND
325: first_article_status_meaning NOT IN
326: (SELECT meaning
327: FROM fnd_lookup_values fa_lookup

Line 335: DECODE (first_article_status_meaning, EGO_ITEM_PUB.G_INTF_NULL_CHAR,

331: );
332:
333: UPDATE ego_aml_intf aml_intf
334: SET first_article_status =
335: DECODE (first_article_status_meaning, EGO_ITEM_PUB.G_INTF_NULL_CHAR,
336: EGO_ITEM_PUB.G_INTF_NULL_CHAR,
337: (Select lookup_code
338: from fnd_lookup_values fa_lookup
339: where fa_lookup.lookup_type = 'EGO_CAT_GRP_MFG_FST_ATCLE_STS'

Line 336: EGO_ITEM_PUB.G_INTF_NULL_CHAR,

332:
333: UPDATE ego_aml_intf aml_intf
334: SET first_article_status =
335: DECODE (first_article_status_meaning, EGO_ITEM_PUB.G_INTF_NULL_CHAR,
336: EGO_ITEM_PUB.G_INTF_NULL_CHAR,
337: (Select lookup_code
338: from fnd_lookup_values fa_lookup
339: where fa_lookup.lookup_type = 'EGO_CAT_GRP_MFG_FST_ATCLE_STS'
340: and fa_lookup.meaning = aml_intf.first_article_status_meaning

Line 345: AND transaction_type <> EGO_ITEM_PUB.G_TTYPE_DELETE

341: and fa_lookup.language = G_SESSION_LANG)
342: )
343: WHERE data_set_id = p_data_set_id
344: AND process_flag = G_PS_IN_PROCESS
345: AND transaction_type <> EGO_ITEM_PUB.G_TTYPE_DELETE
346: AND first_article_status IS NULL
347: AND first_article_status_meaning IS NOT NULL;
348: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
349: ,p_module => l_api_name

Line 357: AND transaction_type <> EGO_ITEM_PUB.G_TTYPE_DELETE

353: UPDATE ego_aml_intf aml_intf
354: SET process_flag = G_PS_APPROVAL_STATUS_ERR
355: WHERE data_set_id = p_data_set_id
356: AND process_flag = G_PS_IN_PROCESS
357: AND transaction_type <> EGO_ITEM_PUB.G_TTYPE_DELETE
358: AND ( ( NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
359: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
360: AND
361: approval_status NOT IN

Line 358: AND ( ( NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

354: SET process_flag = G_PS_APPROVAL_STATUS_ERR
355: WHERE data_set_id = p_data_set_id
356: AND process_flag = G_PS_IN_PROCESS
357: AND transaction_type <> EGO_ITEM_PUB.G_TTYPE_DELETE
358: AND ( ( NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
359: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
360: AND
361: approval_status NOT IN
362: (SELECT lookup_code

Line 359: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

355: WHERE data_set_id = p_data_set_id
356: AND process_flag = G_PS_IN_PROCESS
357: AND transaction_type <> EGO_ITEM_PUB.G_TTYPE_DELETE
358: AND ( ( NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
359: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
360: AND
361: approval_status NOT IN
362: (SELECT lookup_code
363: FROM fnd_lookup_values fa_lookup

Line 370: NVL(approval_status_meaning,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

366: )
367: OR
368: ( approval_status IS NULL
369: AND
370: NVL(approval_status_meaning,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
371: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
372: AND
373: approval_status_meaning NOT IN
374: (SELECT meaning

Line 371: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

367: OR
368: ( approval_status IS NULL
369: AND
370: NVL(approval_status_meaning,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
371: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
372: AND
373: approval_status_meaning NOT IN
374: (SELECT meaning
375: FROM fnd_lookup_values fa_lookup

Line 383: DECODE (approval_status_meaning, EGO_ITEM_PUB.G_INTF_NULL_CHAR,

379: );
380:
381: UPDATE ego_aml_intf aml_intf
382: SET approval_status =
383: DECODE (approval_status_meaning, EGO_ITEM_PUB.G_INTF_NULL_CHAR,
384: EGO_ITEM_PUB.G_INTF_NULL_CHAR,
385: (Select lookup_code
386: from fnd_lookup_values fa_lookup
387: where fa_lookup.lookup_type = 'EGO_CAT_GRP_MFG_APPR_STS'

Line 384: EGO_ITEM_PUB.G_INTF_NULL_CHAR,

380:
381: UPDATE ego_aml_intf aml_intf
382: SET approval_status =
383: DECODE (approval_status_meaning, EGO_ITEM_PUB.G_INTF_NULL_CHAR,
384: EGO_ITEM_PUB.G_INTF_NULL_CHAR,
385: (Select lookup_code
386: from fnd_lookup_values fa_lookup
387: where fa_lookup.lookup_type = 'EGO_CAT_GRP_MFG_APPR_STS'
388: and fa_lookup.meaning = aml_intf.approval_status_meaning

Line 393: AND transaction_type <> EGO_ITEM_PUB.G_TTYPE_DELETE

389: and fa_lookup.language = G_SESSION_LANG)
390: )
391: WHERE data_set_id = p_data_set_id
392: AND process_flag = G_PS_IN_PROCESS
393: AND transaction_type <> EGO_ITEM_PUB.G_TTYPE_DELETE
394: AND approval_status IS NULL
395: AND approval_status_meaning IS NOT NULL;
396: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
397: ,p_module => l_api_name

Line 568: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE

564: UPDATE ego_aml_intf aml_intf
565: SET process_flag = G_PS_CREATE_REC_EXISTS
566: WHERE data_set_id = p_data_set_id
567: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
568: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
569: AND EXISTS
570: (Select 'x'
571: from mtl_mfg_part_numbers part_num
572: where part_num.inventory_item_id = aml_intf.inventory_item_id

Line 586: AND transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE

582: UPDATE ego_aml_intf aml_intf
583: SET process_flag = G_PS_REC_NOT_EXISTS
584: WHERE data_set_id = p_data_set_id
585: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
586: AND transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
587: ,EGO_ITEM_PUB.G_TTYPE_DELETE
588: )
589: AND NOT EXISTS
590: (Select 'x'

Line 587: ,EGO_ITEM_PUB.G_TTYPE_DELETE

583: SET process_flag = G_PS_REC_NOT_EXISTS
584: WHERE data_set_id = p_data_set_id
585: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
586: AND transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
587: ,EGO_ITEM_PUB.G_TTYPE_DELETE
588: )
589: AND NOT EXISTS
590: (Select 'x'
591: from mtl_mfg_part_numbers part_num

Line 603: SET transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE

599: ,p_message => 'Transaction check complete for UPDATE'
600: );
601:
602: UPDATE ego_aml_intf aml_intf
603: SET transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
604: WHERE data_set_id = p_data_set_id
605: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
606: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_SYNC
607: AND EXISTS

Line 606: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_SYNC

602: UPDATE ego_aml_intf aml_intf
603: SET transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
604: WHERE data_set_id = p_data_set_id
605: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
606: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_SYNC
607: AND EXISTS
608: (Select 'x'
609: from mtl_mfg_part_numbers part_num
610: where part_num.inventory_item_id = aml_intf.inventory_item_id

Line 617: SET transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE

613: and part_num.mfg_part_num = aml_intf.mfg_part_num
614: );
615:
616: UPDATE ego_aml_intf aml_intf
617: SET transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
618: WHERE data_set_id = p_data_set_id
619: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
620: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_SYNC;
621: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT

Line 620: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_SYNC;

616: UPDATE ego_aml_intf aml_intf
617: SET transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
618: WHERE data_set_id = p_data_set_id
619: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
620: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_SYNC;
621: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
622: ,p_module => l_api_name
623: ,p_message => 'Transaction check complete for SYNC'
624: );

Line 631: -- AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE

627: -- UPDATE ego_aml_intf aml_intf
628: -- SET process_flag = G_PS_SD_NOT_NULL
629: -- WHERE data_set_id = p_data_set_id
630: -- AND process_flag = G_PS_VAL_TO_ID_COMPLETE
631: -- AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
632: -- AND start_date = EGO_ITEM_PUB.G_INTF_NULL_DATE;
633:
634: IF p_mode <> MODE_HISTORICAL THEN
635: UPDATE ego_aml_intf aml_intf

Line 632: -- AND start_date = EGO_ITEM_PUB.G_INTF_NULL_DATE;

628: -- SET process_flag = G_PS_SD_NOT_NULL
629: -- WHERE data_set_id = p_data_set_id
630: -- AND process_flag = G_PS_VAL_TO_ID_COMPLETE
631: -- AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
632: -- AND start_date = EGO_ITEM_PUB.G_INTF_NULL_DATE;
633:
634: IF p_mode <> MODE_HISTORICAL THEN
635: UPDATE ego_aml_intf aml_intf
636: SET process_flag = G_PS_ED_LT_SYSDATE

Line 639: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE

635: UPDATE ego_aml_intf aml_intf
636: SET process_flag = G_PS_ED_LT_SYSDATE
637: WHERE data_set_id = p_data_set_id
638: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
639: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
640: AND NVL(end_date,G_SYSDATE) <> EGO_ITEM_PUB.g_INTF_NULL_DATE
641: AND NVL(end_date,G_SYSDATE) < G_SYSDATE;
642: END IF;
643:

Line 640: AND NVL(end_date,G_SYSDATE) <> EGO_ITEM_PUB.g_INTF_NULL_DATE

636: SET process_flag = G_PS_ED_LT_SYSDATE
637: WHERE data_set_id = p_data_set_id
638: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
639: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
640: AND NVL(end_date,G_SYSDATE) <> EGO_ITEM_PUB.g_INTF_NULL_DATE
641: AND NVL(end_date,G_SYSDATE) < G_SYSDATE;
642: END IF;
643:
644: EXCEPTION

Line 882: AND transaction_type IN (EGO_ITEM_PUB.G_TTYPE_CREATE

878: SELECT *
879: FROM ego_aml_intf
880: WHERE data_set_id = cp_data_set_id
881: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
882: AND transaction_type IN (EGO_ITEM_PUB.G_TTYPE_CREATE
883: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
884: )
885: FOR UPDATE OF transaction_id;
886:

Line 883: ,EGO_ITEM_PUB.G_TTYPE_UPDATE

879: FROM ego_aml_intf
880: WHERE data_set_id = cp_data_set_id
881: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
882: AND transaction_type IN (EGO_ITEM_PUB.G_TTYPE_CREATE
883: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
884: )
885: FOR UPDATE OF transaction_id;
886:
887: BEGIN

Line 977: DECODE(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,

973: END IF;
974:
975: UPDATE ego_aml_intf
976: SET mrp_planning_code =
977: DECODE(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,
978: mrp_planning_code),
979: description =
980: DECODE(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
981: description),

Line 980: DECODE(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

976: SET mrp_planning_code =
977: DECODE(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,
978: mrp_planning_code),
979: description =
980: DECODE(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
981: description),
982: attribute_category =
983: DECODE(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
984: attribute_category),

Line 983: DECODE(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

979: description =
980: DECODE(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
981: description),
982: attribute_category =
983: DECODE(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
984: attribute_category),
985: attribute1 =
986: DECODE(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
987: attribute1),

Line 986: DECODE(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

982: attribute_category =
983: DECODE(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
984: attribute_category),
985: attribute1 =
986: DECODE(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
987: attribute1),
988: attribute2 =
989: DECODE(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
990: attribute2),

Line 989: DECODE(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

985: attribute1 =
986: DECODE(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
987: attribute1),
988: attribute2 =
989: DECODE(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
990: attribute2),
991: attribute3 =
992: DECODE(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
993: attribute3),

Line 992: DECODE(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

988: attribute2 =
989: DECODE(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
990: attribute2),
991: attribute3 =
992: DECODE(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
993: attribute3),
994: attribute4 =
995: DECODE(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
996: attribute4),

Line 995: DECODE(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

991: attribute3 =
992: DECODE(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
993: attribute3),
994: attribute4 =
995: DECODE(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
996: attribute4),
997: attribute5 =
998: DECODE(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
999: attribute5),

Line 998: DECODE(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

994: attribute4 =
995: DECODE(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
996: attribute4),
997: attribute5 =
998: DECODE(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
999: attribute5),
1000: attribute6 =
1001: DECODE(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1002: attribute6),

Line 1001: DECODE(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

997: attribute5 =
998: DECODE(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
999: attribute5),
1000: attribute6 =
1001: DECODE(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1002: attribute6),
1003: attribute7 =
1004: DECODE(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1005: attribute7),

Line 1004: DECODE(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1000: attribute6 =
1001: DECODE(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1002: attribute6),
1003: attribute7 =
1004: DECODE(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1005: attribute7),
1006: attribute8 =
1007: DECODE(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1008: attribute8),

Line 1007: DECODE(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1003: attribute7 =
1004: DECODE(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1005: attribute7),
1006: attribute8 =
1007: DECODE(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1008: attribute8),
1009: attribute9 =
1010: DECODE(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1011: attribute9),

Line 1010: DECODE(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1006: attribute8 =
1007: DECODE(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1008: attribute8),
1009: attribute9 =
1010: DECODE(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1011: attribute9),
1012: attribute10 =
1013: DECODE(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1014: attribute10),

Line 1013: DECODE(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1009: attribute9 =
1010: DECODE(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1011: attribute9),
1012: attribute10 =
1013: DECODE(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1014: attribute10),
1015: attribute11 =
1016: DECODE(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1017: attribute11),

Line 1016: DECODE(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1012: attribute10 =
1013: DECODE(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1014: attribute10),
1015: attribute11 =
1016: DECODE(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1017: attribute11),
1018: attribute12 =
1019: DECODE(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1020: attribute12),

Line 1019: DECODE(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1015: attribute11 =
1016: DECODE(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1017: attribute11),
1018: attribute12 =
1019: DECODE(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1020: attribute12),
1021: attribute13 =
1022: DECODE(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1023: attribute13),

Line 1022: DECODE(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1018: attribute12 =
1019: DECODE(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1020: attribute12),
1021: attribute13 =
1022: DECODE(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1023: attribute13),
1024: attribute14 =
1025: DECODE(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1026: attribute14),

Line 1025: DECODE(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1021: attribute13 =
1022: DECODE(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1023: attribute13),
1024: attribute14 =
1025: DECODE(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1026: attribute14),
1027: attribute15 =
1028: DECODE(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1029: attribute15),

Line 1028: DECODE(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1024: attribute14 =
1025: DECODE(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1026: attribute14),
1027: attribute15 =
1028: DECODE(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1029: attribute15),
1030: first_article_status =
1031: DECODE(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1032: first_article_status),

Line 1031: DECODE(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1027: attribute15 =
1028: DECODE(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1029: attribute15),
1030: first_article_status =
1031: DECODE(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1032: first_article_status),
1033: approval_status =
1034: DECODE(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1035: approval_status),

Line 1034: DECODE(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1030: first_article_status =
1031: DECODE(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1032: first_article_status),
1033: approval_status =
1034: DECODE(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1035: approval_status),
1036: start_date =
1037: DECODE(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
1038: start_date),

Line 1037: DECODE(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,

1033: approval_status =
1034: DECODE(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1035: approval_status),
1036: start_date =
1037: DECODE(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
1038: start_date),
1039: end_date =
1040: DECODE(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
1041: end_date)

Line 1040: DECODE(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,

1036: start_date =
1037: DECODE(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
1038: start_date),
1039: end_date =
1040: DECODE(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
1041: end_date)
1042: WHERE data_set_id = p_data_set_id
1043: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
1044: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE

Line 1044: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE

1040: DECODE(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
1041: end_date)
1042: WHERE data_set_id = p_data_set_id
1043: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
1044: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
1045: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
1046: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
1047: OR
1048: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

Line 1045: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)

1041: end_date)
1042: WHERE data_set_id = p_data_set_id
1043: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
1044: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
1045: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
1046: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
1047: OR
1048: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1049: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1046: <> EGO_ITEM_PUB.G_INTF_NULL_NUM

1042: WHERE data_set_id = p_data_set_id
1043: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
1044: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
1045: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
1046: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
1047: OR
1048: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1049: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1050: OR

Line 1048: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1044: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
1045: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
1046: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
1047: OR
1048: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1049: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1050: OR
1051: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1052: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1049: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1045: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
1046: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
1047: OR
1048: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1049: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1050: OR
1051: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1052: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1053: OR

Line 1051: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1047: OR
1048: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1049: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1050: OR
1051: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1052: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1053: OR
1054: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1055: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1052: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1048: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1049: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1050: OR
1051: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1052: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1053: OR
1054: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1055: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1056: OR

Line 1054: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1050: OR
1051: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1052: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1053: OR
1054: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1055: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1056: OR
1057: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1058: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1055: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1051: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1052: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1053: OR
1054: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1055: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1056: OR
1057: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1058: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1059: OR

Line 1057: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1053: OR
1054: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1055: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1056: OR
1057: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1058: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1059: OR
1060: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1061: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1058: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1054: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1055: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1056: OR
1057: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1058: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1059: OR
1060: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1061: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1062: OR

Line 1060: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1056: OR
1057: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1058: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1059: OR
1060: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1061: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1062: OR
1063: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1064: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1061: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1057: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1058: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1059: OR
1060: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1061: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1062: OR
1063: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1064: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1065: OR

Line 1063: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1059: OR
1060: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1061: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1062: OR
1063: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1064: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1065: OR
1066: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1067: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1064: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1060: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1061: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1062: OR
1063: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1064: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1065: OR
1066: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1067: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1068: OR

Line 1066: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1062: OR
1063: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1064: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1065: OR
1066: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1067: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1068: OR
1069: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1070: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1067: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1063: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1064: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1065: OR
1066: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1067: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1068: OR
1069: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1070: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1071: OR

Line 1069: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1065: OR
1066: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1067: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1068: OR
1069: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1070: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1071: OR
1072: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1073: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1070: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1066: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1067: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1068: OR
1069: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1070: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1071: OR
1072: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1073: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1074: OR

Line 1072: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1068: OR
1069: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1070: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1071: OR
1072: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1073: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1074: OR
1075: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1076: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1073: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1069: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1070: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1071: OR
1072: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1073: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1074: OR
1075: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1076: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1077: OR

Line 1075: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1071: OR
1072: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1073: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1074: OR
1075: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1076: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1077: OR
1078: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1079: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1076: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1072: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1073: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1074: OR
1075: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1076: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1077: OR
1078: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1079: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1080: OR

Line 1078: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1074: OR
1075: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1076: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1077: OR
1078: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1079: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1080: OR
1081: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1082: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1079: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1075: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1076: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1077: OR
1078: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1079: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1080: OR
1081: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1082: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1083: OR

Line 1081: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1077: OR
1078: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1079: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1080: OR
1081: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1082: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1083: OR
1084: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1085: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1082: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1078: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1079: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1080: OR
1081: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1082: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1083: OR
1084: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1085: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1086: OR

Line 1084: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1080: OR
1081: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1082: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1083: OR
1084: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1085: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1086: OR
1087: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1088: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1085: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1081: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1082: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1083: OR
1084: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1085: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1086: OR
1087: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1088: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1089: OR

Line 1087: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1083: OR
1084: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1085: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1086: OR
1087: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1088: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1089: OR
1090: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1091: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1088: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1084: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1085: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1086: OR
1087: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1088: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1089: OR
1090: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1091: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1092: OR

Line 1090: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1086: OR
1087: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1088: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1089: OR
1090: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1091: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1092: OR
1093: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1094: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1091: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1087: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1088: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1089: OR
1090: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1091: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1092: OR
1093: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1094: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1095: OR

Line 1093: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1089: OR
1090: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1091: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1092: OR
1093: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1094: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1095: OR
1096: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1097: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1094: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1090: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1091: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1092: OR
1093: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1094: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1095: OR
1096: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1097: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1098: OR

Line 1096: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1092: OR
1093: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1094: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1095: OR
1096: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1097: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1098: OR
1099: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1100: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1097: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1093: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1094: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1095: OR
1096: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1097: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1098: OR
1099: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1100: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1101: OR

Line 1099: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1095: OR
1096: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1097: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1098: OR
1099: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1100: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1101: OR
1102: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1103: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1100: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1096: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1097: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1098: OR
1099: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1100: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1101: OR
1102: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1103: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1104: OR

Line 1102: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1098: OR
1099: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1100: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1101: OR
1102: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1103: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1104: OR
1105: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1106: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

Line 1103: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1099: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1100: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1101: OR
1102: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1103: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1104: OR
1105: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1106: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1107: OR

Line 1105: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

1101: OR
1102: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1103: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1104: OR
1105: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1106: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1107: OR
1108: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1109: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

Line 1106: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

1102: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1103: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1104: OR
1105: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1106: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1107: OR
1108: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1109: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1110: );

Line 1108: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

1104: OR
1105: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1106: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1107: OR
1108: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1109: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1110: );
1111: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
1112: ,p_module => l_api_name

Line 1109: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

1105: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1106: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1107: OR
1108: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1109: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1110: );
1111: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
1112: ,p_module => l_api_name
1113: ,p_message => 'Changing intf table with NULL during CREATE'

Line 1141: DECODE(intf.mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,

1137: ,start_date
1138: ,end_date
1139: )
1140: = (SELECT
1141: DECODE(intf.mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,
1142: NULL,prod.mrp_planning_code,
1143: intf.mrp_planning_code),
1144: DECODE(intf.description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1145: NULL,prod.description,

Line 1144: DECODE(intf.description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1140: = (SELECT
1141: DECODE(intf.mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,
1142: NULL,prod.mrp_planning_code,
1143: intf.mrp_planning_code),
1144: DECODE(intf.description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1145: NULL,prod.description,
1146: intf.description),
1147: DECODE(intf.attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1148: NULL,prod.attribute_category,

Line 1147: DECODE(intf.attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1143: intf.mrp_planning_code),
1144: DECODE(intf.description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1145: NULL,prod.description,
1146: intf.description),
1147: DECODE(intf.attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1148: NULL,prod.attribute_category,
1149: intf.attribute_category),
1150: DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1151: NULL,prod.attribute1,

Line 1150: DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1146: intf.description),
1147: DECODE(intf.attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1148: NULL,prod.attribute_category,
1149: intf.attribute_category),
1150: DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1151: NULL,prod.attribute1,
1152: intf.attribute1),
1153: DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1154: NULL,prod.attribute2,

Line 1153: DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1149: intf.attribute_category),
1150: DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1151: NULL,prod.attribute1,
1152: intf.attribute1),
1153: DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1154: NULL,prod.attribute2,
1155: intf.attribute2),
1156: DECODE(intf.attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1157: NULL,prod.attribute3,

Line 1156: DECODE(intf.attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1152: intf.attribute1),
1153: DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1154: NULL,prod.attribute2,
1155: intf.attribute2),
1156: DECODE(intf.attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1157: NULL,prod.attribute3,
1158: intf.attribute3),
1159: DECODE(intf.attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1160: NULL,prod.attribute4,

Line 1159: DECODE(intf.attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1155: intf.attribute2),
1156: DECODE(intf.attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1157: NULL,prod.attribute3,
1158: intf.attribute3),
1159: DECODE(intf.attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1160: NULL,prod.attribute4,
1161: intf.attribute4),
1162: DECODE(intf.attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1163: NULL,prod.attribute5,

Line 1162: DECODE(intf.attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1158: intf.attribute3),
1159: DECODE(intf.attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1160: NULL,prod.attribute4,
1161: intf.attribute4),
1162: DECODE(intf.attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1163: NULL,prod.attribute5,
1164: intf.attribute5),
1165: DECODE(intf.attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1166: NULL,prod.attribute6,

Line 1165: DECODE(intf.attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1161: intf.attribute4),
1162: DECODE(intf.attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1163: NULL,prod.attribute5,
1164: intf.attribute5),
1165: DECODE(intf.attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1166: NULL,prod.attribute6,
1167: intf.attribute6),
1168: DECODE(intf.attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1169: NULL,prod.attribute7,

Line 1168: DECODE(intf.attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1164: intf.attribute5),
1165: DECODE(intf.attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1166: NULL,prod.attribute6,
1167: intf.attribute6),
1168: DECODE(intf.attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1169: NULL,prod.attribute7,
1170: intf.attribute7),
1171: DECODE(intf.attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1172: NULL,prod.attribute8,

Line 1171: DECODE(intf.attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1167: intf.attribute6),
1168: DECODE(intf.attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1169: NULL,prod.attribute7,
1170: intf.attribute7),
1171: DECODE(intf.attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1172: NULL,prod.attribute8,
1173: intf.attribute8),
1174: DECODE(intf.attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1175: NULL,prod.attribute9,

Line 1174: DECODE(intf.attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1170: intf.attribute7),
1171: DECODE(intf.attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1172: NULL,prod.attribute8,
1173: intf.attribute8),
1174: DECODE(intf.attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1175: NULL,prod.attribute9,
1176: intf.attribute9),
1177: DECODE(intf.attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1178: NULL,prod.attribute10,

Line 1177: DECODE(intf.attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1173: intf.attribute8),
1174: DECODE(intf.attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1175: NULL,prod.attribute9,
1176: intf.attribute9),
1177: DECODE(intf.attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1178: NULL,prod.attribute10,
1179: intf.attribute10),
1180: DECODE(intf.attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1181: NULL,prod.attribute11,

Line 1180: DECODE(intf.attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1176: intf.attribute9),
1177: DECODE(intf.attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1178: NULL,prod.attribute10,
1179: intf.attribute10),
1180: DECODE(intf.attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1181: NULL,prod.attribute11,
1182: intf.attribute11),
1183: DECODE(intf.attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1184: NULL,prod.attribute12,

Line 1183: DECODE(intf.attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1179: intf.attribute10),
1180: DECODE(intf.attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1181: NULL,prod.attribute11,
1182: intf.attribute11),
1183: DECODE(intf.attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1184: NULL,prod.attribute12,
1185: intf.attribute12),
1186: DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1187: NULL,prod.attribute13,

Line 1186: DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1182: intf.attribute11),
1183: DECODE(intf.attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1184: NULL,prod.attribute12,
1185: intf.attribute12),
1186: DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1187: NULL,prod.attribute13,
1188: intf.attribute13),
1189: DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1190: NULL,prod.attribute14,

Line 1189: DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1185: intf.attribute12),
1186: DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1187: NULL,prod.attribute13,
1188: intf.attribute13),
1189: DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1190: NULL,prod.attribute14,
1191: intf.attribute14),
1192: DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1193: NULL,prod.attribute15,

Line 1192: DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1188: intf.attribute13),
1189: DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1190: NULL,prod.attribute14,
1191: intf.attribute14),
1192: DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1193: NULL,prod.attribute15,
1194: intf.attribute15),
1195: DECODE(intf.first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1196: NULL,prod.first_article_status,

Line 1195: DECODE(intf.first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1191: intf.attribute14),
1192: DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1193: NULL,prod.attribute15,
1194: intf.attribute15),
1195: DECODE(intf.first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1196: NULL,prod.first_article_status,
1197: intf.first_article_status),
1198: DECODE(intf.approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1199: NULL,prod.approval_status,

Line 1198: DECODE(intf.approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

1194: intf.attribute15),
1195: DECODE(intf.first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1196: NULL,prod.first_article_status,
1197: intf.first_article_status),
1198: DECODE(intf.approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1199: NULL,prod.approval_status,
1200: intf.approval_status),
1201: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
1202: NULL,prod.start_date,

Line 1201: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,

1197: intf.first_article_status),
1198: DECODE(intf.approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
1199: NULL,prod.approval_status,
1200: intf.approval_status),
1201: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
1202: NULL,prod.start_date,
1203: intf.start_date),
1204: DECODE(intf.end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
1205: NULL,prod.end_date,

Line 1204: DECODE(intf.end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,

1200: intf.approval_status),
1201: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
1202: NULL,prod.start_date,
1203: intf.start_date),
1204: DECODE(intf.end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
1205: NULL,prod.end_date,
1206: intf.end_date)
1207: FROM mtl_mfg_part_numbers prod
1208: WHERE intf.inventory_item_id = prod.inventory_item_id

Line 1215: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE

1211: AND intf.mfg_part_num = prod.mfg_part_num
1212: )
1213: WHERE data_set_id = p_data_set_id
1214: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
1215: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
1216: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
1217: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
1218: OR
1219: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

Line 1216: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)

1212: )
1213: WHERE data_set_id = p_data_set_id
1214: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
1215: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
1216: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
1217: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
1218: OR
1219: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1220: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1217: <> EGO_ITEM_PUB.G_INTF_NULL_NUM

1213: WHERE data_set_id = p_data_set_id
1214: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
1215: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
1216: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
1217: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
1218: OR
1219: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1220: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1221: OR

Line 1219: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1215: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
1216: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
1217: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
1218: OR
1219: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1220: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1221: OR
1222: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1223: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1220: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1216: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
1217: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
1218: OR
1219: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1220: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1221: OR
1222: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1223: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1224: OR

Line 1222: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1218: OR
1219: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1220: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1221: OR
1222: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1223: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1224: OR
1225: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1226: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1223: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1219: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1220: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1221: OR
1222: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1223: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1224: OR
1225: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1226: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1227: OR

Line 1225: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1221: OR
1222: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1223: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1224: OR
1225: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1226: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1227: OR
1228: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1229: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1226: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1222: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1223: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1224: OR
1225: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1226: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1227: OR
1228: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1229: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1230: OR

Line 1228: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1224: OR
1225: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1226: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1227: OR
1228: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1229: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1230: OR
1231: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1232: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1229: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1225: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1226: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1227: OR
1228: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1229: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1230: OR
1231: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1232: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1233: OR

Line 1231: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1227: OR
1228: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1229: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1230: OR
1231: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1232: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1233: OR
1234: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1235: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1232: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1228: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1229: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1230: OR
1231: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1232: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1233: OR
1234: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1235: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1236: OR

Line 1234: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1230: OR
1231: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1232: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1233: OR
1234: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1235: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1236: OR
1237: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1238: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1235: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1231: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1232: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1233: OR
1234: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1235: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1236: OR
1237: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1238: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1239: OR

Line 1237: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1233: OR
1234: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1235: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1236: OR
1237: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1238: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1239: OR
1240: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1241: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1238: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1234: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1235: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1236: OR
1237: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1238: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1239: OR
1240: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1241: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1242: OR

Line 1240: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1236: OR
1237: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1238: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1239: OR
1240: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1241: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1242: OR
1243: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1244: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1241: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1237: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1238: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1239: OR
1240: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1241: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1242: OR
1243: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1244: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1245: OR

Line 1243: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1239: OR
1240: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1241: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1242: OR
1243: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1244: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1245: OR
1246: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1247: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1244: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1240: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1241: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1242: OR
1243: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1244: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1245: OR
1246: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1247: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1248: OR

Line 1246: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1242: OR
1243: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1244: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1245: OR
1246: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1247: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1248: OR
1249: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1250: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1247: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1243: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1244: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1245: OR
1246: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1247: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1248: OR
1249: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1250: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1251: OR

Line 1249: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1245: OR
1246: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1247: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1248: OR
1249: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1250: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1251: OR
1252: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1253: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1250: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1246: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1247: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1248: OR
1249: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1250: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1251: OR
1252: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1253: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1254: OR

Line 1252: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1248: OR
1249: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1250: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1251: OR
1252: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1253: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1254: OR
1255: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1256: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1253: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1249: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1250: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1251: OR
1252: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1253: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1254: OR
1255: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1256: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1257: OR

Line 1255: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1251: OR
1252: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1253: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1254: OR
1255: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1256: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1257: OR
1258: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1259: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1256: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1252: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1253: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1254: OR
1255: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1256: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1257: OR
1258: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1259: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1260: OR

Line 1258: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1254: OR
1255: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1256: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1257: OR
1258: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1259: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1260: OR
1261: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1262: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1259: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1255: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1256: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1257: OR
1258: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1259: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1260: OR
1261: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1262: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1263: OR

Line 1261: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1257: OR
1258: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1259: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1260: OR
1261: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1262: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1263: OR
1264: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1265: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1262: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1258: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1259: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1260: OR
1261: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1262: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1263: OR
1264: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1265: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1266: OR

Line 1264: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1260: OR
1261: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1262: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1263: OR
1264: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1265: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1266: OR
1267: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1268: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1265: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1261: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1262: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1263: OR
1264: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1265: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1266: OR
1267: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1268: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1269: OR

Line 1267: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1263: OR
1264: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1265: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1266: OR
1267: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1268: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1269: OR
1270: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1271: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1268: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1264: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1265: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1266: OR
1267: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1268: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1269: OR
1270: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1271: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1272: OR

Line 1270: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1266: OR
1267: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1268: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1269: OR
1270: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1271: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1272: OR
1273: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1274: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 1271: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1267: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1268: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1269: OR
1270: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1271: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1272: OR
1273: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1274: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1275: OR

Line 1273: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

1269: OR
1270: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1271: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1272: OR
1273: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1274: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1275: OR
1276: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1277: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

Line 1274: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

1270: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1271: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1272: OR
1273: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1274: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1275: OR
1276: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1277: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1278: OR

Line 1276: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

1272: OR
1273: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1274: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1275: OR
1276: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1277: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1278: OR
1279: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1280: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

Line 1277: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

1273: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
1274: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
1275: OR
1276: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1277: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1278: OR
1279: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1280: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1281: );

Line 1279: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

1275: OR
1276: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1277: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1278: OR
1279: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1280: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1281: );
1282: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
1283: ,p_module => l_api_name

Line 1280: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

1276: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1277: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1278: OR
1279: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
1280: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
1281: );
1282: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
1283: ,p_module => l_api_name
1284: ,p_message => 'Populate intf table with prod data for UPDATE done'

Line 1513: AND transaction_type IN (EGO_ITEM_PUB.G_TTYPE_CREATE

1509: SELECT *
1510: FROM ego_aml_intf
1511: WHERE data_set_id = cp_data_set_id
1512: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
1513: AND transaction_type IN (EGO_ITEM_PUB.G_TTYPE_CREATE
1514: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
1515: )
1516: ORDER BY attribute_category desc
1517: FOR UPDATE OF transaction_id;

Line 1514: ,EGO_ITEM_PUB.G_TTYPE_UPDATE

1510: FROM ego_aml_intf
1511: WHERE data_set_id = cp_data_set_id
1512: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
1513: AND transaction_type IN (EGO_ITEM_PUB.G_TTYPE_CREATE
1514: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
1515: )
1516: ORDER BY attribute_category desc
1517: FOR UPDATE OF transaction_id;
1518:

Line 1538: AND transaction_type IN (EGO_ITEM_PUB.G_TTYPE_CREATE

1534: INTO l_count
1535: FROM ego_aml_intf
1536: WHERE data_set_id = p_data_set_id
1537: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
1538: AND transaction_type IN (EGO_ITEM_PUB.G_TTYPE_CREATE
1539: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
1540: )
1541: AND ( attribute_category IS NOT NULL
1542: OR attribute1 IS NOT NULL

Line 1539: ,EGO_ITEM_PUB.G_TTYPE_UPDATE

1535: FROM ego_aml_intf
1536: WHERE data_set_id = p_data_set_id
1537: AND process_flag = G_PS_VAL_TO_ID_COMPLETE
1538: AND transaction_type IN (EGO_ITEM_PUB.G_TTYPE_CREATE
1539: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
1540: )
1541: AND ( attribute_category IS NOT NULL
1542: OR attribute1 IS NOT NULL
1543: OR attribute2 IS NOT NULL

Line 1895: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE;

1891: ,G_LOGIN_ID
1892: FROM ego_aml_intf
1893: WHERE data_set_id = p_data_set_id
1894: AND process_flag = G_PS_DFF_VAL_COMPLETE
1895: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE;
1896: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
1897: ,p_module => l_api_name
1898: ,p_message => 'Insert into production table done'
1899: );

Line 1957: AND intf.transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE

1953: ,G_LOGIN_ID
1954: FROM ego_aml_intf intf
1955: WHERE intf.data_set_id = p_data_set_id
1956: AND intf.process_flag = G_PS_DFF_VAL_COMPLETE
1957: AND intf.transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
1958: AND intf.inventory_item_id = prod.inventory_item_id
1959: AND intf.organization_id = prod.organization_id
1960: AND intf.manufacturer_id = prod.manufacturer_id
1961: AND intf.mfg_part_num = prod.mfg_part_num

Line 1967: and intf1.transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE

1963: WHERE EXISTS (select 1
1964: from ego_aml_intf intf1
1965: where intf1.data_set_id = p_data_set_id
1966: and intf1.process_flag = G_PS_DFF_VAL_COMPLETE
1967: and intf1.transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
1968: and intf1.inventory_item_id = prod.inventory_item_id
1969: and intf1.organization_id = prod.organization_id
1970: and intf1.manufacturer_id = prod.manufacturer_id
1971: and intf1.mfg_part_num = prod.mfg_part_num

Line 1984: and intf.transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE

1980: (Select 1
1981: From ego_aml_intf intf
1982: Where intf.data_set_id = p_data_set_id
1983: and intf.process_flag = G_PS_DFF_VAL_COMPLETE
1984: and intf.transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE
1985: and intf.inventory_item_id = prod.inventory_item_id
1986: and intf.organization_id = prod.organization_id
1987: and intf.manufacturer_id = prod.manufacturer_id
1988: and intf.mfg_part_num = prod.mfg_part_num

Line 2195: IF error_rec.transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN

2191: l_err_token_table(4).TOKEN_NAME := 'MFG';
2192: l_err_token_table(4).TOKEN_VALUE := error_rec.manufacturer_name;
2193: ELSIF error_rec.process_flag = G_PS_REC_NOT_EXISTS THEN
2194: l_message_has_token := TRUE;
2195: IF error_rec.transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
2196: l_err_msg_name := 'EGO_MPN_NOT_EXISTS_UPDATE';
2197: ELSE
2198: l_err_msg_name := 'EGO_MPN_NOT_EXISTS_DELETE';
2199: END IF;

Line 2225: IF error_rec.transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN

2221: SELECT name
2222: INTO l_dummy_message
2223: FROM pa_ego_phases_v
2224: WHERE proj_element_id = error_rec.prog_int_num3;
2225: IF error_rec.transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN
2226: l_err_msg_name := 'EGO_ITEM_LC_PREVENTS_AML';
2227: ELSE
2228: l_err_msg_name := 'EGO_LC_PREVENTS_AML_MOD';
2229: END IF;

Line 2374: (EGO_ITEM_PUB.G_INTF_DELETE_ALL

2370: END IF;
2371: IF (p_data_set_id IS NULL
2372: OR
2373: p_delete_line_type NOT IN
2374: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
2375: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
2376: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
2377: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
2378: )

Line 2375: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR

2371: IF (p_data_set_id IS NULL
2372: OR
2373: p_delete_line_type NOT IN
2374: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
2375: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
2376: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
2377: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
2378: )
2379: ) THEN

Line 2376: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS

2372: OR
2373: p_delete_line_type NOT IN
2374: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
2375: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
2376: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
2377: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
2378: )
2379: ) THEN
2380: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2377: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE

2373: p_delete_line_type NOT IN
2374: (EGO_ITEM_PUB.G_INTF_DELETE_ALL
2375: ,EGO_ITEM_PUB.G_INTF_DELETE_ERROR
2376: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
2377: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
2378: )
2379: ) THEN
2380: x_return_status := FND_API.G_RET_STS_ERROR;
2381: fnd_message.set_name('EGO','EGO_IPI_INSUFFICIENT_PARAMS');

Line 2395: IF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ALL THEN

2391: SAVEPOINT DELETE_AML_INTF_LINES_SP;
2392: END IF;
2393:
2394: l_table_name := 'EGO_AML_INTF';
2395: IF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ALL THEN
2396: --
2397: -- delete all lines
2398: --
2399: DELETE MTL_INTERFACE_ERRORS

Line 2410: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ERROR THEN

2406:
2407: DELETE EGO_AML_INTF
2408: WHERE data_set_id = p_data_set_id;
2409:
2410: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ERROR THEN
2411: --
2412: -- delete all error lines
2413: --
2414: DELETE MTL_INTERFACE_ERRORS

Line 2427: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS THEN

2423: DELETE EGO_AML_INTF
2424: WHERE data_set_id = p_data_set_id
2425: AND process_flag = G_PS_GENERIC_ERROR;
2426:
2427: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS THEN
2428: --
2429: -- delete all success lines
2430: --
2431: DELETE EGO_AML_INTF

Line 2592: := NVL(p_delete_line_type, EGO_ITEM_PUB.G_INTF_DELETE_NONE);

2588: ,p_module => l_api_name
2589: ,p_message => 'Error Handler Initialization successful '
2590: );
2591: l_delete_line_type
2592: := NVL(p_delete_line_type, EGO_ITEM_PUB.G_INTF_DELETE_NONE);
2593: l_mode := NVL(p_mode, MODE_NORMAL);
2594: IF l_mode = MODE_NORMAL THEN
2595: l_prog_mode_history := FALSE;
2596: ELSE

Line 2610: (first_article_status_meaning = EGO_ITEM_PUB.G_INTF_NULL_CHAR

2606: transaction_type = UPPER(transaction_type),
2607: transaction_id = NVL(transaction_id, EGO_IPI_TRANSACTION_ID_S.nextval),
2608: first_article_status =
2609: (SELECT CASE WHEN
2610: (first_article_status_meaning = EGO_ITEM_PUB.G_INTF_NULL_CHAR
2611: AND
2612: first_article_status IS NULL
2613: )
2614: THEN EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2614: THEN EGO_ITEM_PUB.G_INTF_NULL_CHAR

2610: (first_article_status_meaning = EGO_ITEM_PUB.G_INTF_NULL_CHAR
2611: AND
2612: first_article_status IS NULL
2613: )
2614: THEN EGO_ITEM_PUB.G_INTF_NULL_CHAR
2615: ELSE first_article_status
2616: END
2617: FROM DUAL),
2618: approval_status =

Line 2620: (approval_status_meaning = EGO_ITEM_PUB.G_INTF_NULL_CHAR

2616: END
2617: FROM DUAL),
2618: approval_status =
2619: (SELECT CASE WHEN
2620: (approval_status_meaning = EGO_ITEM_PUB.G_INTF_NULL_CHAR
2621: AND
2622: approval_status IS NULL
2623: )
2624: THEN EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2624: THEN EGO_ITEM_PUB.G_INTF_NULL_CHAR

2620: (approval_status_meaning = EGO_ITEM_PUB.G_INTF_NULL_CHAR
2621: AND
2622: approval_status IS NULL
2623: )
2624: THEN EGO_ITEM_PUB.G_INTF_NULL_CHAR
2625: ELSE approval_status
2626: END
2627: FROM DUAL),
2628: request_id = G_REQUEST_ID,

Line 2872: IF p_delete_line_type <> EGO_ITEM_PUB.G_INTF_DELETE_NONE THEN

2868: ,p_message => l_msg_data
2869: );
2870: END IF;
2871:
2872: IF p_delete_line_type <> EGO_ITEM_PUB.G_INTF_DELETE_NONE THEN
2873: Delete_AML_Interface_Lines(p_api_version => 1.0
2874: ,p_commit => FND_API.G_FALSE
2875: ,p_data_set_id => p_data_set_id
2876: ,p_delete_line_type => p_delete_line_type