APPS.WSM_WIP_LOT_TXN_PVT dependencies on WSM_SM_STARTING_JOBS

Line 46: WIP_ENTITY_ID WSM_SM_STARTING_JOBS.WIP_ENTITY_ID%TYPE,

42:
43: type WLTX_STARTING_JOBS_REC_TYPE is record
44: (
45: /* Job header kinda.....*/
46: WIP_ENTITY_ID WSM_SM_STARTING_JOBS.WIP_ENTITY_ID%TYPE,
47: WIP_ENTITY_NAME WSM_SM_STARTING_JOBS.WIP_ENTITY_NAME%TYPE,
48: JOB_TYPE NUMBER,
49: STATUS_TYPE WIP_DISCRETE_JOBS.status_type%type,
50: DESCRIPTION WIP_ENTITIES.DESCRIPTION%type,

Line 47: WIP_ENTITY_NAME WSM_SM_STARTING_JOBS.WIP_ENTITY_NAME%TYPE,

43: type WLTX_STARTING_JOBS_REC_TYPE is record
44: (
45: /* Job header kinda.....*/
46: WIP_ENTITY_ID WSM_SM_STARTING_JOBS.WIP_ENTITY_ID%TYPE,
47: WIP_ENTITY_NAME WSM_SM_STARTING_JOBS.WIP_ENTITY_NAME%TYPE,
48: JOB_TYPE NUMBER,
49: STATUS_TYPE WIP_DISCRETE_JOBS.status_type%type,
50: DESCRIPTION WIP_ENTITIES.DESCRIPTION%type,
51: REPRESENTATIVE_FLAG WSM_SM_STARTING_JOBS.REPRESENTATIVE_FLAG%TYPE,

Line 51: REPRESENTATIVE_FLAG WSM_SM_STARTING_JOBS.REPRESENTATIVE_FLAG%TYPE,

47: WIP_ENTITY_NAME WSM_SM_STARTING_JOBS.WIP_ENTITY_NAME%TYPE,
48: JOB_TYPE NUMBER,
49: STATUS_TYPE WIP_DISCRETE_JOBS.status_type%type,
50: DESCRIPTION WIP_ENTITIES.DESCRIPTION%type,
51: REPRESENTATIVE_FLAG WSM_SM_STARTING_JOBS.REPRESENTATIVE_FLAG%TYPE,
52: SERIAL_TRACK_FLAG NUMBER, -- ST : Serial Support Project --
53:
54: /* Primary info....*/
55: CLASS_CODE WIP_DISCRETE_JOBS.CLASS_CODE%type,

Line 58: PRIMARY_ITEM_ID WSM_SM_STARTING_JOBS.PRIMARY_ITEM_ID%TYPE,

54: /* Primary info....*/
55: CLASS_CODE WIP_DISCRETE_JOBS.CLASS_CODE%type,
56: DEMAND_CLASS WIP_DISCRETE_JOBS.DEMAND_CLASS%type,
57: ORGANIZATION_CODE org_organization_definitions.ORGANIZATION_CODE%TYPE, /* Entry not in the base table */
58: PRIMARY_ITEM_ID WSM_SM_STARTING_JOBS.PRIMARY_ITEM_ID%TYPE,
59: ITEM_NAME VARCHAR2(850),--Removed reference to concatenated_segments as per bug#14683125
60: ORGANIZATION_ID WSM_SM_STARTING_JOBS.ORGANIZATION_ID%TYPE,
61:
62: /* Current operation infor....*/

Line 60: ORGANIZATION_ID WSM_SM_STARTING_JOBS.ORGANIZATION_ID%TYPE,

56: DEMAND_CLASS WIP_DISCRETE_JOBS.DEMAND_CLASS%type,
57: ORGANIZATION_CODE org_organization_definitions.ORGANIZATION_CODE%TYPE, /* Entry not in the base table */
58: PRIMARY_ITEM_ID WSM_SM_STARTING_JOBS.PRIMARY_ITEM_ID%TYPE,
59: ITEM_NAME VARCHAR2(850),--Removed reference to concatenated_segments as per bug#14683125
60: ORGANIZATION_ID WSM_SM_STARTING_JOBS.ORGANIZATION_ID%TYPE,
61:
62: /* Current operation infor....*/
63: INTRAOPERATION_STEP WSM_SM_STARTING_JOBS.INTRAOPERATION_STEP%TYPE,
64: OPERATION_SEQ_NUM WIP_OPERATIONS.OPERATION_SEQ_NUM%TYPE,

Line 63: INTRAOPERATION_STEP WSM_SM_STARTING_JOBS.INTRAOPERATION_STEP%TYPE,

59: ITEM_NAME VARCHAR2(850),--Removed reference to concatenated_segments as per bug#14683125
60: ORGANIZATION_ID WSM_SM_STARTING_JOBS.ORGANIZATION_ID%TYPE,
61:
62: /* Current operation infor....*/
63: INTRAOPERATION_STEP WSM_SM_STARTING_JOBS.INTRAOPERATION_STEP%TYPE,
64: OPERATION_SEQ_NUM WIP_OPERATIONS.OPERATION_SEQ_NUM%TYPE,
65: OPERATION_CODE BOM_STANDARD_OPERATIONS.OPERATION_CODE%TYPE,
66: OPERATION_DESCRIPTION BOM_OPERATION_SEQUENCES.OPERATION_DESCRIPTION%TYPE,
67: OPERATION_SEQ_ID WIP_OPERATIONS.OPERATION_SEQUENCE_ID%TYPE,

Line 69: DEPARTMENT_ID WSM_SM_STARTING_JOBS.DEPARTMENT_ID%TYPE,

65: OPERATION_CODE BOM_STANDARD_OPERATIONS.OPERATION_CODE%TYPE,
66: OPERATION_DESCRIPTION BOM_OPERATION_SEQUENCES.OPERATION_DESCRIPTION%TYPE,
67: OPERATION_SEQ_ID WIP_OPERATIONS.OPERATION_SEQUENCE_ID%TYPE,
68: STANDARD_OPERATION_ID WIP_OPERATIONS.STANDARD_OPERATION_ID%TYPE,
69: DEPARTMENT_ID WSM_SM_STARTING_JOBS.DEPARTMENT_ID%TYPE,
70: DEPARTMENT_CODE BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE,
71:
72: /* Quantity info */
73: START_QUANTITY WSM_SM_STARTING_JOBS.job_START_QUANTITY%TYPE,

Line 73: START_QUANTITY WSM_SM_STARTING_JOBS.job_START_QUANTITY%TYPE,

69: DEPARTMENT_ID WSM_SM_STARTING_JOBS.DEPARTMENT_ID%TYPE,
70: DEPARTMENT_CODE BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE,
71:
72: /* Quantity info */
73: START_QUANTITY WSM_SM_STARTING_JOBS.job_START_QUANTITY%TYPE,
74: QUANTITY_AVAILABLE WSM_SM_STARTING_JOBS.AVAILABLE_QUANTITY%TYPE,
75: NET_QUANTITY WSM_SM_STARTING_JOBS.NET_QUANTITY%TYPE,
76:
77: /* BOM and routing */

Line 74: QUANTITY_AVAILABLE WSM_SM_STARTING_JOBS.AVAILABLE_QUANTITY%TYPE,

70: DEPARTMENT_CODE BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE,
71:
72: /* Quantity info */
73: START_QUANTITY WSM_SM_STARTING_JOBS.job_START_QUANTITY%TYPE,
74: QUANTITY_AVAILABLE WSM_SM_STARTING_JOBS.AVAILABLE_QUANTITY%TYPE,
75: NET_QUANTITY WSM_SM_STARTING_JOBS.NET_QUANTITY%TYPE,
76:
77: /* BOM and routing */
78: ROUTING_REFERENCE_ID WSM_SM_STARTING_JOBS.ROUTING_REFERENCE_ID%TYPE,

Line 75: NET_QUANTITY WSM_SM_STARTING_JOBS.NET_QUANTITY%TYPE,

71:
72: /* Quantity info */
73: START_QUANTITY WSM_SM_STARTING_JOBS.job_START_QUANTITY%TYPE,
74: QUANTITY_AVAILABLE WSM_SM_STARTING_JOBS.AVAILABLE_QUANTITY%TYPE,
75: NET_QUANTITY WSM_SM_STARTING_JOBS.NET_QUANTITY%TYPE,
76:
77: /* BOM and routing */
78: ROUTING_REFERENCE_ID WSM_SM_STARTING_JOBS.ROUTING_REFERENCE_ID%TYPE,
79: BOM_REFERENCE_ID WSM_SM_STARTING_JOBS.BOM_REFERENCE_ID%TYPE,

Line 78: ROUTING_REFERENCE_ID WSM_SM_STARTING_JOBS.ROUTING_REFERENCE_ID%TYPE,

74: QUANTITY_AVAILABLE WSM_SM_STARTING_JOBS.AVAILABLE_QUANTITY%TYPE,
75: NET_QUANTITY WSM_SM_STARTING_JOBS.NET_QUANTITY%TYPE,
76:
77: /* BOM and routing */
78: ROUTING_REFERENCE_ID WSM_SM_STARTING_JOBS.ROUTING_REFERENCE_ID%TYPE,
79: BOM_REFERENCE_ID WSM_SM_STARTING_JOBS.BOM_REFERENCE_ID%TYPE,
80: COMMON_BILL_SEQUENCE_ID WSM_SM_STARTING_JOBS.BILL_SEQUENCE_ID%TYPE,
81: BOM_REVISION WSM_SM_STARTING_JOBS.BOM_REVISION%TYPE,
82: BOM_REVISION_DATE WSM_SM_STARTING_JOBS.BOM_REVISION_DATE%TYPE,

Line 79: BOM_REFERENCE_ID WSM_SM_STARTING_JOBS.BOM_REFERENCE_ID%TYPE,

75: NET_QUANTITY WSM_SM_STARTING_JOBS.NET_QUANTITY%TYPE,
76:
77: /* BOM and routing */
78: ROUTING_REFERENCE_ID WSM_SM_STARTING_JOBS.ROUTING_REFERENCE_ID%TYPE,
79: BOM_REFERENCE_ID WSM_SM_STARTING_JOBS.BOM_REFERENCE_ID%TYPE,
80: COMMON_BILL_SEQUENCE_ID WSM_SM_STARTING_JOBS.BILL_SEQUENCE_ID%TYPE,
81: BOM_REVISION WSM_SM_STARTING_JOBS.BOM_REVISION%TYPE,
82: BOM_REVISION_DATE WSM_SM_STARTING_JOBS.BOM_REVISION_DATE%TYPE,
83: ALTERNATE_BOM_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_BOM_DESIGNATOR%TYPE,

Line 80: COMMON_BILL_SEQUENCE_ID WSM_SM_STARTING_JOBS.BILL_SEQUENCE_ID%TYPE,

76:
77: /* BOM and routing */
78: ROUTING_REFERENCE_ID WSM_SM_STARTING_JOBS.ROUTING_REFERENCE_ID%TYPE,
79: BOM_REFERENCE_ID WSM_SM_STARTING_JOBS.BOM_REFERENCE_ID%TYPE,
80: COMMON_BILL_SEQUENCE_ID WSM_SM_STARTING_JOBS.BILL_SEQUENCE_ID%TYPE,
81: BOM_REVISION WSM_SM_STARTING_JOBS.BOM_REVISION%TYPE,
82: BOM_REVISION_DATE WSM_SM_STARTING_JOBS.BOM_REVISION_DATE%TYPE,
83: ALTERNATE_BOM_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_BOM_DESIGNATOR%TYPE,
84: ALTERNATE_ROUTING_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_ROUTING_DESIGNATOR%TYPE,

Line 81: BOM_REVISION WSM_SM_STARTING_JOBS.BOM_REVISION%TYPE,

77: /* BOM and routing */
78: ROUTING_REFERENCE_ID WSM_SM_STARTING_JOBS.ROUTING_REFERENCE_ID%TYPE,
79: BOM_REFERENCE_ID WSM_SM_STARTING_JOBS.BOM_REFERENCE_ID%TYPE,
80: COMMON_BILL_SEQUENCE_ID WSM_SM_STARTING_JOBS.BILL_SEQUENCE_ID%TYPE,
81: BOM_REVISION WSM_SM_STARTING_JOBS.BOM_REVISION%TYPE,
82: BOM_REVISION_DATE WSM_SM_STARTING_JOBS.BOM_REVISION_DATE%TYPE,
83: ALTERNATE_BOM_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_BOM_DESIGNATOR%TYPE,
84: ALTERNATE_ROUTING_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_ROUTING_DESIGNATOR%TYPE,
85: COMMON_ROUTING_SEQUENCE_ID WSM_SM_STARTING_JOBS.ROUTING_SEQ_ID%TYPE,

Line 82: BOM_REVISION_DATE WSM_SM_STARTING_JOBS.BOM_REVISION_DATE%TYPE,

78: ROUTING_REFERENCE_ID WSM_SM_STARTING_JOBS.ROUTING_REFERENCE_ID%TYPE,
79: BOM_REFERENCE_ID WSM_SM_STARTING_JOBS.BOM_REFERENCE_ID%TYPE,
80: COMMON_BILL_SEQUENCE_ID WSM_SM_STARTING_JOBS.BILL_SEQUENCE_ID%TYPE,
81: BOM_REVISION WSM_SM_STARTING_JOBS.BOM_REVISION%TYPE,
82: BOM_REVISION_DATE WSM_SM_STARTING_JOBS.BOM_REVISION_DATE%TYPE,
83: ALTERNATE_BOM_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_BOM_DESIGNATOR%TYPE,
84: ALTERNATE_ROUTING_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_ROUTING_DESIGNATOR%TYPE,
85: COMMON_ROUTING_SEQUENCE_ID WSM_SM_STARTING_JOBS.ROUTING_SEQ_ID%TYPE,
86: ROUTING_REVISION WSM_SM_STARTING_JOBS.ROUTING_REVISION%TYPE,

Line 85: COMMON_ROUTING_SEQUENCE_ID WSM_SM_STARTING_JOBS.ROUTING_SEQ_ID%TYPE,

81: BOM_REVISION WSM_SM_STARTING_JOBS.BOM_REVISION%TYPE,
82: BOM_REVISION_DATE WSM_SM_STARTING_JOBS.BOM_REVISION_DATE%TYPE,
83: ALTERNATE_BOM_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_BOM_DESIGNATOR%TYPE,
84: ALTERNATE_ROUTING_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_ROUTING_DESIGNATOR%TYPE,
85: COMMON_ROUTING_SEQUENCE_ID WSM_SM_STARTING_JOBS.ROUTING_SEQ_ID%TYPE,
86: ROUTING_REVISION WSM_SM_STARTING_JOBS.ROUTING_REVISION%TYPE,
87: ROUTING_REVISION_DATE WSM_SM_STARTING_JOBS.ROUTING_REVISION_DATE%TYPE,
88:
89: /* Completion subinv info.... */

Line 86: ROUTING_REVISION WSM_SM_STARTING_JOBS.ROUTING_REVISION%TYPE,

82: BOM_REVISION_DATE WSM_SM_STARTING_JOBS.BOM_REVISION_DATE%TYPE,
83: ALTERNATE_BOM_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_BOM_DESIGNATOR%TYPE,
84: ALTERNATE_ROUTING_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_ROUTING_DESIGNATOR%TYPE,
85: COMMON_ROUTING_SEQUENCE_ID WSM_SM_STARTING_JOBS.ROUTING_SEQ_ID%TYPE,
86: ROUTING_REVISION WSM_SM_STARTING_JOBS.ROUTING_REVISION%TYPE,
87: ROUTING_REVISION_DATE WSM_SM_STARTING_JOBS.ROUTING_REVISION_DATE%TYPE,
88:
89: /* Completion subinv info.... */
90: COMPLETION_SUBINVENTORY WSM_SM_STARTING_JOBS.COMPLETION_SUBINVENTORY%TYPE,

Line 87: ROUTING_REVISION_DATE WSM_SM_STARTING_JOBS.ROUTING_REVISION_DATE%TYPE,

83: ALTERNATE_BOM_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_BOM_DESIGNATOR%TYPE,
84: ALTERNATE_ROUTING_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_ROUTING_DESIGNATOR%TYPE,
85: COMMON_ROUTING_SEQUENCE_ID WSM_SM_STARTING_JOBS.ROUTING_SEQ_ID%TYPE,
86: ROUTING_REVISION WSM_SM_STARTING_JOBS.ROUTING_REVISION%TYPE,
87: ROUTING_REVISION_DATE WSM_SM_STARTING_JOBS.ROUTING_REVISION_DATE%TYPE,
88:
89: /* Completion subinv info.... */
90: COMPLETION_SUBINVENTORY WSM_SM_STARTING_JOBS.COMPLETION_SUBINVENTORY%TYPE,
91: COMPLETION_LOCATOR_ID WSM_SM_STARTING_JOBS.COMPLETION_LOCATOR_ID%TYPE,

Line 90: COMPLETION_SUBINVENTORY WSM_SM_STARTING_JOBS.COMPLETION_SUBINVENTORY%TYPE,

86: ROUTING_REVISION WSM_SM_STARTING_JOBS.ROUTING_REVISION%TYPE,
87: ROUTING_REVISION_DATE WSM_SM_STARTING_JOBS.ROUTING_REVISION_DATE%TYPE,
88:
89: /* Completion subinv info.... */
90: COMPLETION_SUBINVENTORY WSM_SM_STARTING_JOBS.COMPLETION_SUBINVENTORY%TYPE,
91: COMPLETION_LOCATOR_ID WSM_SM_STARTING_JOBS.COMPLETION_LOCATOR_ID%TYPE,
92: COMPLETION_LOCATOR mtl_item_locations_kfv.concatenated_segments%TYPE,
93:
94: /* Dates info... */

Line 91: COMPLETION_LOCATOR_ID WSM_SM_STARTING_JOBS.COMPLETION_LOCATOR_ID%TYPE,

87: ROUTING_REVISION_DATE WSM_SM_STARTING_JOBS.ROUTING_REVISION_DATE%TYPE,
88:
89: /* Completion subinv info.... */
90: COMPLETION_SUBINVENTORY WSM_SM_STARTING_JOBS.COMPLETION_SUBINVENTORY%TYPE,
91: COMPLETION_LOCATOR_ID WSM_SM_STARTING_JOBS.COMPLETION_LOCATOR_ID%TYPE,
92: COMPLETION_LOCATOR mtl_item_locations_kfv.concatenated_segments%TYPE,
93:
94: /* Dates info... */
95: DATE_RELEASED WIP_DISCRETE_JOBS.DATE_RELEASED%TYPE,

Line 96: SCHEDULED_START_DATE WSM_SM_STARTING_JOBS.SCHEDULED_START_DATE%TYPE,

92: COMPLETION_LOCATOR mtl_item_locations_kfv.concatenated_segments%TYPE,
93:
94: /* Dates info... */
95: DATE_RELEASED WIP_DISCRETE_JOBS.DATE_RELEASED%TYPE,
96: SCHEDULED_START_DATE WSM_SM_STARTING_JOBS.SCHEDULED_START_DATE%TYPE,
97: SCHEDULED_COMPLETION_DATE WSM_SM_STARTING_JOBS.SCHEDULED_COMPLETION_DATE%TYPE,
98:
99: /* Parameters.... */
100: COPRODUCTS_SUPPLY WSM_SM_STARTING_JOBS.COPRODUCTS_SUPPLY%TYPE,

Line 97: SCHEDULED_COMPLETION_DATE WSM_SM_STARTING_JOBS.SCHEDULED_COMPLETION_DATE%TYPE,

93:
94: /* Dates info... */
95: DATE_RELEASED WIP_DISCRETE_JOBS.DATE_RELEASED%TYPE,
96: SCHEDULED_START_DATE WSM_SM_STARTING_JOBS.SCHEDULED_START_DATE%TYPE,
97: SCHEDULED_COMPLETION_DATE WSM_SM_STARTING_JOBS.SCHEDULED_COMPLETION_DATE%TYPE,
98:
99: /* Parameters.... */
100: COPRODUCTS_SUPPLY WSM_SM_STARTING_JOBS.COPRODUCTS_SUPPLY%TYPE,
101: KANBAN_CARD_ID WIP_DISCRETE_JOBS.KANBAN_CARD_ID%TYPE,

Line 100: COPRODUCTS_SUPPLY WSM_SM_STARTING_JOBS.COPRODUCTS_SUPPLY%TYPE,

96: SCHEDULED_START_DATE WSM_SM_STARTING_JOBS.SCHEDULED_START_DATE%TYPE,
97: SCHEDULED_COMPLETION_DATE WSM_SM_STARTING_JOBS.SCHEDULED_COMPLETION_DATE%TYPE,
98:
99: /* Parameters.... */
100: COPRODUCTS_SUPPLY WSM_SM_STARTING_JOBS.COPRODUCTS_SUPPLY%TYPE,
101: KANBAN_CARD_ID WIP_DISCRETE_JOBS.KANBAN_CARD_ID%TYPE,
102: WIP_SUPPLY_TYPE WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPE%TYPE,
103: /* add wip_supply type..... */
104:

Line 105: ATTRIBUTE_CATEGORY WSM_SM_STARTING_JOBS.ATTRIBUTE_CATEGORY%TYPE,

101: KANBAN_CARD_ID WIP_DISCRETE_JOBS.KANBAN_CARD_ID%TYPE,
102: WIP_SUPPLY_TYPE WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPE%TYPE,
103: /* add wip_supply type..... */
104:
105: ATTRIBUTE_CATEGORY WSM_SM_STARTING_JOBS.ATTRIBUTE_CATEGORY%TYPE,
106: ATTRIBUTE1 WSM_SM_STARTING_JOBS.ATTRIBUTE1%TYPE,
107: ATTRIBUTE2 WSM_SM_STARTING_JOBS.ATTRIBUTE2%TYPE,
108: ATTRIBUTE3 WSM_SM_STARTING_JOBS.ATTRIBUTE3%TYPE,
109: ATTRIBUTE4 WSM_SM_STARTING_JOBS.ATTRIBUTE4%TYPE,

Line 106: ATTRIBUTE1 WSM_SM_STARTING_JOBS.ATTRIBUTE1%TYPE,

102: WIP_SUPPLY_TYPE WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPE%TYPE,
103: /* add wip_supply type..... */
104:
105: ATTRIBUTE_CATEGORY WSM_SM_STARTING_JOBS.ATTRIBUTE_CATEGORY%TYPE,
106: ATTRIBUTE1 WSM_SM_STARTING_JOBS.ATTRIBUTE1%TYPE,
107: ATTRIBUTE2 WSM_SM_STARTING_JOBS.ATTRIBUTE2%TYPE,
108: ATTRIBUTE3 WSM_SM_STARTING_JOBS.ATTRIBUTE3%TYPE,
109: ATTRIBUTE4 WSM_SM_STARTING_JOBS.ATTRIBUTE4%TYPE,
110: ATTRIBUTE5 WSM_SM_STARTING_JOBS.ATTRIBUTE5%TYPE,

Line 107: ATTRIBUTE2 WSM_SM_STARTING_JOBS.ATTRIBUTE2%TYPE,

103: /* add wip_supply type..... */
104:
105: ATTRIBUTE_CATEGORY WSM_SM_STARTING_JOBS.ATTRIBUTE_CATEGORY%TYPE,
106: ATTRIBUTE1 WSM_SM_STARTING_JOBS.ATTRIBUTE1%TYPE,
107: ATTRIBUTE2 WSM_SM_STARTING_JOBS.ATTRIBUTE2%TYPE,
108: ATTRIBUTE3 WSM_SM_STARTING_JOBS.ATTRIBUTE3%TYPE,
109: ATTRIBUTE4 WSM_SM_STARTING_JOBS.ATTRIBUTE4%TYPE,
110: ATTRIBUTE5 WSM_SM_STARTING_JOBS.ATTRIBUTE5%TYPE,
111: ATTRIBUTE6 WSM_SM_STARTING_JOBS.ATTRIBUTE6%TYPE,

Line 108: ATTRIBUTE3 WSM_SM_STARTING_JOBS.ATTRIBUTE3%TYPE,

104:
105: ATTRIBUTE_CATEGORY WSM_SM_STARTING_JOBS.ATTRIBUTE_CATEGORY%TYPE,
106: ATTRIBUTE1 WSM_SM_STARTING_JOBS.ATTRIBUTE1%TYPE,
107: ATTRIBUTE2 WSM_SM_STARTING_JOBS.ATTRIBUTE2%TYPE,
108: ATTRIBUTE3 WSM_SM_STARTING_JOBS.ATTRIBUTE3%TYPE,
109: ATTRIBUTE4 WSM_SM_STARTING_JOBS.ATTRIBUTE4%TYPE,
110: ATTRIBUTE5 WSM_SM_STARTING_JOBS.ATTRIBUTE5%TYPE,
111: ATTRIBUTE6 WSM_SM_STARTING_JOBS.ATTRIBUTE6%TYPE,
112: ATTRIBUTE7 WSM_SM_STARTING_JOBS.ATTRIBUTE7%TYPE,

Line 109: ATTRIBUTE4 WSM_SM_STARTING_JOBS.ATTRIBUTE4%TYPE,

105: ATTRIBUTE_CATEGORY WSM_SM_STARTING_JOBS.ATTRIBUTE_CATEGORY%TYPE,
106: ATTRIBUTE1 WSM_SM_STARTING_JOBS.ATTRIBUTE1%TYPE,
107: ATTRIBUTE2 WSM_SM_STARTING_JOBS.ATTRIBUTE2%TYPE,
108: ATTRIBUTE3 WSM_SM_STARTING_JOBS.ATTRIBUTE3%TYPE,
109: ATTRIBUTE4 WSM_SM_STARTING_JOBS.ATTRIBUTE4%TYPE,
110: ATTRIBUTE5 WSM_SM_STARTING_JOBS.ATTRIBUTE5%TYPE,
111: ATTRIBUTE6 WSM_SM_STARTING_JOBS.ATTRIBUTE6%TYPE,
112: ATTRIBUTE7 WSM_SM_STARTING_JOBS.ATTRIBUTE7%TYPE,
113: ATTRIBUTE8 WSM_SM_STARTING_JOBS.ATTRIBUTE8%TYPE,

Line 110: ATTRIBUTE5 WSM_SM_STARTING_JOBS.ATTRIBUTE5%TYPE,

106: ATTRIBUTE1 WSM_SM_STARTING_JOBS.ATTRIBUTE1%TYPE,
107: ATTRIBUTE2 WSM_SM_STARTING_JOBS.ATTRIBUTE2%TYPE,
108: ATTRIBUTE3 WSM_SM_STARTING_JOBS.ATTRIBUTE3%TYPE,
109: ATTRIBUTE4 WSM_SM_STARTING_JOBS.ATTRIBUTE4%TYPE,
110: ATTRIBUTE5 WSM_SM_STARTING_JOBS.ATTRIBUTE5%TYPE,
111: ATTRIBUTE6 WSM_SM_STARTING_JOBS.ATTRIBUTE6%TYPE,
112: ATTRIBUTE7 WSM_SM_STARTING_JOBS.ATTRIBUTE7%TYPE,
113: ATTRIBUTE8 WSM_SM_STARTING_JOBS.ATTRIBUTE8%TYPE,
114: ATTRIBUTE9 WSM_SM_STARTING_JOBS.ATTRIBUTE9%TYPE,

Line 111: ATTRIBUTE6 WSM_SM_STARTING_JOBS.ATTRIBUTE6%TYPE,

107: ATTRIBUTE2 WSM_SM_STARTING_JOBS.ATTRIBUTE2%TYPE,
108: ATTRIBUTE3 WSM_SM_STARTING_JOBS.ATTRIBUTE3%TYPE,
109: ATTRIBUTE4 WSM_SM_STARTING_JOBS.ATTRIBUTE4%TYPE,
110: ATTRIBUTE5 WSM_SM_STARTING_JOBS.ATTRIBUTE5%TYPE,
111: ATTRIBUTE6 WSM_SM_STARTING_JOBS.ATTRIBUTE6%TYPE,
112: ATTRIBUTE7 WSM_SM_STARTING_JOBS.ATTRIBUTE7%TYPE,
113: ATTRIBUTE8 WSM_SM_STARTING_JOBS.ATTRIBUTE8%TYPE,
114: ATTRIBUTE9 WSM_SM_STARTING_JOBS.ATTRIBUTE9%TYPE,
115: ATTRIBUTE10 WSM_SM_STARTING_JOBS.ATTRIBUTE10%TYPE,

Line 112: ATTRIBUTE7 WSM_SM_STARTING_JOBS.ATTRIBUTE7%TYPE,

108: ATTRIBUTE3 WSM_SM_STARTING_JOBS.ATTRIBUTE3%TYPE,
109: ATTRIBUTE4 WSM_SM_STARTING_JOBS.ATTRIBUTE4%TYPE,
110: ATTRIBUTE5 WSM_SM_STARTING_JOBS.ATTRIBUTE5%TYPE,
111: ATTRIBUTE6 WSM_SM_STARTING_JOBS.ATTRIBUTE6%TYPE,
112: ATTRIBUTE7 WSM_SM_STARTING_JOBS.ATTRIBUTE7%TYPE,
113: ATTRIBUTE8 WSM_SM_STARTING_JOBS.ATTRIBUTE8%TYPE,
114: ATTRIBUTE9 WSM_SM_STARTING_JOBS.ATTRIBUTE9%TYPE,
115: ATTRIBUTE10 WSM_SM_STARTING_JOBS.ATTRIBUTE10%TYPE,
116: ATTRIBUTE11 WSM_SM_STARTING_JOBS.ATTRIBUTE11%TYPE,

Line 113: ATTRIBUTE8 WSM_SM_STARTING_JOBS.ATTRIBUTE8%TYPE,

109: ATTRIBUTE4 WSM_SM_STARTING_JOBS.ATTRIBUTE4%TYPE,
110: ATTRIBUTE5 WSM_SM_STARTING_JOBS.ATTRIBUTE5%TYPE,
111: ATTRIBUTE6 WSM_SM_STARTING_JOBS.ATTRIBUTE6%TYPE,
112: ATTRIBUTE7 WSM_SM_STARTING_JOBS.ATTRIBUTE7%TYPE,
113: ATTRIBUTE8 WSM_SM_STARTING_JOBS.ATTRIBUTE8%TYPE,
114: ATTRIBUTE9 WSM_SM_STARTING_JOBS.ATTRIBUTE9%TYPE,
115: ATTRIBUTE10 WSM_SM_STARTING_JOBS.ATTRIBUTE10%TYPE,
116: ATTRIBUTE11 WSM_SM_STARTING_JOBS.ATTRIBUTE11%TYPE,
117: ATTRIBUTE12 WSM_SM_STARTING_JOBS.ATTRIBUTE12%TYPE,

Line 114: ATTRIBUTE9 WSM_SM_STARTING_JOBS.ATTRIBUTE9%TYPE,

110: ATTRIBUTE5 WSM_SM_STARTING_JOBS.ATTRIBUTE5%TYPE,
111: ATTRIBUTE6 WSM_SM_STARTING_JOBS.ATTRIBUTE6%TYPE,
112: ATTRIBUTE7 WSM_SM_STARTING_JOBS.ATTRIBUTE7%TYPE,
113: ATTRIBUTE8 WSM_SM_STARTING_JOBS.ATTRIBUTE8%TYPE,
114: ATTRIBUTE9 WSM_SM_STARTING_JOBS.ATTRIBUTE9%TYPE,
115: ATTRIBUTE10 WSM_SM_STARTING_JOBS.ATTRIBUTE10%TYPE,
116: ATTRIBUTE11 WSM_SM_STARTING_JOBS.ATTRIBUTE11%TYPE,
117: ATTRIBUTE12 WSM_SM_STARTING_JOBS.ATTRIBUTE12%TYPE,
118: ATTRIBUTE13 WSM_SM_STARTING_JOBS.ATTRIBUTE13%TYPE,

Line 115: ATTRIBUTE10 WSM_SM_STARTING_JOBS.ATTRIBUTE10%TYPE,

111: ATTRIBUTE6 WSM_SM_STARTING_JOBS.ATTRIBUTE6%TYPE,
112: ATTRIBUTE7 WSM_SM_STARTING_JOBS.ATTRIBUTE7%TYPE,
113: ATTRIBUTE8 WSM_SM_STARTING_JOBS.ATTRIBUTE8%TYPE,
114: ATTRIBUTE9 WSM_SM_STARTING_JOBS.ATTRIBUTE9%TYPE,
115: ATTRIBUTE10 WSM_SM_STARTING_JOBS.ATTRIBUTE10%TYPE,
116: ATTRIBUTE11 WSM_SM_STARTING_JOBS.ATTRIBUTE11%TYPE,
117: ATTRIBUTE12 WSM_SM_STARTING_JOBS.ATTRIBUTE12%TYPE,
118: ATTRIBUTE13 WSM_SM_STARTING_JOBS.ATTRIBUTE13%TYPE,
119: ATTRIBUTE14 WSM_SM_STARTING_JOBS.ATTRIBUTE14%TYPE,

Line 116: ATTRIBUTE11 WSM_SM_STARTING_JOBS.ATTRIBUTE11%TYPE,

112: ATTRIBUTE7 WSM_SM_STARTING_JOBS.ATTRIBUTE7%TYPE,
113: ATTRIBUTE8 WSM_SM_STARTING_JOBS.ATTRIBUTE8%TYPE,
114: ATTRIBUTE9 WSM_SM_STARTING_JOBS.ATTRIBUTE9%TYPE,
115: ATTRIBUTE10 WSM_SM_STARTING_JOBS.ATTRIBUTE10%TYPE,
116: ATTRIBUTE11 WSM_SM_STARTING_JOBS.ATTRIBUTE11%TYPE,
117: ATTRIBUTE12 WSM_SM_STARTING_JOBS.ATTRIBUTE12%TYPE,
118: ATTRIBUTE13 WSM_SM_STARTING_JOBS.ATTRIBUTE13%TYPE,
119: ATTRIBUTE14 WSM_SM_STARTING_JOBS.ATTRIBUTE14%TYPE,
120: ATTRIBUTE15 WSM_SM_STARTING_JOBS.ATTRIBUTE15%TYPE

Line 117: ATTRIBUTE12 WSM_SM_STARTING_JOBS.ATTRIBUTE12%TYPE,

113: ATTRIBUTE8 WSM_SM_STARTING_JOBS.ATTRIBUTE8%TYPE,
114: ATTRIBUTE9 WSM_SM_STARTING_JOBS.ATTRIBUTE9%TYPE,
115: ATTRIBUTE10 WSM_SM_STARTING_JOBS.ATTRIBUTE10%TYPE,
116: ATTRIBUTE11 WSM_SM_STARTING_JOBS.ATTRIBUTE11%TYPE,
117: ATTRIBUTE12 WSM_SM_STARTING_JOBS.ATTRIBUTE12%TYPE,
118: ATTRIBUTE13 WSM_SM_STARTING_JOBS.ATTRIBUTE13%TYPE,
119: ATTRIBUTE14 WSM_SM_STARTING_JOBS.ATTRIBUTE14%TYPE,
120: ATTRIBUTE15 WSM_SM_STARTING_JOBS.ATTRIBUTE15%TYPE
121:

Line 118: ATTRIBUTE13 WSM_SM_STARTING_JOBS.ATTRIBUTE13%TYPE,

114: ATTRIBUTE9 WSM_SM_STARTING_JOBS.ATTRIBUTE9%TYPE,
115: ATTRIBUTE10 WSM_SM_STARTING_JOBS.ATTRIBUTE10%TYPE,
116: ATTRIBUTE11 WSM_SM_STARTING_JOBS.ATTRIBUTE11%TYPE,
117: ATTRIBUTE12 WSM_SM_STARTING_JOBS.ATTRIBUTE12%TYPE,
118: ATTRIBUTE13 WSM_SM_STARTING_JOBS.ATTRIBUTE13%TYPE,
119: ATTRIBUTE14 WSM_SM_STARTING_JOBS.ATTRIBUTE14%TYPE,
120: ATTRIBUTE15 WSM_SM_STARTING_JOBS.ATTRIBUTE15%TYPE
121:
122: );

Line 119: ATTRIBUTE14 WSM_SM_STARTING_JOBS.ATTRIBUTE14%TYPE,

115: ATTRIBUTE10 WSM_SM_STARTING_JOBS.ATTRIBUTE10%TYPE,
116: ATTRIBUTE11 WSM_SM_STARTING_JOBS.ATTRIBUTE11%TYPE,
117: ATTRIBUTE12 WSM_SM_STARTING_JOBS.ATTRIBUTE12%TYPE,
118: ATTRIBUTE13 WSM_SM_STARTING_JOBS.ATTRIBUTE13%TYPE,
119: ATTRIBUTE14 WSM_SM_STARTING_JOBS.ATTRIBUTE14%TYPE,
120: ATTRIBUTE15 WSM_SM_STARTING_JOBS.ATTRIBUTE15%TYPE
121:
122: );
123:

Line 120: ATTRIBUTE15 WSM_SM_STARTING_JOBS.ATTRIBUTE15%TYPE

116: ATTRIBUTE11 WSM_SM_STARTING_JOBS.ATTRIBUTE11%TYPE,
117: ATTRIBUTE12 WSM_SM_STARTING_JOBS.ATTRIBUTE12%TYPE,
118: ATTRIBUTE13 WSM_SM_STARTING_JOBS.ATTRIBUTE13%TYPE,
119: ATTRIBUTE14 WSM_SM_STARTING_JOBS.ATTRIBUTE14%TYPE,
120: ATTRIBUTE15 WSM_SM_STARTING_JOBS.ATTRIBUTE15%TYPE
121:
122: );
123:
124:

Line 209: REQUEST_ID WSM_SM_STARTING_JOBS.REQUEST_ID%TYPE,

205: ATTRIBUTE15 WSM_SM_RESULTING_JOBS.ATTRIBUTE15%TYPE --,
206:
207: /* Request ID and other WHO columns will be obtained from the header record for every txn
208:
209: REQUEST_ID WSM_SM_STARTING_JOBS.REQUEST_ID%TYPE,
210: PROGRAM_APPLICATION_ID WSM_SM_STARTING_JOBS.PROGRAM_APPLICATION_ID%TYPE,
211: PROGRAM_ID WSM_SM_STARTING_JOBS.PROGRAM_ID%TYPE,
212: PROGRAM_UPDATE_DATE WSM_SM_STARTING_JOBS.PROGRAM_UPDATE_DATE%TYPE,
213:

Line 210: PROGRAM_APPLICATION_ID WSM_SM_STARTING_JOBS.PROGRAM_APPLICATION_ID%TYPE,

206:
207: /* Request ID and other WHO columns will be obtained from the header record for every txn
208:
209: REQUEST_ID WSM_SM_STARTING_JOBS.REQUEST_ID%TYPE,
210: PROGRAM_APPLICATION_ID WSM_SM_STARTING_JOBS.PROGRAM_APPLICATION_ID%TYPE,
211: PROGRAM_ID WSM_SM_STARTING_JOBS.PROGRAM_ID%TYPE,
212: PROGRAM_UPDATE_DATE WSM_SM_STARTING_JOBS.PROGRAM_UPDATE_DATE%TYPE,
213:
214:

Line 211: PROGRAM_ID WSM_SM_STARTING_JOBS.PROGRAM_ID%TYPE,

207: /* Request ID and other WHO columns will be obtained from the header record for every txn
208:
209: REQUEST_ID WSM_SM_STARTING_JOBS.REQUEST_ID%TYPE,
210: PROGRAM_APPLICATION_ID WSM_SM_STARTING_JOBS.PROGRAM_APPLICATION_ID%TYPE,
211: PROGRAM_ID WSM_SM_STARTING_JOBS.PROGRAM_ID%TYPE,
212: PROGRAM_UPDATE_DATE WSM_SM_STARTING_JOBS.PROGRAM_UPDATE_DATE%TYPE,
213:
214:
215: LAST_UPDATE_DATE WSM_SM_STARTING_JOBS.LAST_UPDATE_DATE%TYPE,

Line 212: PROGRAM_UPDATE_DATE WSM_SM_STARTING_JOBS.PROGRAM_UPDATE_DATE%TYPE,

208:
209: REQUEST_ID WSM_SM_STARTING_JOBS.REQUEST_ID%TYPE,
210: PROGRAM_APPLICATION_ID WSM_SM_STARTING_JOBS.PROGRAM_APPLICATION_ID%TYPE,
211: PROGRAM_ID WSM_SM_STARTING_JOBS.PROGRAM_ID%TYPE,
212: PROGRAM_UPDATE_DATE WSM_SM_STARTING_JOBS.PROGRAM_UPDATE_DATE%TYPE,
213:
214:
215: LAST_UPDATE_DATE WSM_SM_STARTING_JOBS.LAST_UPDATE_DATE%TYPE,
216: LAST_UPDATED_BY WSM_SM_STARTING_JOBS.LAST_UPDATED_BY%TYPE,

Line 215: LAST_UPDATE_DATE WSM_SM_STARTING_JOBS.LAST_UPDATE_DATE%TYPE,

211: PROGRAM_ID WSM_SM_STARTING_JOBS.PROGRAM_ID%TYPE,
212: PROGRAM_UPDATE_DATE WSM_SM_STARTING_JOBS.PROGRAM_UPDATE_DATE%TYPE,
213:
214:
215: LAST_UPDATE_DATE WSM_SM_STARTING_JOBS.LAST_UPDATE_DATE%TYPE,
216: LAST_UPDATED_BY WSM_SM_STARTING_JOBS.LAST_UPDATED_BY%TYPE,
217: CREATION_DATE WSM_SM_STARTING_JOBS.CREATION_DATE%TYPE,
218: CREATED_BY WSM_SM_STARTING_JOBS.CREATED_BY%TYPE,
219: LAST_UPDATE_LOGIN WSM_SM_STARTING_JOBS.LAST_UPDATE_LOGIN%TYPE */

Line 216: LAST_UPDATED_BY WSM_SM_STARTING_JOBS.LAST_UPDATED_BY%TYPE,

212: PROGRAM_UPDATE_DATE WSM_SM_STARTING_JOBS.PROGRAM_UPDATE_DATE%TYPE,
213:
214:
215: LAST_UPDATE_DATE WSM_SM_STARTING_JOBS.LAST_UPDATE_DATE%TYPE,
216: LAST_UPDATED_BY WSM_SM_STARTING_JOBS.LAST_UPDATED_BY%TYPE,
217: CREATION_DATE WSM_SM_STARTING_JOBS.CREATION_DATE%TYPE,
218: CREATED_BY WSM_SM_STARTING_JOBS.CREATED_BY%TYPE,
219: LAST_UPDATE_LOGIN WSM_SM_STARTING_JOBS.LAST_UPDATE_LOGIN%TYPE */
220:

Line 217: CREATION_DATE WSM_SM_STARTING_JOBS.CREATION_DATE%TYPE,

213:
214:
215: LAST_UPDATE_DATE WSM_SM_STARTING_JOBS.LAST_UPDATE_DATE%TYPE,
216: LAST_UPDATED_BY WSM_SM_STARTING_JOBS.LAST_UPDATED_BY%TYPE,
217: CREATION_DATE WSM_SM_STARTING_JOBS.CREATION_DATE%TYPE,
218: CREATED_BY WSM_SM_STARTING_JOBS.CREATED_BY%TYPE,
219: LAST_UPDATE_LOGIN WSM_SM_STARTING_JOBS.LAST_UPDATE_LOGIN%TYPE */
220:
221: );

Line 218: CREATED_BY WSM_SM_STARTING_JOBS.CREATED_BY%TYPE,

214:
215: LAST_UPDATE_DATE WSM_SM_STARTING_JOBS.LAST_UPDATE_DATE%TYPE,
216: LAST_UPDATED_BY WSM_SM_STARTING_JOBS.LAST_UPDATED_BY%TYPE,
217: CREATION_DATE WSM_SM_STARTING_JOBS.CREATION_DATE%TYPE,
218: CREATED_BY WSM_SM_STARTING_JOBS.CREATED_BY%TYPE,
219: LAST_UPDATE_LOGIN WSM_SM_STARTING_JOBS.LAST_UPDATE_LOGIN%TYPE */
220:
221: );
222:

Line 219: LAST_UPDATE_LOGIN WSM_SM_STARTING_JOBS.LAST_UPDATE_LOGIN%TYPE */

215: LAST_UPDATE_DATE WSM_SM_STARTING_JOBS.LAST_UPDATE_DATE%TYPE,
216: LAST_UPDATED_BY WSM_SM_STARTING_JOBS.LAST_UPDATED_BY%TYPE,
217: CREATION_DATE WSM_SM_STARTING_JOBS.CREATION_DATE%TYPE,
218: CREATED_BY WSM_SM_STARTING_JOBS.CREATED_BY%TYPE,
219: LAST_UPDATE_LOGIN WSM_SM_STARTING_JOBS.LAST_UPDATE_LOGIN%TYPE */
220:
221: );
222:
223: