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 13: ,p_model_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

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

Line 97: l_model_line_rec OE_Order_Pub.Line_Rec_Type;

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

Line 109: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;

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

Line 110: l_updated_options_tbl OE_Order_PUB.request_tbl_type;

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

Line 510: ,p_x_updated_options_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type

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

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

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

Line 516: l_req_rec OE_Order_Pub.Request_Rec_Type;

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

Line 712: ,p_model_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

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

Line 718: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

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

Line 719: l_line_upd_rec OE_ORDER_PUB.Line_Rec_Type;

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

Line 720: l_line_del_rec OE_ORDER_PUB.Line_Rec_Type;

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

Line 721: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;

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

Line 722: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 727: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;

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

Line 729: l_class_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 779: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

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

Line 1033: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

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

Line 1034: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;

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