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:
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;
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
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
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:
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
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;
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,
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,
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
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: )
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:
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;
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
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:
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;
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
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;
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;
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;