DBA Data[Home] [Help]

APPS.CSFW_ORDER_PARTS dependencies on CSP_PARTS_REQUIREMENT

Line 50: l_header_rec csp_parts_requirement.header_rec_type;

46:
47: l_return_status VARCHAR2(1);
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(2000);
50: l_header_rec csp_parts_requirement.header_rec_type;
51: l_line_rec csp_parts_requirement.line_rec_type;
52: l_line_tbl csp_parts_requirement.line_tbl_type;
53: v_OPEN_REQUIREMENT varchar2(240);
54: l_destination_org_id number;

Line 51: l_line_rec csp_parts_requirement.line_rec_type;

47: l_return_status VARCHAR2(1);
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(2000);
50: l_header_rec csp_parts_requirement.header_rec_type;
51: l_line_rec csp_parts_requirement.line_rec_type;
52: l_line_tbl csp_parts_requirement.line_tbl_type;
53: v_OPEN_REQUIREMENT varchar2(240);
54: l_destination_org_id number;
55: l_dest_sub_inv varchar2(30);

Line 52: l_line_tbl csp_parts_requirement.line_tbl_type;

48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(2000);
50: l_header_rec csp_parts_requirement.header_rec_type;
51: l_line_rec csp_parts_requirement.line_rec_type;
52: l_line_tbl csp_parts_requirement.line_tbl_type;
53: v_OPEN_REQUIREMENT varchar2(240);
54: l_destination_org_id number;
55: l_dest_sub_inv varchar2(30);
56:

Line 119: CSP_PARTS_REQUIREMENT.process_requirement(p_api_version => 1.0

115: l_line_rec.line_num := 1;
116: l_line_tbl(1) := l_line_rec;
117:
118: --we would call with true commit flag
119: CSP_PARTS_REQUIREMENT.process_requirement(p_api_version => 1.0
120: ,p_Init_Msg_List => FND_API.G_TRUE
121: ,p_commit => FND_API.G_TRUE
122: ,px_header_rec => l_header_rec
123: ,px_line_table => l_Line_Tbl

Line 201: l_header_rec csp_parts_requirement.header_rec_type;

197:
198: l_return_status VARCHAR2(1);
199: l_msg_count NUMBER;
200: l_msg_data VARCHAR2(2000);
201: l_header_rec csp_parts_requirement.header_rec_type;
202: l_line_rec csp_parts_requirement.line_rec_type;
203: l_line_tbl csp_parts_requirement.line_tbl_type;
204: v_OPEN_REQUIREMENT varchar2(240);
205: l_resource_id number;

Line 202: l_line_rec csp_parts_requirement.line_rec_type;

198: l_return_status VARCHAR2(1);
199: l_msg_count NUMBER;
200: l_msg_data VARCHAR2(2000);
201: l_header_rec csp_parts_requirement.header_rec_type;
202: l_line_rec csp_parts_requirement.line_rec_type;
203: l_line_tbl csp_parts_requirement.line_tbl_type;
204: v_OPEN_REQUIREMENT varchar2(240);
205: l_resource_id number;
206: l_resource_type varchar2(30);

Line 203: l_line_tbl csp_parts_requirement.line_tbl_type;

199: l_msg_count NUMBER;
200: l_msg_data VARCHAR2(2000);
201: l_header_rec csp_parts_requirement.header_rec_type;
202: l_line_rec csp_parts_requirement.line_rec_type;
203: l_line_tbl csp_parts_requirement.line_tbl_type;
204: v_OPEN_REQUIREMENT varchar2(240);
205: l_resource_id number;
206: l_resource_type varchar2(30);
207: l_destination_org_id NUMBER;

Line 275: CSP_PARTS_REQUIREMENT.process_requirement(p_api_version => 1.0

271:
272:
273:
274: --CSP_PARTS_ORDER.process_order(p_api_version => 1.0
275: CSP_PARTS_REQUIREMENT.process_requirement(p_api_version => 1.0
276: ,p_Init_Msg_List => FND_API.G_TRUE
277: ,p_commit => FND_API.G_TRUE
278: ,px_header_rec => l_header_rec
279: ,px_line_table => l_Line_Tbl