DBA Data[Home] [Help]

APPS.OE_CONFIG_UTIL dependencies on OE_PROCESS_OPTIONS_PVT

Line 1307: ( p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type

1303: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
1304:
1305:
1306: PROCEDURE Cascade_Qty
1307: ( p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
1308: ,p_component_code IN VARCHAR2
1309: ,p_ratio IN NUMBER
1310: -- 4211654
1311: ,p_new_qty in number

Line 1318: (p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type

1314: ,p_change_comments IN VARCHAR2);
1315:
1316:
1317: PROCEDURE Delete_Children
1318: (p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
1319: ,p_component_code IN VARCHAR2
1320: ,p_parent_item IN VARCHAR2);
1321:
1322:

Line 1324: (p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type

1320: ,p_parent_item IN VARCHAR2);
1321:
1322:
1323: PROCEDURE Delete_Parent
1324: (p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
1325: ,p_component_code IN VARCHAR2
1326: ,p_top_model_line_id IN NUMBER
1327: ,p_model_component IN VARCHAR2
1328: ,p_ui_flag IN VARCHAR2 := 'N');

Line 1332: (p_x_options_tbl IN Oe_Process_Options_Pvt.Selected_Options_Tbl_Type

1328: ,p_ui_flag IN VARCHAR2 := 'N');
1329:
1330:
1331: FUNCTION No_More_Children_Left
1332: (p_x_options_tbl IN Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
1333: ,p_component_code IN VARCHAR2
1334: ,p_top_model_line_id IN NUMBER
1335: ,p_model_component IN VARCHAR2
1336: ,p_ui_flag IN VARCHAR2 := 'N')

Line 1341: (p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type

1337: RETURN BOOLEAN;
1338:
1339:
1340: PROCEDURE Propogate_Change_To_Parent
1341: (p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
1342: ,p_component_code IN VARCHAR2
1343: ,p_top_model_line_id IN NUMBER
1344: ,p_model_component IN VARCHAR2
1345: ,p_ui_flag IN VARCHAR2 := 'N');

Line 1405: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type;

1401: l_msg_data VARCHAR2(2000);
1402: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1403: l_result_out VARCHAR2(30);
1404: l_options_tbl
1405: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type;
1406: -- input xml message
1407: l_xml_message LONG := NULL;
1408: l_xml_hdr VARCHAR2(2000);
1409:

Line 1816: l_options_tbl Oe_Process_Options_Pvt.Selected_Options_Tbl_Type;

1812: x_valid_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1813: x_complete_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1814: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1815: IS
1816: l_options_tbl Oe_Process_Options_Pvt.Selected_Options_Tbl_Type;
1817: l_updated_options_tbl OE_Order_PUB.request_tbl_type;
1818: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;
1819: I NUMBER;
1820: l_change_flag VARCHAR2(1);

Line 1860: OE_Process_Options_Pvt.Get_Options_From_DB

1856:
1857:
1858: l_return_status := FND_API.G_RET_STS_SUCCESS;
1859:
1860: OE_Process_Options_Pvt.Get_Options_From_DB
1861: ( p_top_model_line_id => p_model_line_id
1862: ,p_get_model_line => TRUE
1863: ,p_caller => 'OPTIONS WINDOW BATCH'
1864: ,p_query_criteria => 4

Line 1882: OE_Process_Options_Pvt.Prepare_Cascade_Tables

1878: l_deleted_options_tbl := p_deleted_options_tbl;
1879:
1880: IF l_msg_data = 'Y' THEN
1881:
1882: OE_Process_Options_Pvt.Prepare_Cascade_Tables
1883: ( p_options_tbl => l_options_tbl
1884: ,p_top_model_line_id => p_model_line_id
1885: ,p_x_updated_options_tbl => l_updated_options_tbl
1886: ,p_x_deleted_options_tbl => l_deleted_options_tbl);

Line 1910: OE_Process_Options_Pvt.Process_Config_Options

1906: IF l_debug_level > 0 THEN
1907: oe_debug_pub.add('CALLING PROCESS_CONFIG_OPTIONS' , 1);
1908: END IF;
1909:
1910: OE_Process_Options_Pvt.Process_Config_Options
1911: (p_options_tbl => l_options_tbl,
1912: p_header_id => p_header_id,
1913: p_top_model_line_id => p_model_line_id,
1914: p_ui_flag => 'N',

Line 1923: OE_Process_Options_Pvt.Handle_Ret_Status

1919: x_msg_count => l_msg_count,
1920: x_msg_data => l_msg_data,
1921: x_return_status => x_return_status);
1922:
1923: OE_Process_Options_Pvt.Handle_Ret_Status
1924: (p_return_Status => x_return_status);
1925:
1926: IF l_debug_level > 0 THEN
1927: oe_debug_pub.add('LEAVING BOM_CONFIG_VALIDATION' , 1);

Line 1972: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type

1968: PROCEDURE Cascade_Updates_Deletes
1969: ( p_model_line_id IN NUMBER
1970: ,p_model_component IN VARCHAR2
1971: ,p_x_options_tbl IN OUT NOCOPY
1972: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
1973: ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1974: := OE_Order_Pub.G_MISS_REQUEST_TBL
1975: ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1976: := OE_Order_Pub.G_MISS_REQUEST_TBL

Line 2025: l_index := OE_Process_Options_Pvt.Find_Matching_comp_index

2021: END IF;
2022:
2023: BEGIN
2024: -- set operation to delete
2025: l_index := OE_Process_Options_Pvt.Find_Matching_comp_index
2026: ( p_options_tbl => p_x_options_tbl
2027: ,p_comp_code => l_req_rec.param2);
2028:
2029: IF l_debug_level > 0 THEN

Line 2163: ( p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type

2159: bug fixed: only one level cascade will happen.
2160: ----------------------------------------------------------------------*/
2161:
2162: PROCEDURE Cascade_Qty
2163: ( p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
2164: ,p_component_code IN VARCHAR2
2165: ,p_ratio IN NUMBER
2166: -- 4211654
2167: ,p_new_qty IN number

Line 2238: ( p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type

2234: Changed the signature of the procedure to accept the name
2235: of the class.
2236: ----------------------------------------------------------------------*/
2237: PROCEDURE Delete_Children
2238: ( p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
2239: ,p_component_code IN VARCHAR2
2240: ,p_parent_item IN VARCHAR2)
2241: IS
2242: I NUMBER;

Line 2302: (p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type

2298: delete the parent only if the only option under it is getting deleted.
2299: Never delete the model line.
2300: ----------------------------------------------------------------------*/
2301: PROCEDURE Delete_Parent
2302: (p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
2303: ,p_component_code IN VARCHAR2
2304: ,p_top_model_line_id IN NUMBER
2305: ,p_model_component IN VARCHAR2
2306: ,p_ui_flag IN VARCHAR2 := 'N')

Line 2411: (p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type

2407: propogate change to the parent only if the only option under
2408: it is changed.
2409: ----------------------------------------------------------------------*/
2410: PROCEDURE Propogate_Change_To_Parent
2411: (p_x_options_tbl IN OUT NOCOPY Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
2412: ,p_component_code IN VARCHAR2
2413: ,p_top_model_line_id IN NUMBER
2414: ,p_model_component IN VARCHAR2
2415: ,p_ui_flag IN VARCHAR2 := 'N')

Line 2530: (p_x_options_tbl IN Oe_Process_Options_Pvt.Selected_Options_Tbl_Type

2526: p_component_code is the component_code of the child, for which
2527: we are trying tofind out if this is the only child to its parent.
2528: ----------------------------------------------------------------------*/
2529: FUNCTION No_More_Children_Left
2530: (p_x_options_tbl IN Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
2531: ,p_component_code IN VARCHAR2
2532: ,p_top_model_line_id IN NUMBER
2533: ,p_model_component IN VARCHAR2
2534: ,p_ui_flag IN VARCHAR2 := 'N')

Line 2714: l_use_configurator := OE_Process_Options_Pvt.Use_Configurator;

2710: ,p_source_document_type_id => l_source_document_type_id
2711: ,p_source_document_id => l_source_document_id
2712: ,p_source_document_line_id => l_source_document_line_id);
2713:
2714: l_use_configurator := OE_Process_Options_Pvt.Use_Configurator;
2715:
2716: IF l_use_configurator THEN
2717: IF l_debug_level > 0 THEN
2718: oe_debug_pub.add('USE CONFIGURATOR IS TRUE' , 1);

Line 2875: l_db_options_tbl OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE;

2871: IS
2872: l_html_pieces CZ_BATCH_VALIDATE.CFG_OUTPUT_PIECES;
2873: l_option CZ_BATCH_VALIDATE.INPUT_SELECTION;
2874: l_batch_val_tbl CZ_BATCH_VALIDATE.CFG_INPUT_LIST;
2875: l_db_options_tbl OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE;
2876: -- update / delete options
2877: l_req_rec OE_Order_Pub.Request_Rec_Type;
2878: l_flag VARCHAR2(30) := '0';
2879:

Line 2963: OE_Process_Options_Pvt.Get_Options_From_DB

2959: IF l_debug_level > 0 THEN
2960: oe_debug_pub.add('GETTING PREVIOUSLY SAVED OPTIONS FROM DB' , 2 );
2961: END IF;
2962:
2963: OE_Process_Options_Pvt.Get_Options_From_DB
2964: ( p_top_model_line_id => p_model_line_id
2965: ,x_disabled_options => l_flag
2966: ,x_options_tbl => l_db_options_tbl);
2967:

Line 8689: IF OE_Process_Options_Pvt.Use_Configurator THEN

8685: l_profile := nvl(FND_PROFILE.Value('ONT_CONFIG_EFFECTIVITY_DATE'), '1');
8686:
8687: IF l_profile > 1 THEN
8688:
8689: IF OE_Process_Options_Pvt.Use_Configurator THEN
8690: IF l_debug_level > 0 THEN
8691: oe_debug_pub.add('USE CONFIGURATOR, ct fix' , 1);
8692: END IF;
8693: ELSE