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);
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;
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);
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
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
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
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 ;
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:
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
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
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
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: ) ;
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'
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
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:
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:
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;