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.2 2005/11/16 02:47:36 apani noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Process_Options_Pvt';
5:

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.2 2005/11/16 02:47:36 apani noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Process_Options_Pvt';
5:
6:
7: /*-----------------------------------------------------------------------
8: Forward Declarations

Line 12: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

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

Line 25: ,p_x_options_tbl IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE

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

Line 31: ,p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

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

Line 36: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

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

Line 42: ( p_options_tbl IN OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE

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

Line 47: ( p_x_option_rec IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_REC

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

Line 84: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

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

Line 100: l_options_tbl OE_Process_Options_Pvt.Selected_Options_Tbl_Type;

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

Line 101: l_db_options_tbl OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE;

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

Line 508: OE_Process_Options_Pvt.Selected_Options_Tbl_Type

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

Line 639: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

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

Line 711: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

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

Line 1030: ( p_x_option_rec IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_REC

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

Line 1124: ,p_x_options_tbl IN OUT NOCOPY OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE

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

Line 1287: ,p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

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

Line 1338: ( p_options_tbl IN OE_Process_Options_Pvt.Selected_Options_Tbl_Type

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

Line 1544: OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE)

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

Line 1826: ( p_options_tbl IN OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE

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

Line 1890: END OE_Process_Options_Pvt;

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