DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on CSP_PARTS_REQUIREMENT

Line 426: p_header_rec IN csp_parts_requirement.header_rec_type

422: PROCEDURE Cancel_Order(
423: /* p_api_version IN NUMBER
424: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE
425: ,p_commit IN VARCHAR2 := FND_API.G_FALSE */
426: p_header_rec IN csp_parts_requirement.header_rec_type
427: ,p_line_table IN csp_parts_requirement.Line_Tbl_type
428: ,p_process_Type IN VARCHAR2
429: ,x_return_status OUT NOCOPY VARCHAR2
430: ,x_msg_count OUT NOCOPY NUMBER

Line 427: ,p_line_table IN csp_parts_requirement.Line_Tbl_type

423: /* p_api_version IN NUMBER
424: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE
425: ,p_commit IN VARCHAR2 := FND_API.G_FALSE */
426: p_header_rec IN csp_parts_requirement.header_rec_type
427: ,p_line_table IN csp_parts_requirement.Line_Tbl_type
428: ,p_process_Type IN VARCHAR2
429: ,x_return_status OUT NOCOPY VARCHAR2
430: ,x_msg_count OUT NOCOPY NUMBER
431: ,x_msg_data OUT NOCOPY VARCHAR2

Line 435: l_line_tbl CSP_PARTS_REQUIREMENT.Line_tbl_type;

431: ,x_msg_data OUT NOCOPY VARCHAR2
432: ) IS
433: l_api_version_number CONSTANT NUMBER := 1.0;
434: l_api_name CONSTANT VARCHAR2(30) := 'cancel_order';
435: l_line_tbl CSP_PARTS_REQUIREMENT.Line_tbl_type;
436: l_line_rec CSP_PARTS_REQUIREMENT.Line_rec_type;
437: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
438: l_msg_count NUMBER;
439: l_msg_data VARCHAR2(2000);

Line 436: l_line_rec CSP_PARTS_REQUIREMENT.Line_rec_type;

432: ) IS
433: l_api_version_number CONSTANT NUMBER := 1.0;
434: l_api_name CONSTANT VARCHAR2(30) := 'cancel_order';
435: l_line_tbl CSP_PARTS_REQUIREMENT.Line_tbl_type;
436: l_line_rec CSP_PARTS_REQUIREMENT.Line_rec_type;
437: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
438: l_msg_count NUMBER;
439: l_msg_data VARCHAR2(2000);
440:

Line 935: l_header_rec csp_parts_requirement.header_rec_type;

931: p_cancel_reason IN Varchar2,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,
934: x_msg_data OUT NOCOPY VARCHAR2) IS
935: l_header_rec csp_parts_requirement.header_rec_type;
936: l_line_table csp_parts_requirement.line_tbl_type;
937: begin
938: l_line_table(1).order_line_id := p_order_line_id;
939: l_line_table(1).change_reason := p_cancel_reason;

Line 936: l_line_table csp_parts_requirement.line_tbl_type;

932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,
934: x_msg_data OUT NOCOPY VARCHAR2) IS
935: l_header_rec csp_parts_requirement.header_rec_type;
936: l_line_table csp_parts_requirement.line_tbl_type;
937: begin
938: l_line_table(1).order_line_id := p_order_line_id;
939: l_line_table(1).change_reason := p_cancel_reason;
940: Cancel_Order(

Line 960: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.header_rec_type

956: PROCEDURE process_order(
957: p_api_version IN NUMBER
958: ,p_Init_Msg_List IN VARCHAR2
959: ,p_commit IN VARCHAR2
960: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.header_rec_type
961: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
962: ,p_process_type IN VARCHAR2
963: ,x_return_status OUT NOCOPY VARCHAR2
964: ,x_msg_count OUT NOCOPY NUMBER

Line 961: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type

957: p_api_version IN NUMBER
958: ,p_Init_Msg_List IN VARCHAR2
959: ,p_commit IN VARCHAR2
960: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.header_rec_type
961: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
962: ,p_process_type IN VARCHAR2
963: ,x_return_status OUT NOCOPY VARCHAR2
964: ,x_msg_count OUT NOCOPY NUMBER
965: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1014: l_header_rec csp_parts_requirement.header_rec_type;

1010: l_order_line_category_code VARCHAR2(30);
1011: l_order_number NUMBER;
1012: l_source_operating_unit NUMBER;
1013:
1014: l_header_rec csp_parts_requirement.header_rec_type;
1015: l_line_rec csp_parts_requirement.line_rec_type;
1016: l_line_tbl csp_parts_requirement.Line_tbl_type;
1017: l_dist_Rec csp_parts_order.req_dist_rec_type;
1018:

Line 1015: l_line_rec csp_parts_requirement.line_rec_type;

1011: l_order_number NUMBER;
1012: l_source_operating_unit NUMBER;
1013:
1014: l_header_rec csp_parts_requirement.header_rec_type;
1015: l_line_rec csp_parts_requirement.line_rec_type;
1016: l_line_tbl csp_parts_requirement.Line_tbl_type;
1017: l_dist_Rec csp_parts_order.req_dist_rec_type;
1018:
1019: l_transferred_to_oe_flag VARCHAR2(1) := 'Y';

Line 1016: l_line_tbl csp_parts_requirement.Line_tbl_type;

1012: l_source_operating_unit NUMBER;
1013:
1014: l_header_rec csp_parts_requirement.header_rec_type;
1015: l_line_rec csp_parts_requirement.line_rec_type;
1016: l_line_tbl csp_parts_requirement.Line_tbl_type;
1017: l_dist_Rec csp_parts_order.req_dist_rec_type;
1018:
1019: l_transferred_to_oe_flag VARCHAR2(1) := 'Y';
1020: l_msg varchar2(2000);

Line 2837: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.header_rec_type

2833: PROCEDURE process_purchase_req(
2834: p_api_version IN NUMBER
2835: ,p_Init_Msg_List IN VARCHAR2
2836: ,p_commit IN VARCHAR2
2837: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.header_rec_type
2838: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
2839: ,x_return_status OUT NOCOPY VARCHAR2
2840: ,x_msg_count OUT NOCOPY NUMBER
2841: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2838: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type

2834: p_api_version IN NUMBER
2835: ,p_Init_Msg_List IN VARCHAR2
2836: ,p_commit IN VARCHAR2
2837: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.header_rec_type
2838: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
2839: ,x_return_status OUT NOCOPY VARCHAR2
2840: ,x_msg_count OUT NOCOPY NUMBER
2841: ,x_msg_data OUT NOCOPY VARCHAR2
2842: )

Line 2859: l_header_rec csp_parts_requirement.header_rec_type;

2855: l_org_id NUMBER;
2856: l_line_type_id NUMBER;
2857: l_dummy NUMBER;
2858:
2859: l_header_rec csp_parts_requirement.header_rec_type;
2860: l_line_rec csp_parts_requirement.line_rec_type;
2861: l_line_tbl csp_parts_requirement.Line_tbl_type;
2862:
2863: l_gl_encumbered_date DATE;

Line 2860: l_line_rec csp_parts_requirement.line_rec_type;

2856: l_line_type_id NUMBER;
2857: l_dummy NUMBER;
2858:
2859: l_header_rec csp_parts_requirement.header_rec_type;
2860: l_line_rec csp_parts_requirement.line_rec_type;
2861: l_line_tbl csp_parts_requirement.Line_tbl_type;
2862:
2863: l_gl_encumbered_date DATE;
2864: l_prevent_encumbrance_flag VARCHAR2(1);

Line 2861: l_line_tbl csp_parts_requirement.Line_tbl_type;

2857: l_dummy NUMBER;
2858:
2859: l_header_rec csp_parts_requirement.header_rec_type;
2860: l_line_rec csp_parts_requirement.line_rec_type;
2861: l_line_tbl csp_parts_requirement.Line_tbl_type;
2862:
2863: l_gl_encumbered_date DATE;
2864: l_prevent_encumbrance_flag VARCHAR2(1);
2865: l_chart_of_accounts_id NUMBER;