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_PROCESS_OPTIONS_PVT

Line 1: PACKAGE BODY OE_Process_Options_Pvt AS

1: PACKAGE BODY OE_Process_Options_Pvt AS
2: /* $Header: OEXVOPTB.pls 120.4 2011/05/03 09:47:13 ckasera ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Process_Options_Pvt';
5: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8656395

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Process_Options_Pvt';

1: PACKAGE BODY OE_Process_Options_Pvt AS
2: /* $Header: OEXVOPTB.pls 120.4 2011/05/03 09:47:13 ckasera ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Process_Options_Pvt';
5: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8656395
6:
7:
8: /*-----------------------------------------------------------------------

Line 13: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

9: Forward Declarations
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:

Line 26: ,p_x_options_tbl IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE

22: ,p_model_quantity IN NUMBER
23: ,p_top_bill_sequence_id IN NUMBER
24: ,p_effective_date IN DATE
25: ,p_ui_flag IN VARCHAR2
26: ,p_x_options_tbl IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE
27: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
28:
29:
30: PROCEDURE component_exists

Line 32: ,p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

28:
29:
30: PROCEDURE component_exists
31: ( p_component IN VARCHAR2
32: ,p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type
33: ,x_result OUT NOCOPY /* file.sql.39 change */ BOOLEAN);
34:
35:
36: PROCEDURE Check_Duplicate_Components

Line 37: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

33: ,x_result OUT NOCOPY /* file.sql.39 change */ BOOLEAN);
34:
35:
36: PROCEDURE Check_Duplicate_Components
37: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type
38: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39: );
40:
41:

Line 43: ( p_options_tbl IN OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE

39: );
40:
41:
42: PROCEDURE Load_BOM_Table
43: ( p_options_tbl IN OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE
44: ,x_bom_validation_tbl OUT NOCOPY OE_CONFIG_VALIDATION_PVT.VALIDATE_OPTIONS_TBL_TYPE);
45:
46:
47: PROCEDURE Handle_Disabled_Options

Line 48: ( p_x_option_rec IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_REC

44: ,x_bom_validation_tbl OUT NOCOPY OE_CONFIG_VALIDATION_PVT.VALIDATE_OPTIONS_TBL_TYPE);
45:
46:
47: PROCEDURE Handle_Disabled_Options
48: ( p_x_option_rec IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_REC
49: ,p_top_model_line_id IN NUMBER);
50:
51: /* --------------------------------------------------------------------
52: Procedure Name : Process_Config_Options

Line 85: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

81: 3687870 : check the fulfilled_flag, open flag etc. for UI.
82: ---------------------------------------------------------------------- */
83:
84: Procedure Process_Config_Options
85: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type
86: ,p_header_id IN NUMBER
87: ,p_top_model_line_id IN NUMBER
88: ,p_ui_flag IN VARCHAR2 := 'Y'
89: ,p_caller IN VARCHAR2 := '' -- bug 4636208

Line 101: l_options_tbl OE_Process_Options_Pvt.Selected_Options_Tbl_Type;

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;
103: l_bom_validation_tbl OE_CONFIG_VALIDATION_PVT.VALIDATE_OPTIONS_TBL_TYPE;
104: l_count NUMBER;
105: I NUMBER;

Line 102: l_db_options_tbl OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE;

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;
103: l_bom_validation_tbl OE_CONFIG_VALIDATION_PVT.VALIDATE_OPTIONS_TBL_TYPE;
104: l_count NUMBER;
105: I NUMBER;
106: l_index NUMBER;

Line 509: OE_Process_Options_Pvt.Selected_Options_Tbl_Type

505: 3563690 => pass ordered_item in param10
506: ----------------------------------------------------------*/
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

Line 640: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

636: FUNCTION: Find_Matching_Comp_Index
637: Used to remove duplicates from the options table.
638: ----------------------------------------------------------*/
639: FUNCTION Find_Matching_Comp_Index
640: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type
641: ,p_comp_code IN VARCHAR2)
642: RETURN NUMBER
643: IS
644: I NUMBER;

Line 712: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

708: Send reason for CREATE operation also, will be required if there is
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

Line 1031: ( p_x_option_rec IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_REC

1027: system can eihter delete or cancel them also populates
1028: message back to user to indicate the same.
1029: -----------------------------------------------------------------------*/
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;

Line 1125: ,p_x_options_tbl IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE

1121: ,p_model_quantity IN NUMBER
1122: ,p_top_bill_sequence_id IN NUMBER
1123: ,p_effective_date IN DATE
1124: ,p_ui_flag IN VARCHAR2
1125: ,p_x_options_tbl IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE
1126: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1127: IS
1128: I NUMBER;
1129: J NUMBER;

Line 1288: ,p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

1284: ------------------------------------------------------------------------*/
1285:
1286: PROCEDURE component_exists
1287: ( p_component IN VARCHAR2
1288: ,p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type
1289: ,x_result OUT NOCOPY /* file.sql.39 change */ BOOLEAN)
1290: IS
1291: I NUMBER;
1292: --

Line 1339: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

1335: This procedure makes sure that every component in the configuration
1336: appears only once.
1337: -------------------------------------------------------------------------*/
1338: PROCEDURE Check_Duplicate_Components
1339: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type
1340: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1341: )
1342: IS
1343: l_outer_index NUMBER;

Line 1545: OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE)

1541: ,p_caller IN VARCHAR2:= ''
1542: ,p_query_criteria IN NUMBER := 1
1543: ,x_disabled_options OUT NOCOPY VARCHAR2
1544: ,x_options_tbl OUT NOCOPY
1545: OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE)
1546: IS
1547: CURSOR Get_Options
1548: IS
1549: SELECT component_code , ordered_quantity, inventory_item_id,

Line 1827: ( p_options_tbl IN OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE

1823: PROCEDURE: Load_BOM_Table
1824:
1825: -------------------------------------------------------------------------*/
1826: PROCEDURE Load_BOM_Table
1827: ( p_options_tbl IN OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE
1828: ,x_bom_validation_tbl OUT NOCOPY OE_CONFIG_VALIDATION_PVT.VALIDATE_OPTIONS_TBL_TYPE)
1829: IS
1830: I NUMBER;
1831: l_count NUMBER;

Line 1891: END OE_Process_Options_Pvt;

1887: RAISE;
1888: END;
1889:
1890:
1891: END OE_Process_Options_Pvt;