DBA Data[Home] [Help]

APPS.CSM_REQUIREMENTS_PKG dependencies on CSP_PARTS_REQUIREMENT

Line 65: l_header_rec CSP_PARTS_REQUIREMENT.HEADER_REC_TYPE;

61: p_error_msg OUT NOCOPY VARCHAR2,
62: x_return_status IN OUT NOCOPY VARCHAR2
63: ) IS
64:
65: l_header_rec CSP_PARTS_REQUIREMENT.HEADER_REC_TYPE;
66: l_line_rec CSP_PARTS_REQUIREMENT.LINE_REC_TYPE;
67: l_line_table CSP_PARTS_REQUIREMENT.LINE_TBL_TYPE;
68:
69: l_s_org_id NUMBER := 207;

Line 66: l_line_rec CSP_PARTS_REQUIREMENT.LINE_REC_TYPE;

62: x_return_status IN OUT NOCOPY VARCHAR2
63: ) IS
64:
65: l_header_rec CSP_PARTS_REQUIREMENT.HEADER_REC_TYPE;
66: l_line_rec CSP_PARTS_REQUIREMENT.LINE_REC_TYPE;
67: l_line_table CSP_PARTS_REQUIREMENT.LINE_TBL_TYPE;
68:
69: l_s_org_id NUMBER := 207;
70: l_d_org_id NUMBER := 204;

Line 67: l_line_table CSP_PARTS_REQUIREMENT.LINE_TBL_TYPE;

63: ) IS
64:
65: l_header_rec CSP_PARTS_REQUIREMENT.HEADER_REC_TYPE;
66: l_line_rec CSP_PARTS_REQUIREMENT.LINE_REC_TYPE;
67: l_line_table CSP_PARTS_REQUIREMENT.LINE_TBL_TYPE;
68:
69: l_s_org_id NUMBER := 207;
70: l_d_org_id NUMBER := 204;
71: l_item_id NUMBER := 155;

Line 115: -- l_header_rec.ADDRESS_TYPE := NVL(r_get_requirement_from_inq.ADDRESS_TYPE, CSP_PARTS_REQUIREMENT.G_ADDR_RESOURCE);

111: l_header_rec.REQUIREMENT_HEADER_ID := r_get_requirement_from_inq.REQUIREMENT_HEADER_ID;
112: l_header_rec.REQUISITION_NUMBER := r_get_requirement_from_inq.REQUIREMENT_HEADER_ID;
113: l_header_rec.ORDER_TYPE_ID := fnd_profile.value('CSP_ORDER_TYPE');
114: l_header_rec.SHIP_TO_LOCATION_ID := r_get_requirement_from_inq.SHIP_TO_LOCATION_ID;
115: -- l_header_rec.ADDRESS_TYPE := NVL(r_get_requirement_from_inq.ADDRESS_TYPE, CSP_PARTS_REQUIREMENT.G_ADDR_RESOURCE);
116: l_header_rec.NEED_BY_DATE := r_get_requirement_from_inq.NEED_BY_DATE;
117: l_header_rec.DEST_ORGANIZATION_ID := r_get_requirement_from_inq.DESTINATION_ORGANIZATION_ID;
118: l_header_rec.DEST_SUBINVENTORY := r_get_requirement_from_inq.DESTINATION_SUBINVENTORY;
119: l_header_rec.OPERATION := CSP_PARTS_REQUIREMENT.G_OPR_CREATE;

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

115: -- l_header_rec.ADDRESS_TYPE := NVL(r_get_requirement_from_inq.ADDRESS_TYPE, CSP_PARTS_REQUIREMENT.G_ADDR_RESOURCE);
116: l_header_rec.NEED_BY_DATE := r_get_requirement_from_inq.NEED_BY_DATE;
117: l_header_rec.DEST_ORGANIZATION_ID := r_get_requirement_from_inq.DESTINATION_ORGANIZATION_ID;
118: l_header_rec.DEST_SUBINVENTORY := r_get_requirement_from_inq.DESTINATION_SUBINVENTORY;
119: l_header_rec.OPERATION := CSP_PARTS_REQUIREMENT.G_OPR_CREATE;
120: l_header_rec.RESOURCE_TYPE := r_get_requirement_from_inq.RESOURCE_TYPE;
121: l_header_rec.RESOURCE_ID := r_get_requirement_from_inq.RESOURCE_ID;
122: l_header_rec.TASK_ID := r_get_requirement_from_inq.TASK_ID;
123: l_header_rec.TASK_ASSIGNMENT_ID := r_get_requirement_from_inq.TASK_ASSIGNMENT_ID;

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

152: l_header_rec.shipping_method_code := r_get_requirement_from_apps.shipping_method_code;
153: l_header_rec.NEED_BY_DATE := r_get_requirement_from_apps.NEED_BY_DATE;
154: l_header_rec.DEST_ORGANIZATION_ID := r_get_requirement_from_apps.DESTINATION_ORGANIZATION_ID;
155: l_header_rec.DEST_SUBINVENTORY := r_get_requirement_from_apps.DESTINATION_SUBINVENTORY;
156: l_header_rec.OPERATION := CSP_PARTS_REQUIREMENT.G_OPR_CREATE;
157: l_header_rec.RESOURCE_TYPE := r_get_requirement_from_apps.RESOURCE_TYPE;
158: l_header_rec.RESOURCE_ID := r_get_requirement_from_apps.RESOURCE_ID;
159: l_header_rec.TASK_ID := r_get_requirement_from_apps.TASK_ID;
160: l_header_rec.TASK_ASSIGNMENT_ID := r_get_requirement_from_apps.TASK_ASSIGNMENT_ID;

Line 210: CSP_PARTS_REQUIREMENT.Process_Requirement

206:
207:
208: l_line_table(1) := l_line_rec;
209:
210: CSP_PARTS_REQUIREMENT.Process_Requirement
211: ( P_API_VERSION => 1
212: , P_INIT_MSG_LIST => FND_API.G_TRUE
213: , PX_HEADER_REC => l_header_rec
214: , PX_LINE_TABLE => l_line_table