DBA Data[Home] [Help]

APPS.ASO_CFG_INT dependencies on FND_API

Line 15: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR ,

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 ,

Line 16: quote_line_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 ,

Line 17: quote_line_detail_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 ,

Line 18: parent_config_item_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 ,

Line 19: config_item_id NUMBER := FND_API.G_MISS_NUM ,

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 ,

Line 20: inventory_item_id 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 ,

Line 21: organization_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 ,
25: included_flag VARCHAR2(1) := 'N' ,

Line 22: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR ,

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' ,

Line 23: quantity 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' ,
27: complete_configuration_flag VARCHAR2(1) := FND_API.G_MISS_CHAR ,

Line 24: uom_code VARCHAR2(3) := 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 ) ;

Line 27: complete_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 ;

Line 28: valid_configuration_flag VARCHAR2(1) := FND_API.G_MISS_CHAR ) ;

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:

Line 43: (new_config_flag VARCHAR2(1) DEFAULT FND_API.G_TRUE ,

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;

Line 50: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 51: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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 ,

Line 52: p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 62: P_Init_msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 72: P_Init_msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 82: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 89: p_autonomous_flag IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 103: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 159: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,

155: );
156:
157:
158: PROCEDURE Validate_Configuration
159: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
160: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
161: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_control_rec IN aso_quote_pub.control_rec_type
163: := aso_quote_pub.G_MISS_control_rec,

Line 160: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

156:
157:
158: PROCEDURE Validate_Configuration
159: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
160: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
161: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_control_rec IN aso_quote_pub.control_rec_type
163: := aso_quote_pub.G_MISS_control_rec,
164: P_model_line_id IN NUMBER,

Line 161: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

157:
158: PROCEDURE Validate_Configuration
159: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
160: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
161: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_control_rec IN aso_quote_pub.control_rec_type
163: := aso_quote_pub.G_MISS_control_rec,
164: P_model_line_id IN NUMBER,
165: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type