11: G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12:
13:
14: TYPE rtln_rec_type IS RECORD(
15: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR ,
16: quote_line_id NUMBER := FND_API.G_MISS_NUM ,
17: quote_line_detail_id NUMBER := FND_API.G_MISS_NUM ,
18: parent_config_item_id NUMBER := FND_API.G_MISS_NUM ,
19: config_item_id NUMBER := FND_API.G_MISS_NUM ,
12:
13:
14: TYPE rtln_rec_type IS RECORD(
15: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR ,
16: quote_line_id NUMBER := FND_API.G_MISS_NUM ,
17: quote_line_detail_id NUMBER := FND_API.G_MISS_NUM ,
18: parent_config_item_id NUMBER := FND_API.G_MISS_NUM ,
19: config_item_id NUMBER := FND_API.G_MISS_NUM ,
20: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
13:
14: TYPE rtln_rec_type IS RECORD(
15: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR ,
16: quote_line_id NUMBER := FND_API.G_MISS_NUM ,
17: quote_line_detail_id NUMBER := FND_API.G_MISS_NUM ,
18: parent_config_item_id NUMBER := FND_API.G_MISS_NUM ,
19: config_item_id NUMBER := FND_API.G_MISS_NUM ,
20: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
21: organization_id NUMBER := FND_API.G_MISS_NUM ,
14: TYPE rtln_rec_type IS RECORD(
15: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR ,
16: quote_line_id NUMBER := FND_API.G_MISS_NUM ,
17: quote_line_detail_id NUMBER := FND_API.G_MISS_NUM ,
18: parent_config_item_id NUMBER := FND_API.G_MISS_NUM ,
19: config_item_id NUMBER := FND_API.G_MISS_NUM ,
20: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
21: organization_id NUMBER := FND_API.G_MISS_NUM ,
22: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR ,
15: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR ,
16: quote_line_id NUMBER := FND_API.G_MISS_NUM ,
17: quote_line_detail_id NUMBER := FND_API.G_MISS_NUM ,
18: parent_config_item_id NUMBER := FND_API.G_MISS_NUM ,
19: config_item_id NUMBER := FND_API.G_MISS_NUM ,
20: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
21: organization_id NUMBER := FND_API.G_MISS_NUM ,
22: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR ,
23: quantity NUMBER := FND_API.G_MISS_NUM ,
16: quote_line_id NUMBER := FND_API.G_MISS_NUM ,
17: quote_line_detail_id NUMBER := FND_API.G_MISS_NUM ,
18: parent_config_item_id NUMBER := FND_API.G_MISS_NUM ,
19: config_item_id NUMBER := FND_API.G_MISS_NUM ,
20: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
21: organization_id NUMBER := FND_API.G_MISS_NUM ,
22: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR ,
23: quantity NUMBER := FND_API.G_MISS_NUM ,
24: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR ,
17: quote_line_detail_id NUMBER := FND_API.G_MISS_NUM ,
18: parent_config_item_id NUMBER := FND_API.G_MISS_NUM ,
19: config_item_id NUMBER := FND_API.G_MISS_NUM ,
20: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
21: organization_id NUMBER := FND_API.G_MISS_NUM ,
22: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR ,
23: quantity NUMBER := FND_API.G_MISS_NUM ,
24: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR ,
25: included_flag VARCHAR2(1) := 'N' ,
18: parent_config_item_id NUMBER := FND_API.G_MISS_NUM ,
19: config_item_id NUMBER := FND_API.G_MISS_NUM ,
20: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
21: organization_id NUMBER := FND_API.G_MISS_NUM ,
22: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR ,
23: quantity NUMBER := FND_API.G_MISS_NUM ,
24: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR ,
25: included_flag VARCHAR2(1) := 'N' ,
26: created_flag VARCHAR2(1) := 'N' ,
19: config_item_id NUMBER := FND_API.G_MISS_NUM ,
20: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
21: organization_id NUMBER := FND_API.G_MISS_NUM ,
22: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR ,
23: quantity NUMBER := FND_API.G_MISS_NUM ,
24: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR ,
25: included_flag VARCHAR2(1) := 'N' ,
26: created_flag VARCHAR2(1) := 'N' ,
27: complete_configuration_flag VARCHAR2(1) := FND_API.G_MISS_CHAR ,
20: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
21: organization_id NUMBER := FND_API.G_MISS_NUM ,
22: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR ,
23: quantity NUMBER := FND_API.G_MISS_NUM ,
24: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR ,
25: included_flag VARCHAR2(1) := 'N' ,
26: created_flag VARCHAR2(1) := 'N' ,
27: complete_configuration_flag VARCHAR2(1) := FND_API.G_MISS_CHAR ,
28: valid_configuration_flag VARCHAR2(1) := FND_API.G_MISS_CHAR ) ;
23: quantity NUMBER := FND_API.G_MISS_NUM ,
24: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR ,
25: included_flag VARCHAR2(1) := 'N' ,
26: created_flag VARCHAR2(1) := 'N' ,
27: complete_configuration_flag VARCHAR2(1) := FND_API.G_MISS_CHAR ,
28: valid_configuration_flag VARCHAR2(1) := FND_API.G_MISS_CHAR ) ;
29:
30: TYPE rtln_tbl_type IS TABLE OF rtln_rec_type
31: INDEX BY BINARY_INTEGER ;
24: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR ,
25: included_flag VARCHAR2(1) := 'N' ,
26: created_flag VARCHAR2(1) := 'N' ,
27: complete_configuration_flag VARCHAR2(1) := FND_API.G_MISS_CHAR ,
28: valid_configuration_flag VARCHAR2(1) := FND_API.G_MISS_CHAR ) ;
29:
30: TYPE rtln_tbl_type IS TABLE OF rtln_rec_type
31: INDEX BY BINARY_INTEGER ;
32:
39: -- Type : Public
40: -- Pre-Req :
41:
42: TYPE Control_Rec_Type IS RECORD
43: (new_config_flag VARCHAR2(1) DEFAULT FND_API.G_TRUE ,
44: handle_deleted_flag VARCHAR2(1) DEFAULT NULL,
45: new_name VARCHAR2(240) DEFAULT NULL );
46:
47: G_MISS_Control_Rec Control_Rec_Type;
46:
47: G_MISS_Control_Rec Control_Rec_Type;
48:
49: PROCEDURE Get_configuration_lines(
50: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
51: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
52: p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
53: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
54: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
47: G_MISS_Control_Rec Control_Rec_Type;
48:
49: PROCEDURE Get_configuration_lines(
50: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
51: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
52: p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
53: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
54: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
55: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type ,
48:
49: PROCEDURE Get_configuration_lines(
50: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
51: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
52: p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
53: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
54: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
55: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type ,
56: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
58: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ) ;
59:
60: PROCEDURE Delete_configuration(
61: P_Api_version_NUmber IN NUMBER,
62: P_Init_msg_List IN VARCHAR2 := FND_API.G_FALSE,
63: P_config_hdr_id IN NUMBER,
64: p_config_rev_nbr IN NUMBER,
65: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
66: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
68:
69:
70: PROCEDURE Delete_configuration_auto(
71: P_Api_version_NUmber IN NUMBER,
72: P_Init_msg_List IN VARCHAR2 := FND_API.G_FALSE,
73: P_config_hdr_id IN NUMBER,
74: p_config_rev_nbr IN NUMBER,
75: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
76: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
77: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
78:
79:
80: Procedure Copy_Configuration( p_api_version_number IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE,
83: p_config_header_id IN NUMBER,
84: p_config_revision_num IN NUMBER,
85: p_copy_mode IN VARCHAR2,
78:
79:
80: Procedure Copy_Configuration( p_api_version_number IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE,
83: p_config_header_id IN NUMBER,
84: p_config_revision_num IN NUMBER,
85: p_copy_mode IN VARCHAR2,
86: p_handle_deleted_flag IN VARCHAR2 := NULL,
85: p_copy_mode IN VARCHAR2,
86: p_handle_deleted_flag IN VARCHAR2 := NULL,
87:
88: p_new_name IN VARCHAR2 := NULL,
89: p_autonomous_flag IN VARCHAR2 := FND_API.G_FALSE,
90: x_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
91: x_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
92: x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type,
93: x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type,
98:
99:
100: PROCEDURE get_config_details(
101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_control_rec IN aso_quote_pub.control_rec_type
105: := aso_quote_pub.G_MISS_control_rec,
106: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
99:
100: PROCEDURE get_config_details(
101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_control_rec IN aso_quote_pub.control_rec_type
105: := aso_quote_pub.G_MISS_control_rec,
106: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
107: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
156: );
157:
158:
159: PROCEDURE Validate_Configuration
160: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
161: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
163: p_control_rec IN aso_quote_pub.control_rec_type
164: := aso_quote_pub.G_MISS_control_rec,
157:
158:
159: PROCEDURE Validate_Configuration
160: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
161: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
163: p_control_rec IN aso_quote_pub.control_rec_type
164: := aso_quote_pub.G_MISS_control_rec,
165: P_model_line_id IN NUMBER,
158:
159: PROCEDURE Validate_Configuration
160: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
161: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
163: p_control_rec IN aso_quote_pub.control_rec_type
164: := aso_quote_pub.G_MISS_control_rec,
165: P_model_line_id IN NUMBER,
166: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type