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.OE_PROCESS_OPTIONS_PVT dependencies on OE_ORDER_PUB

Line 14: ,p_model_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

10: ------------------------------------------------------------------------*/
11:
12: Procedure Handle_DML
13: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type
14: ,p_model_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
15: ,p_ui_flag IN VARCHAR2
16: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
17:
18:

Line 98: l_model_line_rec OE_Order_Pub.Line_Rec_Type;

94: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96: )
97: IS
98: l_model_line_rec OE_Order_Pub.Line_Rec_Type;
99: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
100: l_validation_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
101: l_options_tbl OE_Process_Options_Pvt.Selected_Options_Tbl_Type;
102: l_db_options_tbl OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE;

Line 110: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;

106: l_index NUMBER;
107: l_operation VARCHAR2(1);
108: l_valid_config VARCHAR2(10);
109: l_complete_config VARCHAR2(10);
110: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;
111: l_updated_options_tbl OE_Order_PUB.request_tbl_type;
112: l_rev_date DATE;
113: l_frozen_model_bill VARCHAR2(1);
114: --

Line 111: l_updated_options_tbl OE_Order_PUB.request_tbl_type;

107: l_operation VARCHAR2(1);
108: l_valid_config VARCHAR2(10);
109: l_complete_config VARCHAR2(10);
110: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;
111: l_updated_options_tbl OE_Order_PUB.request_tbl_type;
112: l_rev_date DATE;
113: l_frozen_model_bill VARCHAR2(1);
114: --
115: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 511: ,p_x_updated_options_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type

507: PROCEDURE Prepare_Cascade_Tables
508: ( p_options_tbl IN OUT NOCOPY
509: OE_Process_Options_Pvt.Selected_Options_Tbl_Type
510: ,p_top_model_line_id IN NUMBER
511: ,p_x_updated_options_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
512: ,p_x_deleted_options_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type)
513: IS
514: l_count NUMBER;
515: I NUMBER;

Line 512: ,p_x_deleted_options_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type)

508: ( p_options_tbl IN OUT NOCOPY
509: OE_Process_Options_Pvt.Selected_Options_Tbl_Type
510: ,p_top_model_line_id IN NUMBER
511: ,p_x_updated_options_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
512: ,p_x_deleted_options_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type)
513: IS
514: l_count NUMBER;
515: I NUMBER;
516: l_index NUMBER;

Line 517: l_req_rec OE_Order_Pub.Request_Rec_Type;

513: IS
514: l_count NUMBER;
515: I NUMBER;
516: l_index NUMBER;
517: l_req_rec OE_Order_Pub.Request_Rec_Type;
518: --
519: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
520: --
521: BEGIN

Line 713: ,p_model_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

709: a require reason constraint for versioning during create operation.
710: ------------------------------------------------------------*/
711: Procedure Handle_DML
712: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type
713: ,p_model_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
714: ,p_ui_flag IN VARCHAR2
715: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
716: IS
717: -- process_order in params

Line 719: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

715: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
716: IS
717: -- process_order in params
718: l_control_rec OE_GLOBALS.Control_Rec_Type;
719: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
720: l_line_upd_rec OE_ORDER_PUB.Line_Rec_Type;
721: l_line_del_rec OE_ORDER_PUB.Line_Rec_Type;
722: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
723: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 720: l_line_upd_rec OE_ORDER_PUB.Line_Rec_Type;

716: IS
717: -- process_order in params
718: l_control_rec OE_GLOBALS.Control_Rec_Type;
719: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
720: l_line_upd_rec OE_ORDER_PUB.Line_Rec_Type;
721: l_line_del_rec OE_ORDER_PUB.Line_Rec_Type;
722: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
723: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
724: l_model_qty NUMBER;

Line 721: l_line_del_rec OE_ORDER_PUB.Line_Rec_Type;

717: -- process_order in params
718: l_control_rec OE_GLOBALS.Control_Rec_Type;
719: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
720: l_line_upd_rec OE_ORDER_PUB.Line_Rec_Type;
721: l_line_del_rec OE_ORDER_PUB.Line_Rec_Type;
722: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
723: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
724: l_model_qty NUMBER;
725: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

Line 722: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;

718: l_control_rec OE_GLOBALS.Control_Rec_Type;
719: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
720: l_line_upd_rec OE_ORDER_PUB.Line_Rec_Type;
721: l_line_del_rec OE_ORDER_PUB.Line_Rec_Type;
722: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
723: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
724: l_model_qty NUMBER;
725: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
726: I NUMBER;

Line 723: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

719: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
720: l_line_upd_rec OE_ORDER_PUB.Line_Rec_Type;
721: l_line_del_rec OE_ORDER_PUB.Line_Rec_Type;
722: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
723: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
724: l_model_qty NUMBER;
725: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
726: I NUMBER;
727: l_line_count NUMBER;

Line 728: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;

724: l_model_qty NUMBER;
725: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
726: I NUMBER;
727: l_line_count NUMBER;
728: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
729: l_class_line_count NUMBER;
730: l_class_line_tbl OE_Order_PUB.Line_Tbl_Type;
731:
732: l_direct_save BOOLEAN;

Line 730: l_class_line_tbl OE_Order_PUB.Line_Tbl_Type;

726: I NUMBER;
727: l_line_count NUMBER;
728: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
729: l_class_line_count NUMBER;
730: l_class_line_tbl OE_Order_PUB.Line_Tbl_Type;
731:
732: l_direct_save BOOLEAN;
733: l_profile_value VARCHAR2(1) :=
734: upper(FND_PROFILE.VALUE('ONT_CONFIG_QUICK_SAVE'));

Line 780: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

776:
777: l_line_count := 0;
778: l_class_line_count := 0;
779:
780: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
781: l_line_upd_rec := l_line_rec;
782: l_line_del_rec := l_line_rec;
783:
784: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

Line 1034: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

1030: PROCEDURE Handle_Disabled_Options
1031: ( p_x_option_rec IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_REC
1032: ,p_top_model_line_id IN NUMBER)
1033: IS
1034: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
1035: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
1036: I NUMBER;
1037: l_sec_result NUMBER;
1038: l_return_status VARCHAR2(1);

Line 1035: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;

1031: ( p_x_option_rec IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_REC
1032: ,p_top_model_line_id IN NUMBER)
1033: IS
1034: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
1035: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
1036: I NUMBER;
1037: l_sec_result NUMBER;
1038: l_return_status VARCHAR2(1);
1039: l_line_count NUMBER;