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_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 1923: p_Instance_Tbl IN csi_datastructures_pub.instance_cz_tbl,

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,
1927: x_return_status OUT NOCOPY VARCHAR2,

Line 1924: p_Extended_Attrib_Tbl IN csi_datastructures_pub.ext_attrib_values_tbl,

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,
1927: x_return_status OUT NOCOPY VARCHAR2,
1928: x_msg_count OUT NOCOPY VARCHAR2,

Line 1935: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;

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

Line 2391: , p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl

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

Line 2406: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;

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

Line 2407: l_parent_exists_instance_tbl csi_datastructures_pub.instance_cz_tbl;

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

Line 2408: l_no_parent_instance_tbl csi_datastructures_pub.instance_cz_tbl;

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

Line 2409: l_Temp_instance_tbl csi_datastructures_pub.instance_cz_tbl;

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

Line 2583: ,p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl

2579: the data in cz extended table as well. */
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;

Line 2585: ,p_Extended_Attrib_Tbl IN csi_datastructures_pub.ext_attrib_values_tbl

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

Line 2595: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;

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

Line 2596: l_parent_exists_instance_tbl csi_datastructures_pub.instance_cz_tbl;

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

Line 2597: l_no_parent_instance_tbl csi_datastructures_pub.instance_cz_tbl;

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