DBA Data[Home] [Help]

APPS.OE_CONFIG_TSO_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 21: ,p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl

17:
18: PROCEDURE Create_TSO_Order_Lines
19: (p_header_id IN NUMBER
20: ,p_top_model_line_id IN NUMBER
21: ,p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
22: ,x_msg_data OUT NOCOPY VARCHAR2
23: ,x_msg_count OUT NOCOPY NUMBER
24: ,x_return_status OUT NOCOPY VARCHAR2);
25:

Line 28: ,p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl

24: ,x_return_status OUT NOCOPY VARCHAR2);
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;

Line 30: ,p_Extended_Attrib_Tbl IN csi_datastructures_pub.ext_attrib_values_tbl

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
34: ,x_msg_data OUT NOCOPY VARCHAR2

Line 62: (p_Instance_Tbl IN csi_datastructures_pub.instance_cz_tbl

58: ,P_macd_action IN NUMBER
59: ,x_return_status OUT NOCOPY VARCHAR2);
60:
61: Procedure Populate_new_to_old
62: (p_Instance_Tbl IN csi_datastructures_pub.instance_cz_tbl
63: ,x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_cz_tbl)
64: IS
65:
66: BEGIN

Line 63: ,x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_cz_tbl)

59: ,x_return_status OUT NOCOPY VARCHAR2);
60:
61: Procedure Populate_new_to_old
62: (p_Instance_Tbl IN csi_datastructures_pub.instance_cz_tbl
63: ,x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_cz_tbl)
64: IS
65:
66: BEGIN
67:

Line 1402: , p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl

1398:
1399: PROCEDURE populate_tso_order_lines
1400: ( p_header_id IN NUMBER
1401: , p_top_model_line_id IN NUMBER
1402: , p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
1403: , p_mode IN NUMBER
1404: , x_msg_data OUT NOCOPY VARCHAR2
1405: , x_msg_count OUT NOCOPY NUMBER
1406: , x_return_status OUT NOCOPY VARCHAR2

Line 1435: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;

1431: l_config_creation_date DATE;
1432: l_config_model_lookup_date DATE;
1433: l_config_date DATE;
1434: l_config_effective_date DATE;
1435: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;
1436: BEGIN
1437:
1438: Print_Time ('Entering OE_CONFIG_TSO_PVT.populate_tso_order_lines...');
1439: l_debug_level := oe_debug_pub.g_debug_level;

Line 1922: p_Instance_Tbl IN csi_datastructures_pub.instance_cz_tbl,

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

Line 1923: p_Extended_Attrib_Tbl IN csi_datastructures_pub.ext_attrib_values_tbl,

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

Line 1934: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;

1930:
1931: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1932: l_perform_action BOOLEAN;
1933: l_header_id NUMBER;
1934: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;
1935:
1936: CURSOR Models is
1937: SELECT line_id
1938: FROM oe_order_lines_all

Line 2390: , p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl

2386:
2387: PROCEDURE Create_TSO_Order_Lines
2388: ( p_header_id IN NUMBER
2389: , p_top_model_line_id IN NUMBER
2390: , p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
2391: , x_msg_data OUT NOCOPY VARCHAR2
2392: , x_msg_count OUT NOCOPY NUMBER
2393: , x_return_status OUT NOCOPY VARCHAR2
2394: )

Line 2405: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;

2401: l_top_model_line_id NUMBER;
2402: J NUMBER;
2403: I NUMBER;
2404:
2405: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2406: l_parent_exists_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2407: l_no_parent_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2408: l_Temp_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2409:

Line 2406: l_parent_exists_instance_tbl csi_datastructures_pub.instance_cz_tbl;

2402: J NUMBER;
2403: I NUMBER;
2404:
2405: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2406: l_parent_exists_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2407: l_no_parent_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2408: l_Temp_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2409:
2410: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2407: l_no_parent_instance_tbl csi_datastructures_pub.instance_cz_tbl;

2403: I NUMBER;
2404:
2405: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2406: l_parent_exists_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2407: l_no_parent_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2408: l_Temp_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2409:
2410: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2411: Begin

Line 2408: l_Temp_instance_tbl csi_datastructures_pub.instance_cz_tbl;

2404:
2405: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2406: l_parent_exists_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2407: l_no_parent_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2408: l_Temp_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2409:
2410: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2411: Begin
2412:

Line 2582: ,p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl

2578: the data in cz extended table as well. */
2579:
2580: PROCEDURE Populate_MACD_action(
2581: p_header_id IN NUMBER
2582: ,p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
2583: ,p_x_Line_Tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2584: ,p_Extended_Attrib_Tbl IN csi_datastructures_pub.ext_attrib_values_tbl
2585: ,p_macd_action IN VARCHAR2
2586: -- ,x_config_item_tbl OUT NOCOPY CZ_API_PUB.config_tbl_type;

Line 2584: ,p_Extended_Attrib_Tbl IN csi_datastructures_pub.ext_attrib_values_tbl

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

Line 2594: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;

2590: ,x_return_status OUT NOCOPY VARCHAR2)
2591:
2592: IS
2593:
2594: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2595: l_parent_exists_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2596: l_no_parent_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2597: l_config_item_rec CZ_CF_API.config_item_rec_type;
2598: l_config_item_tbl CZ_CF_API.config_item_tbl_type;

Line 2595: l_parent_exists_instance_tbl csi_datastructures_pub.instance_cz_tbl;

2591:
2592: IS
2593:
2594: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2595: l_parent_exists_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2596: l_no_parent_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2597: l_config_item_rec CZ_CF_API.config_item_rec_type;
2598: l_config_item_tbl CZ_CF_API.config_item_tbl_type;
2599: l_config_attr_rec CZ_CF_API.config_ext_attr_rec_type;

Line 2596: l_no_parent_instance_tbl csi_datastructures_pub.instance_cz_tbl;

2592: IS
2593:
2594: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2595: l_parent_exists_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2596: l_no_parent_instance_tbl csi_datastructures_pub.instance_cz_tbl;
2597: l_config_item_rec CZ_CF_API.config_item_rec_type;
2598: l_config_item_tbl CZ_CF_API.config_item_tbl_type;
2599: l_config_attr_rec CZ_CF_API.config_ext_attr_rec_type;
2600: l_config_attr_tbl CZ_CF_API.config_ext_attr_tbl_type;