2: /* $Header: asovqwcs.pls 120.2 2005/10/03 15:38:45 skulkarn ship $ */
3:
4: PROCEDURE Is_Container
5: (p_api_version IN NUMBER := 1 ,
6: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
7: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
8: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
9: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
10: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
3:
4: PROCEDURE Is_Container
5: (p_api_version IN NUMBER := 1 ,
6: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
7: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
8: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
9: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
10: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
11: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
4: PROCEDURE Is_Container
5: (p_api_version IN NUMBER := 1 ,
6: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
7: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
8: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
9: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
10: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
11: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_ap_usage_name IN VARCHAR2:= FND_API.G_MISS_CHAR ,
5: (p_api_version IN NUMBER := 1 ,
6: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
7: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
8: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
9: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
10: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
11: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_ap_usage_name IN VARCHAR2:= FND_API.G_MISS_CHAR ,
13: p_ap_publication_mode IN VARCHAR2:= FND_API.G_MISS_CHAR ,
6: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
7: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
8: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
9: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
10: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
11: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_ap_usage_name IN VARCHAR2:= FND_API.G_MISS_CHAR ,
13: p_ap_publication_mode IN VARCHAR2:= FND_API.G_MISS_CHAR ,
14: p_ap_language IN VARCHAR2:= FND_API.G_MISS_CHAR ,
7: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
8: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
9: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
10: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
11: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_ap_usage_name IN VARCHAR2:= FND_API.G_MISS_CHAR ,
13: p_ap_publication_mode IN VARCHAR2:= FND_API.G_MISS_CHAR ,
14: p_ap_language IN VARCHAR2:= FND_API.G_MISS_CHAR ,
15: x_return_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
8: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
9: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
10: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
11: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_ap_usage_name IN VARCHAR2:= FND_API.G_MISS_CHAR ,
13: p_ap_publication_mode IN VARCHAR2:= FND_API.G_MISS_CHAR ,
14: p_ap_language IN VARCHAR2:= FND_API.G_MISS_CHAR ,
15: x_return_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
16: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
9: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
10: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
11: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_ap_usage_name IN VARCHAR2:= FND_API.G_MISS_CHAR ,
13: p_ap_publication_mode IN VARCHAR2:= FND_API.G_MISS_CHAR ,
14: p_ap_language IN VARCHAR2:= FND_API.G_MISS_CHAR ,
15: x_return_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
16: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
17: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
10: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
11: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_ap_usage_name IN VARCHAR2:= FND_API.G_MISS_CHAR ,
13: p_ap_publication_mode IN VARCHAR2:= FND_API.G_MISS_CHAR ,
14: p_ap_language IN VARCHAR2:= FND_API.G_MISS_CHAR ,
15: x_return_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
16: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
17: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
18: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20:
21: PROCEDURE Get_Contained_Models
22: (x_model_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE ,
23: p_api_version IN NUMBER := 1 ,
24: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
27: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
28: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
21: PROCEDURE Get_Contained_Models
22: (x_model_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE ,
23: p_api_version IN NUMBER := 1 ,
24: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
27: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
28: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
22: (x_model_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE ,
23: p_api_version IN NUMBER := 1 ,
24: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
27: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
28: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
30: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
23: p_api_version IN NUMBER := 1 ,
24: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
27: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
28: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
30: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
31: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
24: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
27: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
28: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
30: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
31: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
32: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
25: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
27: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
28: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
30: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
31: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
32: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
33: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
26: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
27: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
28: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
30: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
31: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
32: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
33: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
34: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
27: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
28: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
30: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
31: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
32: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
33: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
34: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
35: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
30: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
31: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
32: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
33: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
34: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
35: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36: );
39: PROCEDURE Config_Operations
40: (x_q_quote_header_id OUT NOCOPY NUMBER,
41: x_q_last_update_date OUT NOCOPY DATE,
42: x_q_object_version_number OUT NOCOPY NUMBER,
43: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
44: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: (x_q_quote_header_id OUT NOCOPY NUMBER,
41: x_q_last_update_date OUT NOCOPY DATE,
42: x_q_object_version_number OUT NOCOPY NUMBER,
43: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
44: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: x_q_last_update_date OUT NOCOPY DATE,
42: x_q_object_version_number OUT NOCOPY NUMBER,
43: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
44: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: x_q_object_version_number OUT NOCOPY NUMBER,
43: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
44: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
44: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
54: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
62: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
55: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
62: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
56: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
62: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
57: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
62: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
65: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
58: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
62: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
65: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
66: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
59: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
62: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
65: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
66: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
62: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
65: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
66: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
62: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
65: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
66: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
69: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
62: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
65: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
66: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
69: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
70: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
65: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
66: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
69: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
70: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
65: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
66: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
69: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
70: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
65: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
66: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
69: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
70: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
73: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
66: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
69: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
70: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
73: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
74: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
68: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
69: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
70: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
73: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
74: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
69: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
70: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
73: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
74: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
69: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
70: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
73: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
74: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
77: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
70: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
73: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
74: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
77: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
78: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
73: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
74: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
77: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
78: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
73: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
74: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
77: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
78: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
73: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
74: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
77: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
78: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
74: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
77: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
78: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
77: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
78: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
77: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
78: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
78: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
86: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
94: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
87: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
94: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
95: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
88: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
94: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
95: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
89: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
94: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
95: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
90: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
94: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
95: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
94: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
95: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
92: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
94: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
95: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
93: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
94: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
95: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
95: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
95: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
103: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
103: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
97: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
103: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
105: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
103: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
105: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
103: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
105: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
103: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
105: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
103: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
105: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
103: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
105: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
105: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
105: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
129: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
129: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
130: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
129: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
130: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
131: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
129: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
130: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
131: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
129: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
130: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
131: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
129: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
130: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
131: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
129: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
130: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
131: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
129: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
130: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
131: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
130: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
131: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
131: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
135: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
137: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
141: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
142: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
148: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
156: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
156: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
150: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
156: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
158: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
151: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
156: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
158: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
159: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
152: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
156: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
158: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
159: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
160: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
156: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
158: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
159: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
160: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
161: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
156: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
158: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
159: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
160: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
161: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
156: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
158: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
159: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
160: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
161: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
158: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
159: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
160: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
161: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
157: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
158: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
159: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
160: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
161: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
158: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
159: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
160: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
161: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
160: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
161: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
161: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
163: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
164: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
167: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
175: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
168: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
175: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
176: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
175: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
176: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
175: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
176: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
171: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
175: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
176: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
179: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
175: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
176: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
179: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
173: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
175: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
176: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
179: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
175: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
176: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
179: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
175: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
176: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
179: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
183: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
176: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
179: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
183: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
184: p_ql_creation_date IN jtf_date_table := NULL,
177: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
179: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
183: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
184: p_ql_creation_date IN jtf_date_table := NULL,
185: p_ql_created_by IN jtf_number_table := NULL,
178: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
179: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
183: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
184: p_ql_creation_date IN jtf_date_table := NULL,
185: p_ql_created_by IN jtf_number_table := NULL,
186: p_ql_last_updated_by IN jtf_number_table := NULL,
179: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
183: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
184: p_ql_creation_date IN jtf_date_table := NULL,
185: p_ql_created_by IN jtf_number_table := NULL,
186: p_ql_last_updated_by IN jtf_number_table := NULL,
187: p_ql_last_update_date IN jtf_date_table := NULL,
254: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
255: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
256: p_i_instance_id IN JTF_NUMBER_TABLE := NULL ,
257: p_i_price_list_id IN JTF_NUMBER_TABLE := NULL ,
258: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_api_version_number IN NUMBER := 1 ,
260: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,
261: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
262: p_validation_level IN NUMBER := FND_API.G_MISS_NUM,
256: p_i_instance_id IN JTF_NUMBER_TABLE := NULL ,
257: p_i_price_list_id IN JTF_NUMBER_TABLE := NULL ,
258: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_api_version_number IN NUMBER := 1 ,
260: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,
261: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
262: p_validation_level IN NUMBER := FND_API.G_MISS_NUM,
263: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
264: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
257: p_i_price_list_id IN JTF_NUMBER_TABLE := NULL ,
258: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_api_version_number IN NUMBER := 1 ,
260: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,
261: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
262: p_validation_level IN NUMBER := FND_API.G_MISS_NUM,
263: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
264: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
265: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
258: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_api_version_number IN NUMBER := 1 ,
260: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,
261: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
262: p_validation_level IN NUMBER := FND_API.G_MISS_NUM,
263: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
264: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
265: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
266: );
266: );
267:
268:
269: FUNCTION Construct_Appl_Param_Rec(
270: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,
271: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
272: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
273: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
267:
268:
269: FUNCTION Construct_Appl_Param_Rec(
270: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,
271: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
272: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
273: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
268:
269: FUNCTION Construct_Appl_Param_Rec(
270: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,
271: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
272: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
273: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR
269: FUNCTION Construct_Appl_Param_Rec(
270: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,
271: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
272: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
273: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR
277: )
270: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,
271: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
272: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
273: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR
277: )
278: RETURN CZ_API_PUB.appl_param_rec_type;
271: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
272: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
273: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR
277: )
278: RETURN CZ_API_PUB.appl_param_rec_type;
279:
272: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
273: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR
277: )
278: RETURN CZ_API_PUB.appl_param_rec_type;
279:
280: END ASO_Config_Operations_Int_W;