DBA Data[Home] [Help]

APPS.OE_CONFIG_TSO_PVT dependencies on OE_ORDER_PUB

Line 29: ,p_x_Line_Tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

25:
26: PROCEDURE Populate_MACD_action(
27: p_header_id IN NUMBER
28: ,p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
29: ,p_x_Line_Tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
30: ,p_Extended_Attrib_Tbl IN csi_datastructures_pub.ext_attrib_values_tbl
31: ,p_macd_action IN VARCHAR2
32: -- ,x_config_item_tbl OUT NOCOPY CZ_API_PUB.config_tbl_type;
33: -- ,x_config_ext_attr_tbl OUT NOCOPY config_ext_attr_tbl_type

Line 376: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

372: --
373: -- Change Record :
374: ------------------------------------------------------------------
375: PROCEDURE Validate_Container_Model
376: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
377: , p_old_line_rec IN OE_Order_Pub.Line_Rec_Type
378: , x_return_status OUT NOCOPY VARCHAR2
379: )
380: IS

Line 377: , p_old_line_rec IN OE_Order_Pub.Line_Rec_Type

373: -- Change Record :
374: ------------------------------------------------------------------
375: PROCEDURE Validate_Container_Model
376: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
377: , p_old_line_rec IN OE_Order_Pub.Line_Rec_Type
378: , x_return_status OUT NOCOPY VARCHAR2
379: )
380: IS
381: l_delta NUMBER;

Line 807: ( p_line_rec IN OE_Order_pub.Line_Rec_Type := null

803: 6) for ib fields validation send p_line_rec and p_check_ibrconfig
804: -----------------------------------------------------------------*/
805:
806: PROCEDURE Get_MACD_Action_Mode
807: ( p_line_rec IN OE_Order_pub.Line_Rec_Type := null
808: , p_line_id IN NUMBER := null
809: , p_top_model_line_id IN NUMBER := null
810: , p_check_ibreconfig IN VARCHAR2 := null
811: , x_config_mode OUT NOCOPY NUMBER

Line 1409: l_model_line_rec OE_ORDER_PUB.Line_Rec_Type;

1405: , x_msg_count OUT NOCOPY NUMBER
1406: , x_return_status OUT NOCOPY VARCHAR2
1407: )
1408: IS
1409: l_model_line_rec OE_ORDER_PUB.Line_Rec_Type;
1410: l_config_model_rec CZ_API_PUB.config_model_rec_type;
1411: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
1412: l_control_rec OE_GLOBALS.Control_Rec_Type;
1413:

Line 1414: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1410: l_config_model_rec CZ_API_PUB.config_model_rec_type;
1411: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
1412: l_control_rec OE_GLOBALS.Control_Rec_Type;
1413:
1414: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1415: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1416: l_config_tbl CZ_API_PUB.config_tbl_type;
1417: l_config_model_tbl CZ_API_PUB.config_model_tbl_type;
1418:

Line 1415: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1411: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
1412: l_control_rec OE_GLOBALS.Control_Rec_Type;
1413:
1414: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1415: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1416: l_config_tbl CZ_API_PUB.config_tbl_type;
1417: l_config_model_tbl CZ_API_PUB.config_model_tbl_type;
1418:
1419: l_change_flag VARCHAR2(1);

Line 1630: l_line_tbl(I) := OE_Order_PUB.G_MISS_LINE_REC;

1626: ---------now create model lines -----------------
1627:
1628:
1629: FOR I IN 1..l_config_model_tbl.count LOOP
1630: l_line_tbl(I) := OE_Order_PUB.G_MISS_LINE_REC;
1631:
1632: l_line_tbl(I).header_id := l_header_id;
1633: l_line_tbl(I).inventory_item_id :=
1634: l_config_model_tbl(I).inventory_item_id;

Line 1922: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

1918: p_caller IN VARCHAR2,
1919: p_x_header_id IN OUT NOCOPY NUMBER,
1920: p_sold_to_org_id IN NUMBER,
1921: p_MACD_Action IN VARCHAR2,
1922: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1923: p_Instance_Tbl IN csi_datastructures_pub.instance_cz_tbl,
1924: p_Extended_Attrib_Tbl IN csi_datastructures_pub.ext_attrib_values_tbl,
1925: x_container_line_id OUT NOCOPY NUMBER,
1926: x_number_of_containers OUT NOCOPY NUMBER,

Line 2295: l_header_rec OE_Order_PUB.Header_Rec_Type;

2291: ,x_msg_count OUT NOCOPY NUMBER
2292: ,x_msg_data OUT NOCOPY VARCHAR2)
2293: IS
2294: -- Declare following local variables which are in parameters to the header procedure.
2295: l_header_rec OE_Order_PUB.Header_Rec_Type;
2296: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2297: l_control_rec OE_GLOBALS.Control_Rec_Type;
2298:
2299: --

Line 2296: l_old_header_rec OE_Order_PUB.Header_Rec_Type;

2292: ,x_msg_data OUT NOCOPY VARCHAR2)
2293: IS
2294: -- Declare following local variables which are in parameters to the header procedure.
2295: l_header_rec OE_Order_PUB.Header_Rec_Type;
2296: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2297: l_control_rec OE_GLOBALS.Control_Rec_Type;
2298:
2299: --
2300: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2312: l_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;

2308:
2309: -- Use the default control record to call header procedure.
2310: -- Populate the header record with the input data and an operation.
2311:
2312: l_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
2313: l_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
2314: l_header_rec.sold_to_org_id := p_sold_to_org_id;
2315:
2316: -- Set Operation to Create

Line 2313: l_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;

2309: -- Use the default control record to call header procedure.
2310: -- Populate the header record with the input data and an operation.
2311:
2312: l_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
2313: l_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
2314: l_header_rec.sold_to_org_id := p_sold_to_org_id;
2315:
2316: -- Set Operation to Create
2317:

Line 2584: ,p_x_Line_Tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

2580:
2581: PROCEDURE Populate_MACD_action(
2582: p_header_id IN NUMBER
2583: ,p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
2584: ,p_x_Line_Tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2585: ,p_Extended_Attrib_Tbl IN csi_datastructures_pub.ext_attrib_values_tbl
2586: ,p_macd_action IN VARCHAR2
2587: -- ,x_config_item_tbl OUT NOCOPY CZ_API_PUB.config_tbl_type;
2588: -- ,x_config_ext_attr_tbl OUT NOCOPY config_ext_attr_tbl_type

Line 2617: L_line_tbl OE_Order_Pub.Line_Tbl_Type;

2613: l_top_config_header_id NUMBER;
2614: l_top_config_rev_nbr NUMBER;
2615: l_header_id NUMBER;
2616: l_change_flag VARCHAR2(30);
2617: L_line_tbl OE_Order_Pub.Line_Tbl_Type;
2618: l_config_header_id NUMBER;
2619: l_config_rev_nbr NUMBER;
2620: l_valid_config VARCHAR2(10);
2621: l_complete_config VARCHAR2(10);