eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSMPLBJI dependencies on WIP_CONSTANTS

Line 400: l_org_id := get_one_org_id(p_group_id, WIP_CONSTANTS.PENDING);

396:
397: IF (WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y') THEN
398: l_profile := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(0);
399: ELSE
400: l_org_id := get_one_org_id(p_group_id, WIP_CONSTANTS.PENDING);
401: if (l_org_id = -1) then
402: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',
403: 'Error: failed in get_one_org_id');
404: return;

Line 449: l_org_id := get_one_org_id(l_group_id, WIP_CONSTANTS.RUNNING);

445:
446: IF (WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y') THEN
447: l_profile := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(0);
448: ELSE
449: l_org_id := get_one_org_id(l_group_id, WIP_CONSTANTS.RUNNING);
450: if (l_org_id = -1) then
451: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',
452: 'Error: failed in get_one_org_id');
453: return;

Line 837: ROUND(p_start_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION), 0)), 0)

833: where wip_entity_id = p_wip_entity_id
834: and operation_seq_num > wo.operation_seq_num),
835: wo.quantity_in_queue = decode(operation_seq_num, max_op_seq_num,
836: (decode(p_status_type, 3,
837: ROUND(p_start_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION), 0)), 0)
838: where wo.wip_entity_id = p_wip_entity_id;
839:
840:
841: if (lbji_debug = 'Y') then

Line 1081: -- decode(p_status_type, WIP_CONSTANTS.UNRELEASED, NULL, SYSDATE), --Removed TRUNC for HH24MISS

1077: p_source_code,
1078: p_description,
1079: p_status_type,
1080: p_date_released,
1081: -- decode(p_status_type, WIP_CONSTANTS.UNRELEASED, NULL, SYSDATE), --Removed TRUNC for HH24MISS
1082: p_item,
1083: decode(p_job_type, 3,p_bom_reference_id, null),
1084: decode(p_job_type, 3, p_routing_reference_id, null),
1085: p_firm_planned_flag,

Line 1086: decode(p_job_type, 3, WIP_CONSTANTS.NONSTANDARD, WIP_CONSTANTS.STANDARD),

1082: p_item,
1083: decode(p_job_type, 3,p_bom_reference_id, null),
1084: decode(p_job_type, 3, p_routing_reference_id, null),
1085: p_firm_planned_flag,
1086: decode(p_job_type, 3, WIP_CONSTANTS.NONSTANDARD, WIP_CONSTANTS.STANDARD),
1087: p_wip_supply_type,
1088: p_class_code,
1089: l_material_account,
1090: l_material_overhead_account,

Line 1101: ROUND(p_start_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

1097: l_overhead_account,
1098: l_overhead_variance_account,
1099: TRUNC(p_fusd,'MI'), --round(p_fusd,'MI'),
1100: TRUNC(p_lucd,'MI'), --round(p_lucd,'MI'),
1101: ROUND(p_start_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
1102: 0,
1103: 0,
1104: ROUND(p_net_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
1105: p_common_bill_sequence_id,

Line 1104: ROUND(p_net_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

1100: TRUNC(p_lucd,'MI'), --round(p_lucd,'MI'),
1101: ROUND(p_start_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
1102: 0,
1103: 0,
1104: ROUND(p_net_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
1105: p_common_bill_sequence_id,
1106: l_common_routing_sequence_id,
1107: p_bom_revision,
1108: p_routing_revision,

Line 1247: if p_status_type = WIP_CONSTANTS.RELEASED then

1243:
1244:
1245: l_stmt_num := 140;
1246:
1247: if p_status_type = WIP_CONSTANTS.RELEASED then
1248: insert_into_period_balances (
1249: p_wip_entity_id => p_wip_entity_id,
1250: p_organization_id => p_org,
1251: p_class_code => p_class_code,

Line 1269: if p_status_type = 3 and p_po_creation_time <> wip_constants.manual_creation then

1265:
1266: -- osp begin -- this has to be put after insertion into wip_entities
1267: if p_explode_header_detail is null then
1268:
1269: if p_status_type = 3 and p_po_creation_time <> wip_constants.manual_creation then
1270: if p_src_client_server = 1 then
1271:
1272: if wsmputil.check_osp_operation(p_wip_entity_id, l_job_seq_num, p_org) then
1273: l_atleast_one_osp_exists := l_atleast_one_osp_exists + 1;

Line 1280: P_Run_ReqImport => WIP_CONSTANTS.YES);

1276: P_Organization_Id => p_org,
1277: P_Repetitive_Schedule_Id => null,
1278: P_Operation_Seq_Num => l_job_seq_num,
1279: P_Resource_Seq_Num => null,
1280: P_Run_ReqImport => WIP_CONSTANTS.YES);
1281: end if; -- check_osp_operation
1282: else
1283:
1284: -- if build_lbji_info is called from form, only then P_Run_ReqImport should be YES, i.e.

Line 1295: P_Run_ReqImport => WIP_CONSTANTS.NO);

1291: P_Organization_Id => p_org,
1292: P_Repetitive_Schedule_Id => null,
1293: P_Operation_Seq_Num => l_job_seq_num,
1294: P_Resource_Seq_Num => null,
1295: P_Run_ReqImport => WIP_CONSTANTS.NO);
1296: end if; -- check_osp_operation
1297:
1298: end if; -- p_src_client_server
1299: end if; -- p_status_type = 3

Line 1513: and wlji.process_status = 2 -- WIP_CONSTANTS.running

1509: wsm_lot_job_interface wlji,
1510: mtl_system_items msi
1511: where wsli.header_id = wlji.source_line_id
1512: and wlji.group_id = l_group_id
1513: and wlji.process_status = 2 -- WIP_CONSTANTS.running
1514: and wlji.mode_flag = 2
1515: and msi.inventory_item_id = wsli.inventory_item_id
1516: and msi.organization_id = wsli.organization_id;
1517:

Line 1699: l_start_date := to_char(p_fusd, WIP_CONSTANTS.DT_NOSEC_FMT);

1695:
1696: BEGIN
1697:
1698:
1699: l_start_date := to_char(p_fusd, WIP_CONSTANTS.DT_NOSEC_FMT);
1700: l_completion_date := to_char(p_lucd, WIP_CONSTANTS.DT_NOSEC_FMT);
1701: -- BC: BUG2754825
1702: --l_routing_rev_date := to_char(p_rtg_revision_date, WIP_CONSTANTS.DATETIME_FMT);
1703: l_routing_rev_date := p_rtg_revision_date;

Line 1700: l_completion_date := to_char(p_lucd, WIP_CONSTANTS.DT_NOSEC_FMT);

1696: BEGIN
1697:
1698:
1699: l_start_date := to_char(p_fusd, WIP_CONSTANTS.DT_NOSEC_FMT);
1700: l_completion_date := to_char(p_lucd, WIP_CONSTANTS.DT_NOSEC_FMT);
1701: -- BC: BUG2754825
1702: --l_routing_rev_date := to_char(p_rtg_revision_date, WIP_CONSTANTS.DATETIME_FMT);
1703: l_routing_rev_date := p_rtg_revision_date;
1704: -- EC: BUG2754825

Line 1702: --l_routing_rev_date := to_char(p_rtg_revision_date, WIP_CONSTANTS.DATETIME_FMT);

1698:
1699: l_start_date := to_char(p_fusd, WIP_CONSTANTS.DT_NOSEC_FMT);
1700: l_completion_date := to_char(p_lucd, WIP_CONSTANTS.DT_NOSEC_FMT);
1701: -- BC: BUG2754825
1702: --l_routing_rev_date := to_char(p_rtg_revision_date, WIP_CONSTANTS.DATETIME_FMT);
1703: l_routing_rev_date := p_rtg_revision_date;
1704: -- EC: BUG2754825
1705:
1706: if p_job_type = 3 then

Line 1818: ROUND(p_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

1814: --Bug 5510126:Scheduled quantity was made as 0 earlier as infinite
1815: --is going to finally update this.But before infinite scheduler is
1816: --called, create_requsitions is being called which uses the value
1817: --in the field scheduled quantity.Hence the previous change is reverted.
1818: ROUND(p_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
1819: --0,
1820: 0, 0, 0, 0, 0, 0,
1821: TO_DATE(l_start_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1822: TO_DATE(l_completion_date, WIP_CONSTANTS.DT_NOSEC_FMT),

Line 1821: TO_DATE(l_start_date, WIP_CONSTANTS.DT_NOSEC_FMT),

1817: --in the field scheduled quantity.Hence the previous change is reverted.
1818: ROUND(p_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
1819: --0,
1820: 0, 0, 0, 0, 0, 0,
1821: TO_DATE(l_start_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1822: TO_DATE(l_completion_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1823: TO_DATE(l_start_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1824: TO_DATE(l_completion_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1825: 0,

Line 1822: TO_DATE(l_completion_date, WIP_CONSTANTS.DT_NOSEC_FMT),

1818: ROUND(p_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
1819: --0,
1820: 0, 0, 0, 0, 0, 0,
1821: TO_DATE(l_start_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1822: TO_DATE(l_completion_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1823: TO_DATE(l_start_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1824: TO_DATE(l_completion_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1825: 0,
1826: 0,

Line 1823: TO_DATE(l_start_date, WIP_CONSTANTS.DT_NOSEC_FMT),

1819: --0,
1820: 0, 0, 0, 0, 0, 0,
1821: TO_DATE(l_start_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1822: TO_DATE(l_completion_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1823: TO_DATE(l_start_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1824: TO_DATE(l_completion_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1825: 0,
1826: 0,
1827: SEQ.COUNT_POINT_TYPE,

Line 1824: TO_DATE(l_completion_date, WIP_CONSTANTS.DT_NOSEC_FMT),

1820: 0, 0, 0, 0, 0, 0,
1821: TO_DATE(l_start_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1822: TO_DATE(l_completion_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1823: TO_DATE(l_start_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1824: TO_DATE(l_completion_date, WIP_CONSTANTS.DT_NOSEC_FMT),
1825: 0,
1826: 0,
1827: SEQ.COUNT_POINT_TYPE,
1828: SEQ.BACKFLUSH_FLAG,

Line 1854: AND TO_DATE(TO_CHAR(SEQ.EFFECTIVITY_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),

1850: WHERE SEQ.ROUTING_SEQUENCE_ID = p_common_routing_sequence_id
1851: AND NVL(SEQ.OPERATION_TYPE, 1) = 1
1852: --BC: CZH.I_OED-1
1853: /****************
1854: AND TO_DATE(TO_CHAR(SEQ.EFFECTIVITY_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),
1855: WIP_CONSTANTS.DT_NOSEC_FMT) <=
1856: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
1857: AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),
1858: WIP_CONSTANTS.DT_NOSEC_FMT),

Line 1855: WIP_CONSTANTS.DT_NOSEC_FMT) <=

1851: AND NVL(SEQ.OPERATION_TYPE, 1) = 1
1852: --BC: CZH.I_OED-1
1853: /****************
1854: AND TO_DATE(TO_CHAR(SEQ.EFFECTIVITY_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),
1855: WIP_CONSTANTS.DT_NOSEC_FMT) <=
1856: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
1857: AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),
1858: WIP_CONSTANTS.DT_NOSEC_FMT),
1859: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT) + 1) >=

Line 1856: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)

1852: --BC: CZH.I_OED-1
1853: /****************
1854: AND TO_DATE(TO_CHAR(SEQ.EFFECTIVITY_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),
1855: WIP_CONSTANTS.DT_NOSEC_FMT) <=
1856: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
1857: AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),
1858: WIP_CONSTANTS.DT_NOSEC_FMT),
1859: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT) + 1) >=
1860: TRUNC(TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))

Line 1857: AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),

1853: /****************
1854: AND TO_DATE(TO_CHAR(SEQ.EFFECTIVITY_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),
1855: WIP_CONSTANTS.DT_NOSEC_FMT) <=
1856: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
1857: AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),
1858: WIP_CONSTANTS.DT_NOSEC_FMT),
1859: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT) + 1) >=
1860: TRUNC(TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
1861: ****************/

Line 1858: WIP_CONSTANTS.DT_NOSEC_FMT),

1854: AND TO_DATE(TO_CHAR(SEQ.EFFECTIVITY_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),
1855: WIP_CONSTANTS.DT_NOSEC_FMT) <=
1856: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
1857: AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),
1858: WIP_CONSTANTS.DT_NOSEC_FMT),
1859: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT) + 1) >=
1860: TRUNC(TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
1861: ****************/
1862:

Line 1859: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT) + 1) >=

1855: WIP_CONSTANTS.DT_NOSEC_FMT) <=
1856: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
1857: AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),
1858: WIP_CONSTANTS.DT_NOSEC_FMT),
1859: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT) + 1) >=
1860: TRUNC(TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
1861: ****************/
1862:
1863: /** HH24MISSS - Timestamp FPI changes - DATETIME_FMT **/

Line 1860: TRUNC(TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))

1856: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
1857: AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DT_NOSEC_FMT),
1858: WIP_CONSTANTS.DT_NOSEC_FMT),
1859: TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT) + 1) >=
1860: TRUNC(TO_DATE(l_routing_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
1861: ****************/
1862:
1863: /** HH24MISSS - Timestamp FPI changes - DATETIME_FMT **/
1864:

Line 1866: --AND TO_DATE(TO_CHAR(SEQ.EFFECTIVITY_DATE, WIP_CONSTANTS.DATETIME_FMT), WIP_CONSTANTS.DATETIME_FMT)

1862:
1863: /** HH24MISSS - Timestamp FPI changes - DATETIME_FMT **/
1864:
1865: -- BC: BUG2754825
1866: --AND TO_DATE(TO_CHAR(SEQ.EFFECTIVITY_DATE, WIP_CONSTANTS.DATETIME_FMT), WIP_CONSTANTS.DATETIME_FMT)
1867: -- <= TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT)
1868: --AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DATETIME_FMT), WIP_CONSTANTS.DATETIME_FMT),
1869: -- TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT) + 1)
1870: -- >= TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT)

Line 1867: -- <= TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT)

1863: /** HH24MISSS - Timestamp FPI changes - DATETIME_FMT **/
1864:
1865: -- BC: BUG2754825
1866: --AND TO_DATE(TO_CHAR(SEQ.EFFECTIVITY_DATE, WIP_CONSTANTS.DATETIME_FMT), WIP_CONSTANTS.DATETIME_FMT)
1867: -- <= TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT)
1868: --AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DATETIME_FMT), WIP_CONSTANTS.DATETIME_FMT),
1869: -- TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT) + 1)
1870: -- >= TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT)
1871: AND l_routing_rev_date BETWEEN SEQ.EFFECTIVITY_DATE AND NVL(SEQ.DISABLE_DATE, l_routing_rev_date+1)

Line 1868: --AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DATETIME_FMT), WIP_CONSTANTS.DATETIME_FMT),

1864:
1865: -- BC: BUG2754825
1866: --AND TO_DATE(TO_CHAR(SEQ.EFFECTIVITY_DATE, WIP_CONSTANTS.DATETIME_FMT), WIP_CONSTANTS.DATETIME_FMT)
1867: -- <= TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT)
1868: --AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DATETIME_FMT), WIP_CONSTANTS.DATETIME_FMT),
1869: -- TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT) + 1)
1870: -- >= TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT)
1871: AND l_routing_rev_date BETWEEN SEQ.EFFECTIVITY_DATE AND NVL(SEQ.DISABLE_DATE, l_routing_rev_date+1)
1872: -- EC: BUG2754825

Line 1869: -- TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT) + 1)

1865: -- BC: BUG2754825
1866: --AND TO_DATE(TO_CHAR(SEQ.EFFECTIVITY_DATE, WIP_CONSTANTS.DATETIME_FMT), WIP_CONSTANTS.DATETIME_FMT)
1867: -- <= TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT)
1868: --AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DATETIME_FMT), WIP_CONSTANTS.DATETIME_FMT),
1869: -- TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT) + 1)
1870: -- >= TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT)
1871: AND l_routing_rev_date BETWEEN SEQ.EFFECTIVITY_DATE AND NVL(SEQ.DISABLE_DATE, l_routing_rev_date+1)
1872: -- EC: BUG2754825
1873:

Line 1870: -- >= TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT)

1866: --AND TO_DATE(TO_CHAR(SEQ.EFFECTIVITY_DATE, WIP_CONSTANTS.DATETIME_FMT), WIP_CONSTANTS.DATETIME_FMT)
1867: -- <= TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT)
1868: --AND NVL(TO_DATE(TO_CHAR(SEQ.DISABLE_DATE, WIP_CONSTANTS.DATETIME_FMT), WIP_CONSTANTS.DATETIME_FMT),
1869: -- TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT) + 1)
1870: -- >= TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT)
1871: AND l_routing_rev_date BETWEEN SEQ.EFFECTIVITY_DATE AND NVL(SEQ.DISABLE_DATE, l_routing_rev_date+1)
1872: -- EC: BUG2754825
1873:
1874: --EC: CZH.I_OED-1

Line 2044: --p_routing_revision_date => TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT),

2040: p_wip_supply_type => p_supply_type,
2041: x_err_code => l_error_code,
2042: x_err_msg => l_error_msg,
2043: --BC: 2754825
2044: --p_routing_revision_date => TO_DATE(l_routing_rev_date, WIP_CONSTANTS.DATETIME_FMT),
2045: p_routing_revision_date => l_routing_rev_date,
2046: --EC: 2754825
2047: p_routing_sequence_id => l_routing_seq_id); --bug 2445489
2048: -- EA: NSO-WLT

Line 2617: where process_status = wip_constants.pending

2613:
2614: cursor c_pir is
2615: select header_id
2616: from wsm_lot_job_interface
2617: where process_status = wip_constants.pending
2618: -- and group_id is null
2619: and creation_date <= sysdate+1
2620: and load_type in (5,6)
2621: order by job_name, organization_id; -- CZH: this will group the job together

Line 2654: where process_status = wip_constants.pending

2650:
2651: select count(*)
2652: into total_no_rows
2653: from wsm_lot_job_interface
2654: where process_status = wip_constants.pending
2655: --and group_id is null
2656: and creation_date <= sysdate+1
2657: and load_type in (5,6);
2658:

Line 2688: wlji.process_status = wip_constants.running

2684:
2685: if not c_pir%notfound then
2686: update wsm_lot_job_interface wlji
2687: set wlji.group_id = l_group_id,
2688: wlji.process_status = wip_constants.running
2689: where header_id = x_header;
2690: end if;
2691:
2692: if (c_pir%rowcount - row_count) = no_rows_per_worker or c_pir%notfound then

Line 2732: where process_status = wip_constants.pending

2728:
2729: select count(*)
2730: into total_no_rows
2731: from wsm_lot_job_interface
2732: where process_status = wip_constants.pending
2733: and group_id = p_group_id
2734: and creation_date <= sysdate+1
2735: and load_type in (5,6);
2736:

Line 2740: set wlji.process_status = wip_constants.running

2736:
2737: if total_no_rows > 0 then
2738:
2739: update wsm_lot_job_interface wlji
2740: set wlji.process_status = wip_constants.running
2741: where group_id = p_group_id;
2742:
2743: l_reqid := FND_REQUEST.SUBMIT_REQUEST (
2744: application => 'WSM',

Line 2900: and process_status = 2 -- WIP_CONSTANTS.running;

2896: job_type,
2897: date_released --bugfix 2697295
2898: from wsm_lot_job_interface
2899: where group_id = l_group_id
2900: and process_status = 2 -- WIP_CONSTANTS.running;
2901: order by organization_id,
2902: priority,
2903: due_date;
2904:

Line 3635: (WIP_CONSTANTS.UNRELEASED,

3631: end if;
3632:
3633: l_stmt_num := 181;
3634: if v_wlji_status_type(v_index) not in
3635: (WIP_CONSTANTS.UNRELEASED,
3636: WIP_CONSTANTS.RELEASED,
3637: WIP_CONSTANTS.HOLD,
3638: WIP_CONSTANTS.CANCELLED) then
3639: l_aux_mesg := '';

Line 3636: WIP_CONSTANTS.RELEASED,

3632:
3633: l_stmt_num := 181;
3634: if v_wlji_status_type(v_index) not in
3635: (WIP_CONSTANTS.UNRELEASED,
3636: WIP_CONSTANTS.RELEASED,
3637: WIP_CONSTANTS.HOLD,
3638: WIP_CONSTANTS.CANCELLED) then
3639: l_aux_mesg := '';
3640: process_invalid_field('STATUS TYPE',

Line 3637: WIP_CONSTANTS.HOLD,

3633: l_stmt_num := 181;
3634: if v_wlji_status_type(v_index) not in
3635: (WIP_CONSTANTS.UNRELEASED,
3636: WIP_CONSTANTS.RELEASED,
3637: WIP_CONSTANTS.HOLD,
3638: WIP_CONSTANTS.CANCELLED) then
3639: l_aux_mesg := '';
3640: process_invalid_field('STATUS TYPE',
3641: l_aux_mesg,

Line 3638: WIP_CONSTANTS.CANCELLED) then

3634: if v_wlji_status_type(v_index) not in
3635: (WIP_CONSTANTS.UNRELEASED,
3636: WIP_CONSTANTS.RELEASED,
3637: WIP_CONSTANTS.HOLD,
3638: WIP_CONSTANTS.CANCELLED) then
3639: l_aux_mesg := '';
3640: process_invalid_field('STATUS TYPE',
3641: l_aux_mesg,
3642: l_stmt_num);

Line 4468: WIP_CONSTANTS.UNRELEASED,

4464: where
4465: wip_entity_id = v_wlji_wip_entity_id(v_index) and
4466: organization_id = v_wlji_org(v_index) and
4467: status_type in (
4468: WIP_CONSTANTS.UNRELEASED,
4469: WIP_CONSTANTS.RELEASED,
4470: WIP_CONSTANTS.HOLD,
4471: WIP_CONSTANTS.CANCELLED)
4472: );

Line 4469: WIP_CONSTANTS.RELEASED,

4465: wip_entity_id = v_wlji_wip_entity_id(v_index) and
4466: organization_id = v_wlji_org(v_index) and
4467: status_type in (
4468: WIP_CONSTANTS.UNRELEASED,
4469: WIP_CONSTANTS.RELEASED,
4470: WIP_CONSTANTS.HOLD,
4471: WIP_CONSTANTS.CANCELLED)
4472: );
4473: */

Line 4470: WIP_CONSTANTS.HOLD,

4466: organization_id = v_wlji_org(v_index) and
4467: status_type in (
4468: WIP_CONSTANTS.UNRELEASED,
4469: WIP_CONSTANTS.RELEASED,
4470: WIP_CONSTANTS.HOLD,
4471: WIP_CONSTANTS.CANCELLED)
4472: );
4473: */
4474: -- added by BBK.

Line 4471: WIP_CONSTANTS.CANCELLED)

4467: status_type in (
4468: WIP_CONSTANTS.UNRELEASED,
4469: WIP_CONSTANTS.RELEASED,
4470: WIP_CONSTANTS.HOLD,
4471: WIP_CONSTANTS.CANCELLED)
4472: );
4473: */
4474: -- added by BBK.
4475: select 1 into l_dummy

Line 4480: WIP_CONSTANTS.UNRELEASED,

4476: from wip_discrete_jobs
4477: where
4478: wip_entity_id = v_wlji_wip_entity_id(v_index) and
4479: status_type in (
4480: WIP_CONSTANTS.UNRELEASED,
4481: WIP_CONSTANTS.RELEASED,
4482: WIP_CONSTANTS.HOLD,
4483: WIP_CONSTANTS.CANCELLED) ;
4484: exception

Line 4481: WIP_CONSTANTS.RELEASED,

4477: where
4478: wip_entity_id = v_wlji_wip_entity_id(v_index) and
4479: status_type in (
4480: WIP_CONSTANTS.UNRELEASED,
4481: WIP_CONSTANTS.RELEASED,
4482: WIP_CONSTANTS.HOLD,
4483: WIP_CONSTANTS.CANCELLED) ;
4484: exception
4485: -- This Exception added by BBK .

Line 4482: WIP_CONSTANTS.HOLD,

4478: wip_entity_id = v_wlji_wip_entity_id(v_index) and
4479: status_type in (
4480: WIP_CONSTANTS.UNRELEASED,
4481: WIP_CONSTANTS.RELEASED,
4482: WIP_CONSTANTS.HOLD,
4483: WIP_CONSTANTS.CANCELLED) ;
4484: exception
4485: -- This Exception added by BBK .
4486: when no_data_found then

Line 4483: WIP_CONSTANTS.CANCELLED) ;

4479: status_type in (
4480: WIP_CONSTANTS.UNRELEASED,
4481: WIP_CONSTANTS.RELEASED,
4482: WIP_CONSTANTS.HOLD,
4483: WIP_CONSTANTS.CANCELLED) ;
4484: exception
4485: -- This Exception added by BBK .
4486: when no_data_found then
4487: raise invalid_id_error;

Line 5256: if (v_wlji_status_type(v_index) = WIP_CONSTANTS.UNRELEASED) and (v_wlji_date_released(v_index) is not null ) then

5252:
5253: -- bugfix 2697295 begin
5254: l_stmt_num := 669;
5255: if v_wlji_load_type(v_index) = 5 then
5256: if (v_wlji_status_type(v_index) = WIP_CONSTANTS.UNRELEASED) and (v_wlji_date_released(v_index) is not null ) then
5257:
5258: v_wlji_date_released(v_index) := null;
5259:
5260: if lbji_debug = 'Y' then

Line 5263: elsif (v_wlji_status_type(v_index) = WIP_CONSTANTS.RELEASED ) then

5259:
5260: if lbji_debug = 'Y' then
5261: fnd_file.put_line(fnd_file.log, 'value for column DATE_RELEASED is being ignored for unreleased job');
5262: end if;
5263: elsif (v_wlji_status_type(v_index) = WIP_CONSTANTS.RELEASED ) then
5264: if (v_wlji_date_released(v_index) > sysdate ) then
5265:
5266: l_error_code := -1;
5267: process_errorred_field('WIP',

Line 6488: if WSMPLCVA.v_org(v_wlji_org(v_index)).PO_CREATION_TIME <> WIP_CONSTANTS.MANUAL_CREATION then

6484: -- 1. user updates only status from unreleased to released, quantity unchanged
6485: -- 2. user updates only quantity (increases) for a released job, status is unchanged
6486: -- 3. user updates staus to released, and increases quantity.
6487:
6488: if WSMPLCVA.v_org(v_wlji_org(v_index)).PO_CREATION_TIME <> WIP_CONSTANTS.MANUAL_CREATION then
6489:
6490: if (v_wlji_status_type(v_index) = 3 and p_old_status_type = 1) then
6491: if wsmputil.check_osp_operation(v_wlji_wip_entity_id(v_index), l_osp_op_seq_num , v_wlji_org(v_index)) then
6492: l_atleast_one_osp_exists := l_atleast_one_osp_exists + 1;

Line 6499: P_Run_ReqImport => WIP_CONSTANTS.NO);

6495: P_Organization_Id => v_wlji_org(v_index),
6496: P_Repetitive_Schedule_Id => null,
6497: P_Operation_Seq_Num => l_osp_op_seq_num,
6498: P_Resource_Seq_Num => null,
6499: P_Run_ReqImport => WIP_CONSTANTS.NO);
6500: end if; -- check_osp_operation
6501: end if;
6502:
6503: if (v_wlji_start_quantity(v_index) > p_old_quantity) AND v_wlji_status_type(v_index) = 3 then

Line 6512: end if; -- wip_constants.manual_creation

6508: P_Added_Quantity => (v_wlji_start_quantity(v_index) - p_old_quantity),
6509: P_Op_Seq => null);
6510: end if;
6511:
6512: end if; -- wip_constants.manual_creation
6513: -- osp end
6514:
6515:
6516: l_stmt_num := 721;

Line 6874: SCHEDULED_QUANTITY = ROUND(v_wlji_start_quantity(v_index), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

6870: LAST_UNIT_START_DATE),
6871: LAST_UNIT_COMPLETION_DATE = decode(l_txnexist,
6872: 0, NVL(v_wlji_lucd(v_index), LAST_UNIT_COMPLETION_DATE), -- bug 3394520
6873: LAST_UNIT_COMPLETION_DATE),
6874: SCHEDULED_QUANTITY = ROUND(v_wlji_start_quantity(v_index), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
6875: QUANTITY_IN_QUEUE = decode(v_wlji_status_type(v_index),
6876: 1, (decode(OPERATION_SEQ_NUM,10,0,QUANTITY_IN_QUEUE)),
6877: 3, (decode(p_old_status_type,
6878: 1, decode(OPERATION_SEQ_NUM,10,ROUND(v_wlji_start_quantity(v_index),

Line 6879: WIP_CONSTANTS.MAX_DISPLAYED_PRECISION), QUANTITY_IN_QUEUE),

6875: QUANTITY_IN_QUEUE = decode(v_wlji_status_type(v_index),
6876: 1, (decode(OPERATION_SEQ_NUM,10,0,QUANTITY_IN_QUEUE)),
6877: 3, (decode(p_old_status_type,
6878: 1, decode(OPERATION_SEQ_NUM,10,ROUND(v_wlji_start_quantity(v_index),
6879: WIP_CONSTANTS.MAX_DISPLAYED_PRECISION), QUANTITY_IN_QUEUE),
6880: decode(l_qntydiff,
6881: 1, decode(OPERATION_SEQ_NUM,
6882: 10,ROUND(v_wlji_start_quantity(v_index),WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
6883: QUANTITY_IN_QUEUE),

Line 6882: 10,ROUND(v_wlji_start_quantity(v_index),WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

6878: 1, decode(OPERATION_SEQ_NUM,10,ROUND(v_wlji_start_quantity(v_index),
6879: WIP_CONSTANTS.MAX_DISPLAYED_PRECISION), QUANTITY_IN_QUEUE),
6880: decode(l_qntydiff,
6881: 1, decode(OPERATION_SEQ_NUM,
6882: 10,ROUND(v_wlji_start_quantity(v_index),WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
6883: QUANTITY_IN_QUEUE),
6884: QUANTITY_IN_QUEUE))),
6885: QUANTITY_IN_QUEUE),
6886: LAST_UPDATED_BY = v_wlji_last_updt_by(v_index),

Line 7168: start_quantity = nvl(round(v_wlji_start_quantity(v_index), wip_constants.max_displayed_precision),

7164: routing_revision_date = v_wlji_routing_revision_date(v_index),
7165: alternate_bom_designator = v_wlji_alt_bom_designator(v_index),
7166: alternate_routing_designator = v_wlji_alt_routing_designator(v_index),
7167: firm_planned_flag = v_wlji_firm_planned_flag(v_index),
7168: start_quantity = nvl(round(v_wlji_start_quantity(v_index), wip_constants.max_displayed_precision),
7169: wdj.start_quantity),
7170: net_quantity = nvl(round(v_wlji_net_quantity(v_index), wip_constants.max_displayed_precision),
7171: wdj.net_quantity),
7172: status_type = nvl(v_wlji_status_type(v_index),wdj.status_type),

Line 7170: net_quantity = nvl(round(v_wlji_net_quantity(v_index), wip_constants.max_displayed_precision),

7166: alternate_routing_designator = v_wlji_alt_routing_designator(v_index),
7167: firm_planned_flag = v_wlji_firm_planned_flag(v_index),
7168: start_quantity = nvl(round(v_wlji_start_quantity(v_index), wip_constants.max_displayed_precision),
7169: wdj.start_quantity),
7170: net_quantity = nvl(round(v_wlji_net_quantity(v_index), wip_constants.max_displayed_precision),
7171: wdj.net_quantity),
7172: status_type = nvl(v_wlji_status_type(v_index),wdj.status_type),
7173: date_released = v_wlji_date_released(v_index), -- bug 2697295
7174: scheduled_start_date = decode(l_txnexist, 0,

Line 7250: v_wlji_status_type(v_index) = WIP_CONSTANTS.RELEASED and

7246: l_stmt_num := 1080;
7247:
7248: if (
7249: (v_wlji_load_type(v_index) = 6 AND
7250: v_wlji_status_type(v_index) = WIP_CONSTANTS.RELEASED and
7251: p_old_status_type = WIP_CONSTANTS.UNRELEASED)
7252: ) then
7253:
7254: if ((v_wlji_load_type(v_index) = 6) AND (v_wlji_class_code(v_index) is NULL)) then

Line 7251: p_old_status_type = WIP_CONSTANTS.UNRELEASED)

7247:
7248: if (
7249: (v_wlji_load_type(v_index) = 6 AND
7250: v_wlji_status_type(v_index) = WIP_CONSTANTS.RELEASED and
7251: p_old_status_type = WIP_CONSTANTS.UNRELEASED)
7252: ) then
7253:
7254: if ((v_wlji_load_type(v_index) = 6) AND (v_wlji_class_code(v_index) is NULL)) then
7255: v_wlji_class_code(v_index) := p_old_class_code;