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 WSMPLCVA

Line 3096: WSMPLCVA.load_org_table;

3092:
3093: begin
3094:
3095: l_stmt_num := 1;
3096: WSMPLCVA.load_org_table;
3097:
3098: l_stmt_num := 2;
3099: WSMPLCVA.load_subinventory;
3100:

Line 3099: WSMPLCVA.load_subinventory;

3095: l_stmt_num := 1;
3096: WSMPLCVA.load_org_table;
3097:
3098: l_stmt_num := 2;
3099: WSMPLCVA.load_subinventory;
3100:
3101: l_stmt_num := 3;
3102: WSMPLCVA.load_class_code;
3103:

Line 3102: WSMPLCVA.load_class_code;

3098: l_stmt_num := 2;
3099: WSMPLCVA.load_subinventory;
3100:
3101: l_stmt_num := 3;
3102: WSMPLCVA.load_class_code;
3103:
3104: if lbji_debug = 'Y' then
3105: fnd_file.put_line(fnd_file.log, 'loading org/subinv/class-code values into memory (once per worker).. Success.');
3106: end if;

Line 3493: xst := WSMPLCVA.v_org.exists(v_wlji_org(v_index));

3489:
3490:
3491: l_stmt_num := 100;
3492: -- *** validate org id begin ***
3493: xst := WSMPLCVA.v_org.exists(v_wlji_org(v_index));
3494: if xst = false then
3495: l_error_code := -1;
3496: process_invalid_field('ORGANIZATION ID',
3497: '',

Line 3780: xst := WSMPLCVA.v_item.exists(v_wlji_item(v_index));

3776: -- CZH: why only for standard job ???
3777: if v_wlji_load_type(v_index) = 5 and v_wlji_job_type(v_index) <> 3 then
3778:
3779: if v_wlji_mode_flag(v_index) = 1 then
3780: xst := WSMPLCVA.v_item.exists(v_wlji_item(v_index));
3781: else -- mode flag 2
3782: str := to_char(v_wlji_item(v_index))||
3783: to_char(v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id);
3784: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);

Line 3786: xst := WSMPLCVA.v_mode2_item.exists(hash_value)

3782: str := to_char(v_wlji_item(v_index))||
3783: to_char(v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id);
3784: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
3785:
3786: xst := WSMPLCVA.v_mode2_item.exists(hash_value)
3787: AND WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID =
3788: v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
3789: AND WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID = v_wlji_item(v_index);
3790: end if;

Line 3787: AND WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID =

3783: to_char(v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id);
3784: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
3785:
3786: xst := WSMPLCVA.v_mode2_item.exists(hash_value)
3787: AND WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID =
3788: v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
3789: AND WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID = v_wlji_item(v_index);
3790: end if;
3791:

Line 3789: AND WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID = v_wlji_item(v_index);

3785:
3786: xst := WSMPLCVA.v_mode2_item.exists(hash_value)
3787: AND WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID =
3788: v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
3789: AND WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID = v_wlji_item(v_index);
3790: end if;
3791:
3792: if xst = false then
3793:

Line 3833: WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID :=

3829: end if; -- xst = false
3830:
3831: if xst = false AND l_no_of_records <> 0 then
3832: if v_wlji_mode_flag(v_index) = 2 then
3833: WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID :=
3834: v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id;
3835: WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID :=
3836: v_wlji_item(v_index);
3837: else -- mode flag = 1

Line 3835: WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID :=

3831: if xst = false AND l_no_of_records <> 0 then
3832: if v_wlji_mode_flag(v_index) = 2 then
3833: WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID :=
3834: v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id;
3835: WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID :=
3836: v_wlji_item(v_index);
3837: else -- mode flag = 1
3838: WSMPLCVA.v_item(v_wlji_item(v_index)) := v_wlji_item(v_index);
3839: end if;

Line 3838: WSMPLCVA.v_item(v_wlji_item(v_index)) := v_wlji_item(v_index);

3834: v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id;
3835: WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID :=
3836: v_wlji_item(v_index);
3837: else -- mode flag = 1
3838: WSMPLCVA.v_item(v_wlji_item(v_index)) := v_wlji_item(v_index);
3839: end if;
3840: end if;
3841:
3842: if l_error_code <> 0 then

Line 3984: WSMPLCVA.v_org(v_wlji_org(v_index)).COPRODUCTS_SUPPLY_DEFAULT;

3980: if v_wlji_load_type(v_index) = 5 then
3981:
3982: IF v_wlji_coproducts_supply(v_index) is NULL THEN
3983: v_wlji_coproducts_supply(v_index) :=
3984: WSMPLCVA.v_org(v_wlji_org(v_index)).COPRODUCTS_SUPPLY_DEFAULT;
3985: ELSIF ( v_wlji_coproducts_supply(v_index) <> 1
3986: OR v_wlji_coproducts_supply(v_index) <> 2) THEN
3987: v_wlji_coproducts_supply(v_index) := 2;
3988: END IF;

Line 4069: if WSMPLCVA.v_subinv.exists(hash_value) then

4065: -- do the subinventory validation here...
4066: -- validation of subinv begin
4067: str := to_char(v_wlji_org(v_index))||v_wlji_completion_subinventory(v_index);
4068: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
4069: if WSMPLCVA.v_subinv.exists(hash_value) then
4070: NULL;
4071: else
4072: l_aux_mesg := '';
4073: process_invalid_field('COMPLETION SUBINVENTORY',

Line 4247: xst := WSMPLCVA.v_user.exists(v_wlji_last_updt_by(v_index));

4243:
4244: if v_wlji_last_updt_by(v_index) is NULL then
4245: v_wlji_last_updt_by(v_index) := l_user;
4246: else
4247: xst := WSMPLCVA.v_user.exists(v_wlji_last_updt_by(v_index));
4248: if xst = false then
4249: begin
4250: select 1
4251: into l_no_of_records

Line 4267: WSMPLCVA.v_user(v_wlji_last_updt_by(v_index)) := v_wlji_last_updt_by(v_index);

4263: end;
4264: end if;
4265:
4266: if xst = false AND l_no_of_records <> 0 then
4267: WSMPLCVA.v_user(v_wlji_last_updt_by(v_index)) := v_wlji_last_updt_by(v_index);
4268: end if;
4269:
4270:
4271: if l_error_code <> 0 then

Line 4295: xst := WSMPLCVA.v_user.exists(v_wlji_created_by(v_index));

4291:
4292: if v_wlji_created_by(v_index) is NULL then
4293: v_wlji_created_by(v_index) := l_user;
4294: else
4295: xst := WSMPLCVA.v_user.exists(v_wlji_created_by(v_index));
4296: if xst = false then
4297: begin
4298: select 1
4299: into l_no_of_records

Line 4313: WSMPLCVA.v_user(v_wlji_created_by(v_index)) := v_wlji_created_by(v_index);

4309: end;
4310: end if;
4311:
4312: if xst = false AND l_no_of_records <> 0 then
4313: WSMPLCVA.v_user(v_wlji_created_by(v_index)) := v_wlji_created_by(v_index);
4314: end if;
4315:
4316: if l_error_code <> 0 then
4317: l_error_count := l_error_count + 1;

Line 4565: v_wlji_class_code(v_index) := WSMPLCVA.v_org(v_wlji_org(v_index)).DEFAULT_ACCT_CLASS_CODE;

4561: v_wlji_class_code(v_index) := NULL;
4562: end;
4563:
4564: IF v_wlji_class_code(v_index) is NULL then
4565: v_wlji_class_code(v_index) := WSMPLCVA.v_org(v_wlji_org(v_index)).DEFAULT_ACCT_CLASS_CODE;
4566: END IF;
4567:
4568: END IF;
4569:

Line 4577: if WSMPLCVA.v_class_code.exists(hash_value) then

4573:
4574: ELSE
4575: str := to_char(v_wlji_org(v_index))||v_wlji_class_code(v_index);
4576: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
4577: if WSMPLCVA.v_class_code.exists(hash_value) then
4578: NULL;
4579: else
4580: raise no_data_found;
4581: end if;

Line 4715: xst := WSMPLCVA.v_user.exists(v_wsli(v_wlji_source_line_id(v_index)).last_updated_by);

4711: --EA bug 3299026
4712:
4713: -- *** last_updated_by ***
4714: l_stmt_num := 601;
4715: xst := WSMPLCVA.v_user.exists(v_wsli(v_wlji_source_line_id(v_index)).last_updated_by);
4716: if xst = false then
4717: begin
4718: select 1
4719: into l_no_of_records

Line 4735: WSMPLCVA.v_user(v_wsli(v_wlji_source_line_id(v_index)).last_updated_by)

4731: end;
4732: end if;
4733:
4734: if xst = false AND l_no_of_records <> 0 then
4735: WSMPLCVA.v_user(v_wsli(v_wlji_source_line_id(v_index)).last_updated_by)
4736: := v_wsli(v_wlji_source_line_id(v_index)).last_updated_by;
4737: end if;
4738:
4739: if l_error_code <> 0 then

Line 4749: xst := WSMPLCVA.v_user.exists(v_wsli(v_wlji_source_line_id(v_index)).created_by);

4745: xst := true;
4746:
4747: -- *** created_by ***
4748: l_stmt_num := 602;
4749: xst := WSMPLCVA.v_user.exists(v_wsli(v_wlji_source_line_id(v_index)).created_by);
4750: if xst = false then
4751: begin
4752: select 1
4753: into l_no_of_records

Line 4769: WSMPLCVA.v_user(v_wsli(v_wlji_source_line_id(v_index)).created_by)

4765: end;
4766: end if;
4767:
4768: if xst = false AND l_no_of_records <> 0 then
4769: WSMPLCVA.v_user(v_wsli(v_wlji_source_line_id(v_index)).created_by)
4770: := v_wsli(v_wlji_source_line_id(v_index)).created_by;
4771: end if;
4772:
4773: if l_error_code <> 0 then

Line 5649: if WSMPLCVA.v_subinv.exists(hash_value) then

5645: v_wlji_completion_locator_id(v_index) IS NULL THEN
5646:
5647: str := to_char(v_wlji_org(v_index))||v_wlji_completion_subinventory(v_index);
5648: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
5649: if WSMPLCVA.v_subinv.exists(hash_value) then
5650: NULL;
5651: else
5652: l_aux_mesg := '';
5653: process_invalid_field('COMPLETION SUBINVENTORY',

Line 6180: p_po_creation_time => WSMPLCVA.v_org(v_wlji_org(v_index)).PO_CREATION_TIME,

6176: p_overcompl_tol_value => null,
6177: p_end_item_unit_number => null,
6178: p_rtg_op_seq_num => null,
6179: p_src_client_server => 0,
6180: p_po_creation_time => WSMPLCVA.v_org(v_wlji_org(v_index)).PO_CREATION_TIME,
6181: p_error_code => l_error_code,
6182: p_error_msg => l_error_msg);
6183:
6184: if l_error_code <> 0 then

Line 6399: -- WSMPLCVA.v_org(v_wlji_org(v_index)).ESTIMATED_SCRAP_ACCOUNTING = 1

6395:
6396: l_stmt_num := 712;
6397: -- abb H: optional scrap accounting
6398: -- if (p_old_status_type IN (1,6)) and (v_wlji_status_type(v_index) = 3) and
6399: -- WSMPLCVA.v_org(v_wlji_org(v_index)).ESTIMATED_SCRAP_ACCOUNTING = 1
6400: -- and p_old_job_type = 1 then
6401:
6402: if (p_old_status_type IN (1,6)) and (v_wlji_status_type(v_index) = 3) and
6403: wsmputil.WSM_ESA_ENABLED(p_wip_entity_id => v_wlji_wip_entity_id(v_index),

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 6820: p_po_creation_time => WSMPLCVA.v_org(v_wlji_org(v_index)).PO_CREATION_TIME,

6816: p_overcompl_tol_value => v_wlji_overcompl_tol_value(v_index),
6817: p_end_item_unit_number => v_wlji_end_item_unit_number(v_index),
6818: p_rtg_op_seq_num => null,
6819: p_src_client_server => 0,
6820: p_po_creation_time => WSMPLCVA.v_org(v_wlji_org(v_index)).PO_CREATION_TIME,
6821: p_date_released => v_wlji_date_released(v_index),
6822: p_error_code => l_error_code,
6823: p_error_msg => l_error_msg);
6824:

Line 7284: IF WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_ORG_ACC_PERIODS is null or

7280: l_stmt_num := 1100;
7281: -- *** material transaction for mode 2 jobs begin ***
7282: if v_wlji_mode_flag(v_index) = 2 then
7283:
7284: IF WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_ORG_ACC_PERIODS is null or
7285: WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_ORG_ACC_PERIODS = 0
7286: then
7287: l_error_code := -1;
7288: process_errorred_field('WIP',

Line 7285: WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_ORG_ACC_PERIODS = 0

7281: -- *** material transaction for mode 2 jobs begin ***
7282: if v_wlji_mode_flag(v_index) = 2 then
7283:
7284: IF WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_ORG_ACC_PERIODS is null or
7285: WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_ORG_ACC_PERIODS = 0
7286: then
7287: l_error_code := -1;
7288: process_errorred_field('WIP',
7289: 'WIP_NO_ACCT_PERIOD',

Line 7294: if WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_STK_LOC_CNTRL is null then

7290: l_stmt_num);
7291: GOTO skip_mat_trans;
7292: end if;
7293:
7294: if WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_STK_LOC_CNTRL is null then
7295: WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_STK_LOC_CNTRL := 1;
7296: end if;
7297:
7298: l_stmt_num := 1120;

Line 7295: WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_STK_LOC_CNTRL := 1;

7291: GOTO skip_mat_trans;
7292: end if;
7293:
7294: if WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_STK_LOC_CNTRL is null then
7295: WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_STK_LOC_CNTRL := 1;
7296: end if;
7297:
7298: l_stmt_num := 1120;
7299: /* commented out by BBK for DUAL usage reduction.

Line 7361: WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_ORG_ACC_PERIODS, /ACCT_PERIOD_ID /

7357: 35, /* TRANSACTION_TYPE_ID */
7358: 1, /* TRANSACTION_ACTION_ID */
7359: 5, /* TRANSACTION_SOURCE_TYPE_ID */
7360: SYSDATE, /* TRANSACTION_DATE */
7361: WSMPLCVA.v_org(v_wlji_org(v_index)).MAX_ORG_ACC_PERIODS, /*ACCT_PERIOD_ID */
7362: 'WSM',
7363: to_char(v_wlji_source_line_id(v_index)), /* SOURCE_LINE_ID */
7364: 5, /* WIP_ENTITY_TYPE */
7365: 1, /* neg req flag */