DBA Data[Home] [Help]

APPS.CSL_REQUIREMENTS_PKG dependencies on CSP_PARTS_REQUIREMENT

Line 51: l_header_rec CSP_PARTS_REQUIREMENT.HEADER_REC_TYPE;

47: p_error_msg OUT NOCOPY VARCHAR2,
48: x_return_status IN OUT NOCOPY VARCHAR2
49: ) IS
50:
51: l_header_rec CSP_PARTS_REQUIREMENT.HEADER_REC_TYPE;
52: l_line_rec CSP_PARTS_REQUIREMENT.LINE_REC_TYPE;
53: l_line_table CSP_PARTS_REQUIREMENT.LINE_TBL_TYPE;
54:
55: l_s_org_id NUMBER := 207;

Line 52: l_line_rec CSP_PARTS_REQUIREMENT.LINE_REC_TYPE;

48: x_return_status IN OUT NOCOPY VARCHAR2
49: ) IS
50:
51: l_header_rec CSP_PARTS_REQUIREMENT.HEADER_REC_TYPE;
52: l_line_rec CSP_PARTS_REQUIREMENT.LINE_REC_TYPE;
53: l_line_table CSP_PARTS_REQUIREMENT.LINE_TBL_TYPE;
54:
55: l_s_org_id NUMBER := 207;
56: l_d_org_id NUMBER := 204;

Line 53: l_line_table CSP_PARTS_REQUIREMENT.LINE_TBL_TYPE;

49: ) IS
50:
51: l_header_rec CSP_PARTS_REQUIREMENT.HEADER_REC_TYPE;
52: l_line_rec CSP_PARTS_REQUIREMENT.LINE_REC_TYPE;
53: l_line_table CSP_PARTS_REQUIREMENT.LINE_TBL_TYPE;
54:
55: l_s_org_id NUMBER := 207;
56: l_d_org_id NUMBER := 204;
57: l_item_id NUMBER := 155;

Line 106: l_header_rec.OPERATION := CSP_PARTS_REQUIREMENT.G_OPR_CREATE;

102: l_header_rec.SHIP_TO_LOCATION_ID := r_get_requirement_from_inq.SHIP_TO_LOCATION_ID;
103: l_header_rec.NEED_BY_DATE := r_get_requirement_from_inq.NEED_BY_DATE;
104: l_header_rec.DEST_ORGANIZATION_ID := r_get_requirement_from_inq.DESTINATION_ORGANIZATION_ID;
105: l_header_rec.DEST_SUBINVENTORY := r_get_requirement_from_inq.DESTINATION_SUBINVENTORY;
106: l_header_rec.OPERATION := CSP_PARTS_REQUIREMENT.G_OPR_CREATE;
107: l_header_rec.RESOURCE_TYPE := r_get_requirement_from_inq.RESOURCE_TYPE;
108: l_header_rec.RESOURCE_ID := r_get_requirement_from_inq.RESOURCE_ID;
109:
110: ELSE

Line 125: l_header_rec.OPERATION := CSP_PARTS_REQUIREMENT.G_OPR_CREATE;

121: l_header_rec.SHIP_TO_LOCATION_ID := r_get_requirement_from_apps.SHIP_TO_LOCATION_ID;
122: l_header_rec.NEED_BY_DATE := r_get_requirement_from_apps.NEED_BY_DATE;
123: l_header_rec.DEST_ORGANIZATION_ID := r_get_requirement_from_apps.DESTINATION_ORGANIZATION_ID;
124: l_header_rec.DEST_SUBINVENTORY := r_get_requirement_from_apps.DESTINATION_SUBINVENTORY;
125: l_header_rec.OPERATION := CSP_PARTS_REQUIREMENT.G_OPR_CREATE;
126: l_header_rec.RESOURCE_TYPE := r_get_requirement_from_apps.RESOURCE_TYPE;
127: l_header_rec.RESOURCE_ID := r_get_requirement_from_apps.RESOURCE_ID;
128:
129: END IF;

Line 141: CSP_PARTS_REQUIREMENT.Process_Requirement

137: l_line_rec.UNIT_OF_MEASURE := p_record.UOM_CODE;
138:
139: l_line_table(1) := l_line_rec;
140:
141: CSP_PARTS_REQUIREMENT.Process_Requirement
142: ( P_API_VERSION => 1
143: , PX_HEADER_REC => l_header_rec
144: , PX_LINE_TABLE => l_line_table
145: , P_CREATE_ORDER_FLAG => 'Y'