48: TYPE Org_Params_Rec IS RECORD (
49: WMS_ORG VARCHAR2(1),
50: EXPRESS_PICK_FLAG VARCHAR2(1),
51: AUTO_PICK_CONFIRM VARCHAR2(1),
52: AUTODETAIL_FLAG WSH_SHIPPING_PARAMETERS.AUTODETAIL_PR_FLAG%TYPE,
53: AUTOCREATE_DELIVERIES WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
54: PICK_SEQ_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_SEQUENCE_RULE_ID%TYPE,
55: PICK_GROUPING_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_GROUPING_RULE_ID%TYPE,
56: AUTOPACK_LEVEL WSH_SHIPPING_PARAMETERS.AUTOPACK_LEVEL%TYPE,
49: WMS_ORG VARCHAR2(1),
50: EXPRESS_PICK_FLAG VARCHAR2(1),
51: AUTO_PICK_CONFIRM VARCHAR2(1),
52: AUTODETAIL_FLAG WSH_SHIPPING_PARAMETERS.AUTODETAIL_PR_FLAG%TYPE,
53: AUTOCREATE_DELIVERIES WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
54: PICK_SEQ_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_SEQUENCE_RULE_ID%TYPE,
55: PICK_GROUPING_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_GROUPING_RULE_ID%TYPE,
56: AUTOPACK_LEVEL WSH_SHIPPING_PARAMETERS.AUTOPACK_LEVEL%TYPE,
57: USE_HEADER_FLAG WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
50: EXPRESS_PICK_FLAG VARCHAR2(1),
51: AUTO_PICK_CONFIRM VARCHAR2(1),
52: AUTODETAIL_FLAG WSH_SHIPPING_PARAMETERS.AUTODETAIL_PR_FLAG%TYPE,
53: AUTOCREATE_DELIVERIES WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
54: PICK_SEQ_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_SEQUENCE_RULE_ID%TYPE,
55: PICK_GROUPING_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_GROUPING_RULE_ID%TYPE,
56: AUTOPACK_LEVEL WSH_SHIPPING_PARAMETERS.AUTOPACK_LEVEL%TYPE,
57: USE_HEADER_FLAG WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
58: AUTO_APPLY_ROUTING_RULES WSH_SHIPPING_PARAMETERS.AUTO_APPLY_ROUTING_RULES%TYPE,
51: AUTO_PICK_CONFIRM VARCHAR2(1),
52: AUTODETAIL_FLAG WSH_SHIPPING_PARAMETERS.AUTODETAIL_PR_FLAG%TYPE,
53: AUTOCREATE_DELIVERIES WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
54: PICK_SEQ_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_SEQUENCE_RULE_ID%TYPE,
55: PICK_GROUPING_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_GROUPING_RULE_ID%TYPE,
56: AUTOPACK_LEVEL WSH_SHIPPING_PARAMETERS.AUTOPACK_LEVEL%TYPE,
57: USE_HEADER_FLAG WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
58: AUTO_APPLY_ROUTING_RULES WSH_SHIPPING_PARAMETERS.AUTO_APPLY_ROUTING_RULES%TYPE,
59: AUTO_CALC_FGT_RATE_CR_DEL WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_CR_DEL%TYPE,
52: AUTODETAIL_FLAG WSH_SHIPPING_PARAMETERS.AUTODETAIL_PR_FLAG%TYPE,
53: AUTOCREATE_DELIVERIES WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
54: PICK_SEQ_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_SEQUENCE_RULE_ID%TYPE,
55: PICK_GROUPING_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_GROUPING_RULE_ID%TYPE,
56: AUTOPACK_LEVEL WSH_SHIPPING_PARAMETERS.AUTOPACK_LEVEL%TYPE,
57: USE_HEADER_FLAG WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
58: AUTO_APPLY_ROUTING_RULES WSH_SHIPPING_PARAMETERS.AUTO_APPLY_ROUTING_RULES%TYPE,
59: AUTO_CALC_FGT_RATE_CR_DEL WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_CR_DEL%TYPE,
60: TASK_PLANNING_FLAG WSH_SHIPPING_PARAMETERS.TASK_PLANNING_FLAG%TYPE,
53: AUTOCREATE_DELIVERIES WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
54: PICK_SEQ_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_SEQUENCE_RULE_ID%TYPE,
55: PICK_GROUPING_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_GROUPING_RULE_ID%TYPE,
56: AUTOPACK_LEVEL WSH_SHIPPING_PARAMETERS.AUTOPACK_LEVEL%TYPE,
57: USE_HEADER_FLAG WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
58: AUTO_APPLY_ROUTING_RULES WSH_SHIPPING_PARAMETERS.AUTO_APPLY_ROUTING_RULES%TYPE,
59: AUTO_CALC_FGT_RATE_CR_DEL WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_CR_DEL%TYPE,
60: TASK_PLANNING_FLAG WSH_SHIPPING_PARAMETERS.TASK_PLANNING_FLAG%TYPE,
61: PRINT_PICK_SLIP_MODE WSH_SHIPPING_PARAMETERS.PRINT_PICK_SLIP_MODE%TYPE,
54: PICK_SEQ_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_SEQUENCE_RULE_ID%TYPE,
55: PICK_GROUPING_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_GROUPING_RULE_ID%TYPE,
56: AUTOPACK_LEVEL WSH_SHIPPING_PARAMETERS.AUTOPACK_LEVEL%TYPE,
57: USE_HEADER_FLAG WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
58: AUTO_APPLY_ROUTING_RULES WSH_SHIPPING_PARAMETERS.AUTO_APPLY_ROUTING_RULES%TYPE,
59: AUTO_CALC_FGT_RATE_CR_DEL WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_CR_DEL%TYPE,
60: TASK_PLANNING_FLAG WSH_SHIPPING_PARAMETERS.TASK_PLANNING_FLAG%TYPE,
61: PRINT_PICK_SLIP_MODE WSH_SHIPPING_PARAMETERS.PRINT_PICK_SLIP_MODE%TYPE,
62: APPEND_FLAG WSH_SHIPPING_PARAMETERS.APPENDING_LIMIT%TYPE,
55: PICK_GROUPING_RULE_ID WSH_SHIPPING_PARAMETERS.PICK_GROUPING_RULE_ID%TYPE,
56: AUTOPACK_LEVEL WSH_SHIPPING_PARAMETERS.AUTOPACK_LEVEL%TYPE,
57: USE_HEADER_FLAG WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
58: AUTO_APPLY_ROUTING_RULES WSH_SHIPPING_PARAMETERS.AUTO_APPLY_ROUTING_RULES%TYPE,
59: AUTO_CALC_FGT_RATE_CR_DEL WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_CR_DEL%TYPE,
60: TASK_PLANNING_FLAG WSH_SHIPPING_PARAMETERS.TASK_PLANNING_FLAG%TYPE,
61: PRINT_PICK_SLIP_MODE WSH_SHIPPING_PARAMETERS.PRINT_PICK_SLIP_MODE%TYPE,
62: APPEND_FLAG WSH_SHIPPING_PARAMETERS.APPENDING_LIMIT%TYPE,
63: DOC_SET_ID WSH_SHIPPING_PARAMETERS.PICK_RELEASE_REPORT_SET_ID%TYPE,
56: AUTOPACK_LEVEL WSH_SHIPPING_PARAMETERS.AUTOPACK_LEVEL%TYPE,
57: USE_HEADER_FLAG WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
58: AUTO_APPLY_ROUTING_RULES WSH_SHIPPING_PARAMETERS.AUTO_APPLY_ROUTING_RULES%TYPE,
59: AUTO_CALC_FGT_RATE_CR_DEL WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_CR_DEL%TYPE,
60: TASK_PLANNING_FLAG WSH_SHIPPING_PARAMETERS.TASK_PLANNING_FLAG%TYPE,
61: PRINT_PICK_SLIP_MODE WSH_SHIPPING_PARAMETERS.PRINT_PICK_SLIP_MODE%TYPE,
62: APPEND_FLAG WSH_SHIPPING_PARAMETERS.APPENDING_LIMIT%TYPE,
63: DOC_SET_ID WSH_SHIPPING_PARAMETERS.PICK_RELEASE_REPORT_SET_ID%TYPE,
64: TO_SUBINVENTORY WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_SUBINVENTORY%TYPE,
57: USE_HEADER_FLAG WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
58: AUTO_APPLY_ROUTING_RULES WSH_SHIPPING_PARAMETERS.AUTO_APPLY_ROUTING_RULES%TYPE,
59: AUTO_CALC_FGT_RATE_CR_DEL WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_CR_DEL%TYPE,
60: TASK_PLANNING_FLAG WSH_SHIPPING_PARAMETERS.TASK_PLANNING_FLAG%TYPE,
61: PRINT_PICK_SLIP_MODE WSH_SHIPPING_PARAMETERS.PRINT_PICK_SLIP_MODE%TYPE,
62: APPEND_FLAG WSH_SHIPPING_PARAMETERS.APPENDING_LIMIT%TYPE,
63: DOC_SET_ID WSH_SHIPPING_PARAMETERS.PICK_RELEASE_REPORT_SET_ID%TYPE,
64: TO_SUBINVENTORY WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_SUBINVENTORY%TYPE,
65: TO_LOCATOR WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_LOCATOR_ID%TYPE,
58: AUTO_APPLY_ROUTING_RULES WSH_SHIPPING_PARAMETERS.AUTO_APPLY_ROUTING_RULES%TYPE,
59: AUTO_CALC_FGT_RATE_CR_DEL WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_CR_DEL%TYPE,
60: TASK_PLANNING_FLAG WSH_SHIPPING_PARAMETERS.TASK_PLANNING_FLAG%TYPE,
61: PRINT_PICK_SLIP_MODE WSH_SHIPPING_PARAMETERS.PRINT_PICK_SLIP_MODE%TYPE,
62: APPEND_FLAG WSH_SHIPPING_PARAMETERS.APPENDING_LIMIT%TYPE,
63: DOC_SET_ID WSH_SHIPPING_PARAMETERS.PICK_RELEASE_REPORT_SET_ID%TYPE,
64: TO_SUBINVENTORY WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_SUBINVENTORY%TYPE,
65: TO_LOCATOR WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_LOCATOR_ID%TYPE,
66: ENFORCE_SHIP_SET_AND_SMC WSH_SHIPPING_PARAMETERS.ENFORCE_SHIP_SET_AND_SMC%TYPE,
59: AUTO_CALC_FGT_RATE_CR_DEL WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_CR_DEL%TYPE,
60: TASK_PLANNING_FLAG WSH_SHIPPING_PARAMETERS.TASK_PLANNING_FLAG%TYPE,
61: PRINT_PICK_SLIP_MODE WSH_SHIPPING_PARAMETERS.PRINT_PICK_SLIP_MODE%TYPE,
62: APPEND_FLAG WSH_SHIPPING_PARAMETERS.APPENDING_LIMIT%TYPE,
63: DOC_SET_ID WSH_SHIPPING_PARAMETERS.PICK_RELEASE_REPORT_SET_ID%TYPE,
64: TO_SUBINVENTORY WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_SUBINVENTORY%TYPE,
65: TO_LOCATOR WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_LOCATOR_ID%TYPE,
66: ENFORCE_SHIP_SET_AND_SMC WSH_SHIPPING_PARAMETERS.ENFORCE_SHIP_SET_AND_SMC%TYPE,
67: DYNAMIC_REPLENISHMENT_FLAG WSH_SHIPPING_PARAMETERS.DYNAMIC_REPLENISHMENT_FLAG%TYPE --bug# 6689448 (replenishment project)
60: TASK_PLANNING_FLAG WSH_SHIPPING_PARAMETERS.TASK_PLANNING_FLAG%TYPE,
61: PRINT_PICK_SLIP_MODE WSH_SHIPPING_PARAMETERS.PRINT_PICK_SLIP_MODE%TYPE,
62: APPEND_FLAG WSH_SHIPPING_PARAMETERS.APPENDING_LIMIT%TYPE,
63: DOC_SET_ID WSH_SHIPPING_PARAMETERS.PICK_RELEASE_REPORT_SET_ID%TYPE,
64: TO_SUBINVENTORY WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_SUBINVENTORY%TYPE,
65: TO_LOCATOR WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_LOCATOR_ID%TYPE,
66: ENFORCE_SHIP_SET_AND_SMC WSH_SHIPPING_PARAMETERS.ENFORCE_SHIP_SET_AND_SMC%TYPE,
67: DYNAMIC_REPLENISHMENT_FLAG WSH_SHIPPING_PARAMETERS.DYNAMIC_REPLENISHMENT_FLAG%TYPE --bug# 6689448 (replenishment project)
68: );
61: PRINT_PICK_SLIP_MODE WSH_SHIPPING_PARAMETERS.PRINT_PICK_SLIP_MODE%TYPE,
62: APPEND_FLAG WSH_SHIPPING_PARAMETERS.APPENDING_LIMIT%TYPE,
63: DOC_SET_ID WSH_SHIPPING_PARAMETERS.PICK_RELEASE_REPORT_SET_ID%TYPE,
64: TO_SUBINVENTORY WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_SUBINVENTORY%TYPE,
65: TO_LOCATOR WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_LOCATOR_ID%TYPE,
66: ENFORCE_SHIP_SET_AND_SMC WSH_SHIPPING_PARAMETERS.ENFORCE_SHIP_SET_AND_SMC%TYPE,
67: DYNAMIC_REPLENISHMENT_FLAG WSH_SHIPPING_PARAMETERS.DYNAMIC_REPLENISHMENT_FLAG%TYPE --bug# 6689448 (replenishment project)
68: );
69:
62: APPEND_FLAG WSH_SHIPPING_PARAMETERS.APPENDING_LIMIT%TYPE,
63: DOC_SET_ID WSH_SHIPPING_PARAMETERS.PICK_RELEASE_REPORT_SET_ID%TYPE,
64: TO_SUBINVENTORY WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_SUBINVENTORY%TYPE,
65: TO_LOCATOR WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_LOCATOR_ID%TYPE,
66: ENFORCE_SHIP_SET_AND_SMC WSH_SHIPPING_PARAMETERS.ENFORCE_SHIP_SET_AND_SMC%TYPE,
67: DYNAMIC_REPLENISHMENT_FLAG WSH_SHIPPING_PARAMETERS.DYNAMIC_REPLENISHMENT_FLAG%TYPE --bug# 6689448 (replenishment project)
68: );
69:
70: TYPE Org_Params_Rec_Tbl IS TABLE OF Org_Params_Rec INDEX BY BINARY_INTEGER;
63: DOC_SET_ID WSH_SHIPPING_PARAMETERS.PICK_RELEASE_REPORT_SET_ID%TYPE,
64: TO_SUBINVENTORY WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_SUBINVENTORY%TYPE,
65: TO_LOCATOR WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_LOCATOR_ID%TYPE,
66: ENFORCE_SHIP_SET_AND_SMC WSH_SHIPPING_PARAMETERS.ENFORCE_SHIP_SET_AND_SMC%TYPE,
67: DYNAMIC_REPLENISHMENT_FLAG WSH_SHIPPING_PARAMETERS.DYNAMIC_REPLENISHMENT_FLAG%TYPE --bug# 6689448 (replenishment project)
68: );
69:
70: TYPE Org_Params_Rec_Tbl IS TABLE OF Org_Params_Rec INDEX BY BINARY_INTEGER;
71: