DBA Data[Home] [Help]

APPS.WSMPLCVA dependencies on WSM_LOT_JOB_INTERFACE

Line 39: type t_item IS table of wsm_lot_job_interface.primary_item_id%type

35: -- ===============================================================================================
36: -- creating an index by table that'll store the valid item values as the index for easy validation
37: -- ===============================================================================================
38:
39: type t_item IS table of wsm_lot_job_interface.primary_item_id%type
40: index by binary_integer;
41: v_item t_item;
42:
43: -- ===============================================================================================

Line 48: PRIMARY_ITEM_ID wsm_lot_job_interface.PRIMARY_ITEM_ID%type);

44: -- creating an index by table that'll store hash (assembly + component) item values as the index
45: -- ===============================================================================================
46:
47: type rec_item IS record(INVENTORY_ITEM_ID wsm_starting_lots_interface.INVENTORY_ITEM_ID%type,
48: PRIMARY_ITEM_ID wsm_lot_job_interface.PRIMARY_ITEM_ID%type);
49:
50: type t_mode2_item IS table of rec_item index by binary_integer;
51:
52: v_mode2_item t_mode2_item;

Line 58: type t_class_code IS table of wsm_lot_job_interface.class_code%type

54: -- ===============================================================================================
55: -- creating an index by table that'll store the valid class codes as the index for easy validation
56: -- ===============================================================================================
57:
58: type t_class_code IS table of wsm_lot_job_interface.class_code%type
59: index by binary_integer;
60: v_class_code t_class_code;
61:
62: -- ===============================================================================================

Line 66: type t_user IS table of wsm_lot_job_interface.last_updated_by%type

62: -- ===============================================================================================
63: -- creating an index by table that'll store the valid user id's as the index for easy validation
64: -- ===============================================================================================
65:
66: type t_user IS table of wsm_lot_job_interface.last_updated_by%type
67: index by binary_integer;
68: v_user t_user;
69:
70: