APPS.ENG_CHANGE_IMPORT_UTIL dependencies on EGO_ITEM_PUB

Line 79: G_MISS_NUM NUMBER := EGO_ITEM_PUB.G_INTF_NULL_NUM;

75:
76: ---------------------------------------------------------------
77: -- Special Miss Values . --
78: ---------------------------------------------------------------
79: G_MISS_NUM NUMBER := EGO_ITEM_PUB.G_INTF_NULL_NUM;
80: G_MISS_CHAR VARCHAR2(1) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
81: G_MISS_DATE DATE := EGO_ITEM_PUB.G_INTF_NULL_DATE;
82:
83:

Line 80: G_MISS_CHAR VARCHAR2(1) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;

76: ---------------------------------------------------------------
77: -- Special Miss Values . --
78: ---------------------------------------------------------------
79: G_MISS_NUM NUMBER := EGO_ITEM_PUB.G_INTF_NULL_NUM;
80: G_MISS_CHAR VARCHAR2(1) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
81: G_MISS_DATE DATE := EGO_ITEM_PUB.G_INTF_NULL_DATE;
82:
83:
84: -----------------------------------------------------------------

Line 81: G_MISS_DATE DATE := EGO_ITEM_PUB.G_INTF_NULL_DATE;

77: -- Special Miss Values . --
78: ---------------------------------------------------------------
79: G_MISS_NUM NUMBER := EGO_ITEM_PUB.G_INTF_NULL_NUM;
80: G_MISS_CHAR VARCHAR2(1) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
81: G_MISS_DATE DATE := EGO_ITEM_PUB.G_INTF_NULL_DATE;
82:
83:
84: -----------------------------------------------------------------
85: -- Write Debug statements to Log using Error Handler procedure --

Line 1377: ,x_single_row_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP

1373: ,p_organization_id IN NUMBER
1374: ,p_change_id IN NUMBER
1375: ,p_change_line_id IN NUMBER
1376: ,p_acd_type IN VARCHAR2 := NULL
1377: ,x_single_row_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
1378: ,x_multi_row_attrs_tbl IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
1379: ,x_extra_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP
1380: )
1381: IS

Line 1378: ,x_multi_row_attrs_tbl IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP

1374: ,p_change_id IN NUMBER
1375: ,p_change_line_id IN NUMBER
1376: ,p_acd_type IN VARCHAR2 := NULL
1377: ,x_single_row_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
1378: ,x_multi_row_attrs_tbl IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
1379: ,x_extra_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP
1380: )
1381: IS
1382: CURSOR c_pending_single_row_attrs(c_inventory_item_id IN NUMBER

Line 1379: ,x_extra_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP

1375: ,p_change_line_id IN NUMBER
1376: ,p_acd_type IN VARCHAR2 := NULL
1377: ,x_single_row_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
1378: ,x_multi_row_attrs_tbl IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
1379: ,x_extra_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP
1380: )
1381: IS
1382: CURSOR c_pending_single_row_attrs(c_inventory_item_id IN NUMBER
1383: ,c_organization_id IN NUMBER

Line 1827: --(a) unit_weight is present in pending table with value Null-Out Value -> EGO_ITEM_PUB.G_INTF_NULL_NUM

1823: END LOOP; -- end loop multi row attributes
1824:
1825: --Setting the value for x_extra_attrs_rec
1826: --Logic needs to be added to work as following:
1827: --(a) unit_weight is present in pending table with value Null-Out Value -> EGO_ITEM_PUB.G_INTF_NULL_NUM
1828: --(b) unit_weight is not present in pending table -> NULL
1829: --(c) unit_weight is present in pending table with non-null value -> pass the value present in the table.
1830:
1831: x_extra_attrs_rec.UNIT_WEIGHT := NULL ;

Line 1838: x_extra_attrs_rec.UNIT_WEIGHT := EGO_ITEM_PUB.G_INTF_NULL_NUM ;

1834: Write_Debug('Merging Extra Row . . .') ;
1835:
1836: IF k.UNIT_WEIGHT = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM
1837: THEN
1838: x_extra_attrs_rec.UNIT_WEIGHT := EGO_ITEM_PUB.G_INTF_NULL_NUM ;
1839: ELSE
1840: x_extra_attrs_rec.UNIT_WEIGHT := k.UNIT_WEIGHT ;
1841: END IF ;
1842:

Line 1885: l_single_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;

1881: l_msg_data VARCHAR2(4000);
1882: l_msg_text VARCHAR2(4000);
1883: l_acd_type VARCHAR2(30) ;
1884:
1885: l_single_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
1886: l_multi_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP ;
1887: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;
1888:
1889: CURSOR c_intf_rows IS

Line 1886: l_multi_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP ;

1882: l_msg_text VARCHAR2(4000);
1883: l_acd_type VARCHAR2(30) ;
1884:
1885: l_single_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
1886: l_multi_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP ;
1887: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;
1888:
1889: CURSOR c_intf_rows IS
1890: SELECT

Line 1887: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;

1883: l_acd_type VARCHAR2(30) ;
1884:
1885: l_single_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
1886: l_multi_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP ;
1887: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;
1888:
1889: CURSOR c_intf_rows IS
1890: SELECT
1891: INVENTORY_ITEM_ID

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

2476: -- ,attribute14
2477: -- ,attribute15
2478: )
2479: = (SELECT
2480: DECODE(intf.mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,
2481: NULL,pending_change.mrp_planning_code,
2482: intf.mrp_planning_code),
2483: DECODE(intf.description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2484: NULL,pending_change.description,

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

2479: = (SELECT
2480: DECODE(intf.mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,
2481: NULL,pending_change.mrp_planning_code,
2482: intf.mrp_planning_code),
2483: DECODE(intf.description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2484: NULL,pending_change.description,
2485: intf.description),
2486: DECODE(intf.first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2487: NULL,pending_change.first_article_status,

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

2482: intf.mrp_planning_code),
2483: DECODE(intf.description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2484: NULL,pending_change.description,
2485: intf.description),
2486: DECODE(intf.first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2487: NULL,pending_change.first_article_status,
2488: intf.first_article_status),
2489: DECODE(intf.approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2490: NULL,pending_change.approval_status,

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

2485: intf.description),
2486: DECODE(intf.first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2487: NULL,pending_change.first_article_status,
2488: intf.first_article_status),
2489: DECODE(intf.approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2490: NULL,pending_change.approval_status,
2491: intf.approval_status),
2492: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
2493: NULL,pending_change.start_date,

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

2488: intf.first_article_status),
2489: DECODE(intf.approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2490: NULL,pending_change.approval_status,
2491: intf.approval_status),
2492: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
2493: NULL,pending_change.start_date,
2494: intf.start_date),
2495: DECODE(intf.end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
2496: NULL,pending_change.end_date,

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

2491: intf.approval_status),
2492: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
2493: NULL,pending_change.start_date,
2494: intf.start_date),
2495: DECODE(intf.end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
2496: NULL,pending_change.end_date,
2497: intf.end_date),
2498: G_CM_TO_BE_PROCESSED
2499: -- NO Needt copy for DFF in R12

Line 2500: -- , DECODE(intf.attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2496: NULL,pending_change.end_date,
2497: intf.end_date),
2498: G_CM_TO_BE_PROCESSED
2499: -- NO Needt copy for DFF in R12
2500: -- , DECODE(intf.attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2501: -- NULL,pending_change.attribute_category,
2502: -- intf.attribute_category),
2503: -- DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2504: -- NULL,pending_change.attribute1,

Line 2503: -- DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2499: -- NO Needt copy for DFF in R12
2500: -- , DECODE(intf.attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2501: -- NULL,pending_change.attribute_category,
2502: -- intf.attribute_category),
2503: -- DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2504: -- NULL,pending_change.attribute1,
2505: -- intf.attribute1),
2506: -- DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2507: -- NULL,pending_change.attribute2,

Line 2506: -- DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2502: -- intf.attribute_category),
2503: -- DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2504: -- NULL,pending_change.attribute1,
2505: -- intf.attribute1),
2506: -- DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2507: -- NULL,pending_change.attribute2,
2508: -- intf.attribute2),
2509: -- DECODE(intf.attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2510: -- NULL,pending_change.attribute3,

Line 2509: -- DECODE(intf.attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2505: -- intf.attribute1),
2506: -- DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2507: -- NULL,pending_change.attribute2,
2508: -- intf.attribute2),
2509: -- DECODE(intf.attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2510: -- NULL,pending_change.attribute3,
2511: -- intf.attribute3),
2512: -- DECODE(intf.attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2513: -- NULL,pending_change.attribute4,

Line 2512: -- DECODE(intf.attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2508: -- intf.attribute2),
2509: -- DECODE(intf.attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2510: -- NULL,pending_change.attribute3,
2511: -- intf.attribute3),
2512: -- DECODE(intf.attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2513: -- NULL,pending_change.attribute4,
2514: -- intf.attribute4),
2515: -- DECODE(intf.attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2516: -- NULL,pending_change.attribute5,

Line 2515: -- DECODE(intf.attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2511: -- intf.attribute3),
2512: -- DECODE(intf.attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2513: -- NULL,pending_change.attribute4,
2514: -- intf.attribute4),
2515: -- DECODE(intf.attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2516: -- NULL,pending_change.attribute5,
2517: -- intf.attribute5),
2518: -- DECODE(intf.attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2519: -- NULL,pending_change.attribute6,

Line 2518: -- DECODE(intf.attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2514: -- intf.attribute4),
2515: -- DECODE(intf.attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2516: -- NULL,pending_change.attribute5,
2517: -- intf.attribute5),
2518: -- DECODE(intf.attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2519: -- NULL,pending_change.attribute6,
2520: -- intf.attribute6),
2521: -- DECODE(intf.attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2522: -- NULL,pending_change.attribute7,

Line 2521: -- DECODE(intf.attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2517: -- intf.attribute5),
2518: -- DECODE(intf.attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2519: -- NULL,pending_change.attribute6,
2520: -- intf.attribute6),
2521: -- DECODE(intf.attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2522: -- NULL,pending_change.attribute7,
2523: -- intf.attribute7),
2524: -- DECODE(intf.attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2525: -- NULL,pending_change.attribute8,

Line 2524: -- DECODE(intf.attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2520: -- intf.attribute6),
2521: -- DECODE(intf.attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2522: -- NULL,pending_change.attribute7,
2523: -- intf.attribute7),
2524: -- DECODE(intf.attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2525: -- NULL,pending_change.attribute8,
2526: -- intf.attribute8),
2527: -- DECODE(intf.attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2528: -- NULL,pending_change.attribute9,

Line 2527: -- DECODE(intf.attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2523: -- intf.attribute7),
2524: -- DECODE(intf.attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2525: -- NULL,pending_change.attribute8,
2526: -- intf.attribute8),
2527: -- DECODE(intf.attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2528: -- NULL,pending_change.attribute9,
2529: -- intf.attribute9),
2530: -- DECODE(intf.attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2531: -- NULL,pending_change.attribute10,

Line 2530: -- DECODE(intf.attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2526: -- intf.attribute8),
2527: -- DECODE(intf.attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2528: -- NULL,pending_change.attribute9,
2529: -- intf.attribute9),
2530: -- DECODE(intf.attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2531: -- NULL,pending_change.attribute10,
2532: -- intf.attribute10),
2533: -- DECODE(intf.attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2534: -- NULL,pending_change.attribute11,

Line 2533: -- DECODE(intf.attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2529: -- intf.attribute9),
2530: -- DECODE(intf.attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2531: -- NULL,pending_change.attribute10,
2532: -- intf.attribute10),
2533: -- DECODE(intf.attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2534: -- NULL,pending_change.attribute11,
2535: -- intf.attribute11),
2536: -- DECODE(intf.attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2537: -- NULL,pending_change.attribute12,

Line 2536: -- DECODE(intf.attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2532: -- intf.attribute10),
2533: -- DECODE(intf.attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2534: -- NULL,pending_change.attribute11,
2535: -- intf.attribute11),
2536: -- DECODE(intf.attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2537: -- NULL,pending_change.attribute12,
2538: -- intf.attribute12),
2539: -- DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2540: -- NULL,pending_change.attribute13,

Line 2539: -- DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2535: -- intf.attribute11),
2536: -- DECODE(intf.attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2537: -- NULL,pending_change.attribute12,
2538: -- intf.attribute12),
2539: -- DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2540: -- NULL,pending_change.attribute13,
2541: -- intf.attribute13),
2542: -- DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2543: -- NULL,pending_change.attribute14,

Line 2542: -- DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2538: -- intf.attribute12),
2539: -- DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2540: -- NULL,pending_change.attribute13,
2541: -- intf.attribute13),
2542: -- DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2543: -- NULL,pending_change.attribute14,
2544: -- intf.attribute14),
2545: -- DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2546: -- NULL,pending_change.attribute15,

Line 2545: -- DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

2541: -- intf.attribute13),
2542: -- DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2543: -- NULL,pending_change.attribute14,
2544: -- intf.attribute14),
2545: -- DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2546: -- NULL,pending_change.attribute15,
2547: -- intf.attribute15)
2548: FROM EGO_MFG_PART_NUM_CHGS pending_change
2549: WHERE intf.inventory_item_id = pending_change.inventory_item_id

Line 2560: -- AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE

2556: , 'DELETE', 'DELETE', 'INVALID')
2557: )
2558: WHERE data_set_id = p_batch_id
2559: AND process_flag = G_CM_DATA_POPULATION
2560: -- AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
2561: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
2562: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
2563: OR
2564: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

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

2557: )
2558: WHERE data_set_id = p_batch_id
2559: AND process_flag = G_CM_DATA_POPULATION
2560: -- AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
2561: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
2562: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
2563: OR
2564: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2565: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2562: <> EGO_ITEM_PUB.G_INTF_NULL_NUM

2558: WHERE data_set_id = p_batch_id
2559: AND process_flag = G_CM_DATA_POPULATION
2560: -- AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
2561: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
2562: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
2563: OR
2564: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2565: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2566: OR

Line 2564: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2560: -- AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
2561: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
2562: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
2563: OR
2564: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2565: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2566: OR
2567: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2568: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2565: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2561: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
2562: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
2563: OR
2564: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2565: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2566: OR
2567: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2568: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2569: OR

Line 2567: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2563: OR
2564: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2565: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2566: OR
2567: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2568: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2569: OR
2570: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2571: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2568: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2564: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2565: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2566: OR
2567: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2568: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2569: OR
2570: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2571: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2572: OR

Line 2570: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2566: OR
2567: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2568: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2569: OR
2570: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2571: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2572: OR
2573: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
2574: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

Line 2571: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2567: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2568: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2569: OR
2570: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2571: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2572: OR
2573: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
2574: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
2575: OR

Line 2573: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

2569: OR
2570: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2571: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2572: OR
2573: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
2574: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
2575: OR
2576: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
2577: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

Line 2574: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

2570: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2571: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2572: OR
2573: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
2574: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
2575: OR
2576: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
2577: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
2578: -- OR

Line 2576: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

2572: OR
2573: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
2574: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
2575: OR
2576: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
2577: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
2578: -- OR
2579: -- NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2580: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2577: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

2573: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
2574: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
2575: OR
2576: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
2577: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
2578: -- OR
2579: -- NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2580: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2581: -- OR

Line 2579: -- NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2575: OR
2576: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
2577: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
2578: -- OR
2579: -- NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2580: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2581: -- OR
2582: -- NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2583: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2580: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2576: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
2577: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
2578: -- OR
2579: -- NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2580: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2581: -- OR
2582: -- NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2583: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2584: -- OR

Line 2582: -- NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2578: -- OR
2579: -- NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2580: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2581: -- OR
2582: -- NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2583: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2584: -- OR
2585: -- NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2586: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2583: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2579: -- NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2580: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2581: -- OR
2582: -- NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2583: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2584: -- OR
2585: -- NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2586: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2587: -- OR

Line 2585: -- NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2581: -- OR
2582: -- NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2583: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2584: -- OR
2585: -- NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2586: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2587: -- OR
2588: -- NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2589: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2586: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2582: -- NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2583: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2584: -- OR
2585: -- NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2586: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2587: -- OR
2588: -- NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2589: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2590: -- OR

Line 2588: -- NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2584: -- OR
2585: -- NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2586: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2587: -- OR
2588: -- NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2589: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2590: -- OR
2591: -- NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2592: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2589: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2585: -- NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2586: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2587: -- OR
2588: -- NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2589: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2590: -- OR
2591: -- NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2592: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2593: -- OR

Line 2591: -- NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2587: -- OR
2588: -- NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2589: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2590: -- OR
2591: -- NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2592: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2593: -- OR
2594: -- NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2595: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2592: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2588: -- NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2589: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2590: -- OR
2591: -- NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2592: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2593: -- OR
2594: -- NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2595: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2596: -- OR

Line 2594: -- NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2590: -- OR
2591: -- NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2592: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2593: -- OR
2594: -- NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2595: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2596: -- OR
2597: -- NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2598: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2595: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2591: -- NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2592: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2593: -- OR
2594: -- NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2595: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2596: -- OR
2597: -- NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2598: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2599: -- OR

Line 2597: -- NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2593: -- OR
2594: -- NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2595: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2596: -- OR
2597: -- NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2598: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2599: -- OR
2600: -- NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2601: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2598: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2594: -- NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2595: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2596: -- OR
2597: -- NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2598: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2599: -- OR
2600: -- NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2601: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2602: -- OR

Line 2600: -- NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2596: -- OR
2597: -- NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2598: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2599: -- OR
2600: -- NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2601: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2602: -- OR
2603: -- NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2604: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2601: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2597: -- NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2598: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2599: -- OR
2600: -- NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2601: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2602: -- OR
2603: -- NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2604: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2605: -- OR

Line 2603: -- NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2599: -- OR
2600: -- NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2601: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2602: -- OR
2603: -- NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2604: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2605: -- OR
2606: -- NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2607: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2604: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2600: -- NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2601: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2602: -- OR
2603: -- NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2604: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2605: -- OR
2606: -- NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2607: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2608: -- OR

Line 2606: -- NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2602: -- OR
2603: -- NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2604: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2605: -- OR
2606: -- NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2607: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2608: -- OR
2609: -- NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2610: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2607: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2603: -- NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2604: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2605: -- OR
2606: -- NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2607: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2608: -- OR
2609: -- NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2610: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2611: -- OR

Line 2609: -- NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2605: -- OR
2606: -- NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2607: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2608: -- OR
2609: -- NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2610: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2611: -- OR
2612: -- NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2613: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2610: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2606: -- NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2607: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2608: -- OR
2609: -- NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2610: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2611: -- OR
2612: -- NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2613: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2614: -- OR

Line 2612: -- NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2608: -- OR
2609: -- NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2610: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2611: -- OR
2612: -- NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2613: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2614: -- OR
2615: -- NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2616: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2613: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2609: -- NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2610: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2611: -- OR
2612: -- NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2613: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2614: -- OR
2615: -- NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2616: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2617: -- OR

Line 2615: -- NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2611: -- OR
2612: -- NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2613: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2614: -- OR
2615: -- NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2616: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2617: -- OR
2618: -- NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2619: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2616: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2612: -- NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2613: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2614: -- OR
2615: -- NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2616: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2617: -- OR
2618: -- NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2619: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2620: -- OR

Line 2618: -- NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2614: -- OR
2615: -- NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2616: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2617: -- OR
2618: -- NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2619: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2620: -- OR
2621: -- NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2622: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2619: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2615: -- NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2616: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2617: -- OR
2618: -- NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2619: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2620: -- OR
2621: -- NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2622: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2623: -- OR

Line 2621: -- NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2617: -- OR
2618: -- NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2619: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2620: -- OR
2621: -- NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2622: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2623: -- OR
2624: -- NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2625: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2622: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2618: -- NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2619: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2620: -- OR
2621: -- NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2622: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2623: -- OR
2624: -- NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2625: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2626: ) ;

Line 2624: -- NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2620: -- OR
2621: -- NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2622: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2623: -- OR
2624: -- NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2625: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2626: ) ;
2627: -- I don't think we need this
2628: -- AND EXISTS WHEN ( SELECT 'x'

Line 2625: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2621: -- NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2622: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2623: -- OR
2624: -- NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2625: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2626: ) ;
2627: -- I don't think we need this
2628: -- AND EXISTS WHEN ( SELECT 'x'
2629: -- FROM EGO_MFG_PART_NUM_CHGS pending_change2

Line 5530: l_null_out_value := EGO_ITEM_PUB.G_INTF_NULL_CHAR;

5526: BEGIN
5527: l_null_out_value := value;
5528: if ( value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR)
5529: THEN
5530: l_null_out_value := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
5531: END IF;
5532: return l_null_out_value;
5533: END Get_Nulled_out_Value;
5534:

Line 5543: l_null_out_value := EGO_ITEM_PUB.G_INTF_NULL_DATE;

5539: BEGIN
5540: l_null_out_value := value;
5541: if ( value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE)
5542: THEN
5543: l_null_out_value := EGO_ITEM_PUB.G_INTF_NULL_DATE;
5544: END IF;
5545: return l_null_out_value;
5546: END Get_Nulled_out_Value;
5547:

Line 5556: l_null_out_value := EGO_ITEM_PUB.G_INTF_NULL_NUM;

5552: BEGIN
5553: l_null_out_value := value;
5554: if ( value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM)
5555: THEN
5556: l_null_out_value := EGO_ITEM_PUB.G_INTF_NULL_NUM;
5557: END IF;
5558: return l_null_out_value;
5559:
5560: END Get_Nulled_out_Value;