eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1056: l_header_rec csp_parts_requirement.header_rec_type;

1052: p_cancel_reason IN Varchar2,
1053: x_return_status OUT NOCOPY VARCHAR2,
1054: x_msg_count OUT NOCOPY NUMBER,
1055: x_msg_data OUT NOCOPY VARCHAR2) IS
1056: l_header_rec csp_parts_requirement.header_rec_type;
1057: l_line_table csp_parts_requirement.line_tbl_type;
1058: begin
1059: l_line_table(1).order_line_id := p_order_line_id;
1060: l_line_table(1).change_reason := p_cancel_reason;

Line 1057: l_line_table csp_parts_requirement.line_tbl_type;

1053: x_return_status OUT NOCOPY VARCHAR2,
1054: x_msg_count OUT NOCOPY NUMBER,
1055: x_msg_data OUT NOCOPY VARCHAR2) IS
1056: l_header_rec csp_parts_requirement.header_rec_type;
1057: l_line_table csp_parts_requirement.line_tbl_type;
1058: begin
1059: l_line_table(1).order_line_id := p_order_line_id;
1060: l_line_table(1).change_reason := p_cancel_reason;
1061: Cancel_Order(

Line 1081: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.header_rec_type

1077: PROCEDURE process_order(
1078: p_api_version IN NUMBER
1079: ,p_Init_Msg_List IN VARCHAR2
1080: ,p_commit IN VARCHAR2
1081: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.header_rec_type
1082: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
1083: ,p_process_type IN VARCHAR2
1084: ,p_book_order IN VARCHAR2
1085: ,x_return_status OUT NOCOPY VARCHAR2

Line 1082: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type

1078: p_api_version IN NUMBER
1079: ,p_Init_Msg_List IN VARCHAR2
1080: ,p_commit IN VARCHAR2
1081: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.header_rec_type
1082: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
1083: ,p_process_type IN VARCHAR2
1084: ,p_book_order IN VARCHAR2
1085: ,x_return_status OUT NOCOPY VARCHAR2
1086: ,x_msg_count OUT NOCOPY NUMBER

Line 1136: l_header_rec csp_parts_requirement.header_rec_type;

1132: l_order_line_category_code VARCHAR2(30);
1133: l_order_number NUMBER;
1134: l_source_operating_unit NUMBER;
1135:
1136: l_header_rec csp_parts_requirement.header_rec_type;
1137: l_line_rec csp_parts_requirement.line_rec_type;
1138: l_line_tbl csp_parts_requirement.Line_tbl_type;
1139: l_dist_Rec csp_parts_order.req_dist_rec_type;
1140:

Line 1137: l_line_rec csp_parts_requirement.line_rec_type;

1133: l_order_number NUMBER;
1134: l_source_operating_unit NUMBER;
1135:
1136: l_header_rec csp_parts_requirement.header_rec_type;
1137: l_line_rec csp_parts_requirement.line_rec_type;
1138: l_line_tbl csp_parts_requirement.Line_tbl_type;
1139: l_dist_Rec csp_parts_order.req_dist_rec_type;
1140:
1141: l_transferred_to_oe_flag VARCHAR2(1) := 'Y';

Line 1138: l_line_tbl csp_parts_requirement.Line_tbl_type;

1134: l_source_operating_unit NUMBER;
1135:
1136: l_header_rec csp_parts_requirement.header_rec_type;
1137: l_line_rec csp_parts_requirement.line_rec_type;
1138: l_line_tbl csp_parts_requirement.Line_tbl_type;
1139: l_dist_Rec csp_parts_order.req_dist_rec_type;
1140:
1141: l_transferred_to_oe_flag VARCHAR2(1) := 'Y';
1142: l_msg varchar2(2000);

Line 4323: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.header_rec_type

4319: PROCEDURE process_purchase_req(
4320: p_api_version IN NUMBER
4321: ,p_Init_Msg_List IN VARCHAR2
4322: ,p_commit IN VARCHAR2
4323: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.header_rec_type
4324: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
4325: ,x_return_status OUT NOCOPY VARCHAR2
4326: ,x_msg_count OUT NOCOPY NUMBER
4327: ,x_msg_data OUT NOCOPY VARCHAR2

Line 4324: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type

4320: p_api_version IN NUMBER
4321: ,p_Init_Msg_List IN VARCHAR2
4322: ,p_commit IN VARCHAR2
4323: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.header_rec_type
4324: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
4325: ,x_return_status OUT NOCOPY VARCHAR2
4326: ,x_msg_count OUT NOCOPY NUMBER
4327: ,x_msg_data OUT NOCOPY VARCHAR2
4328: )

Line 4345: l_header_rec csp_parts_requirement.header_rec_type;

4341: l_org_id NUMBER;
4342: l_line_type_id NUMBER;
4343: l_dummy NUMBER;
4344:
4345: l_header_rec csp_parts_requirement.header_rec_type;
4346: l_line_rec csp_parts_requirement.line_rec_type;
4347: l_line_tbl csp_parts_requirement.Line_tbl_type;
4348:
4349: l_gl_encumbered_date DATE;

Line 4346: l_line_rec csp_parts_requirement.line_rec_type;

4342: l_line_type_id NUMBER;
4343: l_dummy NUMBER;
4344:
4345: l_header_rec csp_parts_requirement.header_rec_type;
4346: l_line_rec csp_parts_requirement.line_rec_type;
4347: l_line_tbl csp_parts_requirement.Line_tbl_type;
4348:
4349: l_gl_encumbered_date DATE;
4350: l_prevent_encumbrance_flag VARCHAR2(1);

Line 4347: l_line_tbl csp_parts_requirement.Line_tbl_type;

4343: l_dummy NUMBER;
4344:
4345: l_header_rec csp_parts_requirement.header_rec_type;
4346: l_line_rec csp_parts_requirement.line_rec_type;
4347: l_line_tbl csp_parts_requirement.Line_tbl_type;
4348:
4349: l_gl_encumbered_date DATE;
4350: l_prevent_encumbrance_flag VARCHAR2(1);
4351: l_chart_of_accounts_id NUMBER;

Line 5088: l_header_rec csp_parts_requirement.header_rec_type;

5084: l_module_name varchar2(100) := 'csp.plsql.csp_parts_order.upd_oe_ship_to_add';
5085: l_org_id number;
5086: l_org_org_id number;
5087: l_booked_orders number;
5088: l_header_rec csp_parts_requirement.header_rec_type;
5089: l_header_can_rec csp_parts_requirement.header_rec_type;
5090: l_lines_tbl csp_parts_requirement.Line_Tbl_type;
5091: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
5092: l_oe_line_tbl OE_Order_PUB.line_tbl_type;

Line 5089: l_header_can_rec csp_parts_requirement.header_rec_type;

5085: l_org_id number;
5086: l_org_org_id number;
5087: l_booked_orders number;
5088: l_header_rec csp_parts_requirement.header_rec_type;
5089: l_header_can_rec csp_parts_requirement.header_rec_type;
5090: l_lines_tbl csp_parts_requirement.Line_Tbl_type;
5091: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
5092: l_oe_line_tbl OE_Order_PUB.line_tbl_type;
5093: l_dest_org_id number;

Line 5090: l_lines_tbl csp_parts_requirement.Line_Tbl_type;

5086: l_org_org_id number;
5087: l_booked_orders number;
5088: l_header_rec csp_parts_requirement.header_rec_type;
5089: l_header_can_rec csp_parts_requirement.header_rec_type;
5090: l_lines_tbl csp_parts_requirement.Line_Tbl_type;
5091: l_oe_header_rec oe_order_pub.header_rec_type := OE_ORDER_PUB.G_MISS_HEADER_REC;
5092: l_oe_line_tbl OE_Order_PUB.line_tbl_type;
5093: l_dest_org_id number;
5094: l_dest_subinv varchar2(40);