DBA Data[Home] [Help]

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: G_ENTITY_CODE VARCHAR2(30);

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: G_ENTITY_CODE VARCHAR2(30);
84: G_ENTITY_ID NUMBER;

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: G_ENTITY_CODE VARCHAR2(30);
84: G_ENTITY_ID NUMBER;
85: G_APPLICATION_CONTEXT VARCHAR2(30);

Line 1381: ,x_single_row_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP

1377: ,p_organization_id IN NUMBER
1378: ,p_change_id IN NUMBER
1379: ,p_change_line_id IN NUMBER
1380: ,p_acd_type IN VARCHAR2 := NULL
1381: ,x_single_row_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
1382: ,x_multi_row_attrs_tbl IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
1383: ,x_extra_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP
1384: )
1385: IS

Line 1382: ,x_multi_row_attrs_tbl IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP

1378: ,p_change_id IN NUMBER
1379: ,p_change_line_id IN NUMBER
1380: ,p_acd_type IN VARCHAR2 := NULL
1381: ,x_single_row_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
1382: ,x_multi_row_attrs_tbl IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
1383: ,x_extra_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP
1384: )
1385: IS
1386: CURSOR c_pending_single_row_attrs(c_inventory_item_id IN NUMBER

Line 1383: ,x_extra_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP

1379: ,p_change_line_id IN NUMBER
1380: ,p_acd_type IN VARCHAR2 := NULL
1381: ,x_single_row_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
1382: ,x_multi_row_attrs_tbl IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
1383: ,x_extra_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP
1384: )
1385: IS
1386: CURSOR c_pending_single_row_attrs(c_inventory_item_id IN NUMBER
1387: ,c_organization_id IN NUMBER

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

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

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

1838: Write_Debug('Merging Extra Row . . .') ;
1839:
1840: IF k.UNIT_WEIGHT = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM
1841: THEN
1842: x_extra_attrs_rec.UNIT_WEIGHT := EGO_ITEM_PUB.G_INTF_NULL_NUM ;
1843: ELSE
1844: x_extra_attrs_rec.UNIT_WEIGHT := k.UNIT_WEIGHT ;
1845: END IF ;
1846:

Line 1889: l_single_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;

1885: l_msg_data VARCHAR2(4000);
1886: l_msg_text VARCHAR2(4000);
1887: l_acd_type VARCHAR2(30) ;
1888:
1889: l_single_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
1890: l_multi_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP ;
1891: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;
1892:
1893: CURSOR c_intf_rows IS

Line 1890: l_multi_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP ;

1886: l_msg_text VARCHAR2(4000);
1887: l_acd_type VARCHAR2(30) ;
1888:
1889: l_single_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
1890: l_multi_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP ;
1891: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;
1892:
1893: CURSOR c_intf_rows IS
1894: SELECT

Line 1891: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;

1887: l_acd_type VARCHAR2(30) ;
1888:
1889: l_single_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
1890: l_multi_row_attrs EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP ;
1891: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;
1892:
1893: CURSOR c_intf_rows IS
1894: SELECT
1895: INVENTORY_ITEM_ID

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

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

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

2483: = (SELECT
2484: DECODE(intf.mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,
2485: NULL,pending_change.mrp_planning_code,
2486: intf.mrp_planning_code),
2487: DECODE(intf.description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2488: NULL,pending_change.description,
2489: intf.description),
2490: DECODE(intf.first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2491: NULL,pending_change.first_article_status,

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

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

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

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

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

2492: intf.first_article_status),
2493: DECODE(intf.approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2494: NULL,pending_change.approval_status,
2495: intf.approval_status),
2496: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
2497: NULL,pending_change.start_date,
2498: intf.start_date),
2499: DECODE(intf.end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
2500: NULL,pending_change.end_date,

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

2495: intf.approval_status),
2496: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
2497: NULL,pending_change.start_date,
2498: intf.start_date),
2499: DECODE(intf.end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
2500: NULL,pending_change.end_date,
2501: intf.end_date),
2502: G_CM_TO_BE_PROCESSED
2503: -- NO Needt copy for DFF in R12

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

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

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

2503: -- NO Needt copy for DFF in R12
2504: -- , DECODE(intf.attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2505: -- NULL,pending_change.attribute_category,
2506: -- intf.attribute_category),
2507: -- DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2508: -- NULL,pending_change.attribute1,
2509: -- intf.attribute1),
2510: -- DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2511: -- NULL,pending_change.attribute2,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2542: -- intf.attribute12),
2543: -- DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2544: -- NULL,pending_change.attribute13,
2545: -- intf.attribute13),
2546: -- DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2547: -- NULL,pending_change.attribute14,
2548: -- intf.attribute14),
2549: -- DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2550: -- NULL,pending_change.attribute15,

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

2545: -- intf.attribute13),
2546: -- DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2547: -- NULL,pending_change.attribute14,
2548: -- intf.attribute14),
2549: -- DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2550: -- NULL,pending_change.attribute15,
2551: -- intf.attribute15)
2552: FROM EGO_MFG_PART_NUM_CHGS pending_change
2553: WHERE intf.inventory_item_id = pending_change.inventory_item_id

Line 2564: -- AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE

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

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

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

Line 2566: <> EGO_ITEM_PUB.G_INTF_NULL_NUM

2562: WHERE data_set_id = p_batch_id
2563: AND process_flag = G_CM_DATA_POPULATION
2564: -- AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
2565: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
2566: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
2567: OR
2568: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2569: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2570: OR

Line 2568: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

2564: -- AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
2565: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
2566: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
2567: OR
2568: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2569: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2570: OR
2571: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2572: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2569: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2565: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
2566: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
2567: OR
2568: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2569: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2570: OR
2571: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2572: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2573: OR

Line 2571: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

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

Line 2572: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

Line 2574: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

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

Line 2575: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

Line 2577: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

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

Line 2578: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

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

Line 2580: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

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

Line 2581: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

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

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

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

Line 2584: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2587: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2590: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2593: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2596: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2599: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2602: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2605: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2608: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2611: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2614: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2617: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2620: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

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

Line 2623: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

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

2621: -- OR
2622: -- NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2623: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2624: -- OR
2625: -- NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2626: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2627: -- OR
2628: -- NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2629: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 2626: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

2622: -- NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2623: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2624: -- OR
2625: -- NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2626: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2627: -- OR
2628: -- NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
2629: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2630: ) ;

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

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

Line 2629: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

Line 5661: l_null_out_value := EGO_ITEM_PUB.G_INTF_NULL_CHAR;

5657: BEGIN
5658: l_null_out_value := value;
5659: if ( value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR)
5660: THEN
5661: l_null_out_value := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
5662: END IF;
5663: return l_null_out_value;
5664: END Get_Nulled_out_Value;
5665:

Line 5674: l_null_out_value := EGO_ITEM_PUB.G_INTF_NULL_DATE;

5670: BEGIN
5671: l_null_out_value := value;
5672: if ( value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE)
5673: THEN
5674: l_null_out_value := EGO_ITEM_PUB.G_INTF_NULL_DATE;
5675: END IF;
5676: return l_null_out_value;
5677: END Get_Nulled_out_Value;
5678:

Line 5687: l_null_out_value := EGO_ITEM_PUB.G_INTF_NULL_NUM;

5683: BEGIN
5684: l_null_out_value := value;
5685: if ( value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM)
5686: THEN
5687: l_null_out_value := EGO_ITEM_PUB.G_INTF_NULL_NUM;
5688: END IF;
5689: return l_null_out_value;
5690:
5691: END Get_Nulled_out_Value;