DBA Data[Home] [Help]

APPS.IBE_QUOTE_W2_PVT dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

3:
4: PROCEDURE SAVE_SHARE_V2_WRAPPER
5: (
6: p_api_version_number IN NUMBER := 1 ,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9:
10: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
11: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

4: PROCEDURE SAVE_SHARE_V2_WRAPPER
5: (
6: p_api_version_number IN NUMBER := 1 ,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9:
10: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
11: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 10: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,

6: p_api_version_number IN NUMBER := 1 ,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9:
10: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
11: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 11: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

7: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9:
10: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
11: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 12: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

8: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9:
10: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
11: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 13: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,

9:
10: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
11: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_ssc_delete_source_cart IN VARCHAR2 := FND_API.G_TRUE ,

Line 14: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,

10: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
11: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_ssc_delete_source_cart IN VARCHAR2 := FND_API.G_TRUE ,
18: p_ssc_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 15: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

11: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_ssc_delete_source_cart IN VARCHAR2 := FND_API.G_TRUE ,
18: p_ssc_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_ssc_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 16: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

12: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_ssc_delete_source_cart IN VARCHAR2 := FND_API.G_TRUE ,
18: p_ssc_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_ssc_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 17: p_ssc_delete_source_cart IN VARCHAR2 := FND_API.G_TRUE ,

13: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_ssc_delete_source_cart IN VARCHAR2 := FND_API.G_TRUE ,
18: p_ssc_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_ssc_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
21:

Line 18: p_ssc_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,

14: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_ssc_delete_source_cart IN VARCHAR2 := FND_API.G_TRUE ,
18: p_ssc_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_ssc_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
21:
22: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,

Line 19: p_ssc_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

15: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_ssc_delete_source_cart IN VARCHAR2 := FND_API.G_TRUE ,
18: p_ssc_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_ssc_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
21:
22: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 20: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,

16: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_ssc_delete_source_cart IN VARCHAR2 := FND_API.G_TRUE ,
18: p_ssc_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_ssc_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
21:
22: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
24: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 22: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,

18: p_ssc_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_ssc_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
21:
22: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
24: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
25: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
26: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 23: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,

19: p_ssc_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
21:
22: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
24: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
25: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
26: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
27: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 24: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,

20: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
21:
22: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
24: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
25: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
26: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
27: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
28: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,

Line 25: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

21:
22: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
24: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
25: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
26: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
27: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
28: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 26: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,

22: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
24: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
25: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
26: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
27: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
28: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,

Line 27: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

23: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
24: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
25: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
26: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
27: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
28: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
31: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,

Line 28: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,

24: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
25: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
26: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
27: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
28: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
31: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
32: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,

Line 29: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,

25: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
26: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
27: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
28: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
31: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
32: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
33: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 30: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,

26: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
27: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
28: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
31: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
32: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
33: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,

Line 31: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,

27: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
28: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
31: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
32: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
33: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
35: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,

Line 32: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,

28: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
31: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
32: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
33: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
35: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
36: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 33: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

29: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
31: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
32: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
33: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
35: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
36: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 34: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,

30: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
31: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
32: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
33: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
35: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
36: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,

Line 35: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,

31: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
32: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
33: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
35: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
36: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
39: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,

Line 36: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,

32: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
33: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
35: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
36: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
39: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
40: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 37: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

33: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
35: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
36: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
39: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
40: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 38: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,

34: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
35: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
36: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
39: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
40: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 39: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,

35: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
36: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
39: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
40: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

Line 40: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,

36: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
37: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
39: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
40: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

Line 41: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,

37: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
39: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
40: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,

Line 42: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,

38: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
39: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
40: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 43: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

39: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
40: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 44: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

40: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 45: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,

41: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 46: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

42: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 47: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

43: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,

Line 48: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

44: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,

Line 49: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

45: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 50: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

46: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 51: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,

47: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,

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

48: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
56: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,

Line 53: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

49: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
56: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
57: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,

Line 54: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

50: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
56: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
57: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
58: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,

Line 55: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,

51: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
56: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
57: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
58: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
59: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,

Line 56: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,

52: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
56: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
57: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
58: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
59: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
60: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,

Line 57: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,

53: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
56: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
57: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
58: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
59: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
60: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,

Line 58: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,

54: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
56: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
57: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
58: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
59: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
60: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
62: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,

Line 59: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,

55: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
56: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
57: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
58: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
59: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
60: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
62: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,

Line 60: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,

56: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
57: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
58: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
59: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
60: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
62: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,

Line 61: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,

57: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
58: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
59: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
60: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
62: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
65: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 62: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,

58: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
59: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
60: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
62: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
65: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,

Line 63: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,

59: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
60: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
62: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
65: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
67: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 64: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,

60: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
61: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
62: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
65: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
67: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 65: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

61: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
62: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
65: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
67: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 66: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,

62: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
63: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
65: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
67: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,

Line 67: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

63: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
65: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
67: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 68: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

64: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
65: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
67: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 69: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

65: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
67: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 70: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,

66: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
67: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: -- bug 6873117 mgiridha added attribute 16-20

Line 71: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

67: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: -- bug 6873117 mgiridha added attribute 16-20
75: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 72: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

68: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: -- bug 6873117 mgiridha added attribute 16-20
75: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 73: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

69: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
71: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: -- bug 6873117 mgiridha added attribute 16-20
75: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 75: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

71: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: -- bug 6873117 mgiridha added attribute 16-20
75: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 76: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

72: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: -- bug 6873117 mgiridha added attribute 16-20
75: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 77: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

73: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: -- bug 6873117 mgiridha added attribute 16-20
75: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 78: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

74: -- bug 6873117 mgiridha added attribute 16-20
75: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 79: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

75: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 80: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

76: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 81: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

77: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 82: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,

78: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 83: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,

79: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 84: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,

80: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 85: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,

81: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 86: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

82: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 87: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,

83: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 88: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

84: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 89: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

85: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 90: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

86: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 91: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

87: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,

Line 92: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

88: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,

Line 93: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

89: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,

Line 94: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

90: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 95: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,

91: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 96: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,

92: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 97: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,

93: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 98: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

94: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 99: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

95: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 100: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

96: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 101: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

97: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 102: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,

98: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 103: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

99: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 104: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

100: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 105: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

101: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 106: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

102: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 107: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,

103: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,

Line 108: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,

104: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 109: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,

105: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 110: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

106: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 111: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,

107: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,

Line 112: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

108: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

Line 113: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,

109: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 114: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,

110: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 115: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,

111: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

Line 116: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

112: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 117: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

113: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,

Line 118: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

114: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,

Line 119: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

115: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
123: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 120: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,

116: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
123: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,

Line 121: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,

117: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
123: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
125: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,

Line 122: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,

118: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
123: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
125: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
126: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,

Line 123: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

119: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
123: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
125: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
126: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 124: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,

120: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
123: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
125: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
126: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 125: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,

121: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
123: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
125: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
126: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
129:

Line 126: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,

122: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
123: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
125: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
126: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
129:
130: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,

Line 127: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,

123: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
125: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
126: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
129:
130: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
131: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,

Line 128: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,

124: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
125: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
126: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
129:
130: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
131: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
132: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,

Line 154: p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,

150: p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,
151: p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,
152: p_qsh_email_address JTF_VARCHAR2_TABLE_2000 :=NULL,
153: p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL,
154: p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_party_id NUMBER := FND_API.G_MISS_NUM,
156: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
157: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
158: P_minisite_id NUMBER := FND_API.G_MISS_NUM,

Line 155: p_party_id NUMBER := FND_API.G_MISS_NUM,

151: p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,
152: p_qsh_email_address JTF_VARCHAR2_TABLE_2000 :=NULL,
153: p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL,
154: p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_party_id NUMBER := FND_API.G_MISS_NUM,
156: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
157: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
158: P_minisite_id NUMBER := FND_API.G_MISS_NUM,
159: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,

Line 156: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,

152: p_qsh_email_address JTF_VARCHAR2_TABLE_2000 :=NULL,
153: p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL,
154: p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_party_id NUMBER := FND_API.G_MISS_NUM,
156: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
157: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
158: P_minisite_id NUMBER := FND_API.G_MISS_NUM,
159: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
160: P_source_last_update_date DATE := FND_API.G_MISS_DATE,

Line 157: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,

153: p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL,
154: p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_party_id NUMBER := FND_API.G_MISS_NUM,
156: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
157: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
158: P_minisite_id NUMBER := FND_API.G_MISS_NUM,
159: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
160: P_source_last_update_date DATE := FND_API.G_MISS_DATE,
161: p_URL VARCHAR2 := FND_API.G_MISS_CHAR,

Line 158: P_minisite_id NUMBER := FND_API.G_MISS_NUM,

154: p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_party_id NUMBER := FND_API.G_MISS_NUM,
156: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
157: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
158: P_minisite_id NUMBER := FND_API.G_MISS_NUM,
159: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
160: P_source_last_update_date DATE := FND_API.G_MISS_DATE,
161: p_URL VARCHAR2 := FND_API.G_MISS_CHAR,
162: x_return_status OUT NOCOPY VARCHAR2 ,

Line 159: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,

155: p_party_id NUMBER := FND_API.G_MISS_NUM,
156: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
157: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
158: P_minisite_id NUMBER := FND_API.G_MISS_NUM,
159: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
160: P_source_last_update_date DATE := FND_API.G_MISS_DATE,
161: p_URL VARCHAR2 := FND_API.G_MISS_CHAR,
162: x_return_status OUT NOCOPY VARCHAR2 ,
163: x_msg_count OUT NOCOPY NUMBER ,

Line 160: P_source_last_update_date DATE := FND_API.G_MISS_DATE,

156: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
157: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
158: P_minisite_id NUMBER := FND_API.G_MISS_NUM,
159: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
160: P_source_last_update_date DATE := FND_API.G_MISS_DATE,
161: p_URL VARCHAR2 := FND_API.G_MISS_CHAR,
162: x_return_status OUT NOCOPY VARCHAR2 ,
163: x_msg_count OUT NOCOPY NUMBER ,
164: x_msg_data OUT NOCOPY VARCHAR2 ) ;

Line 161: p_URL VARCHAR2 := FND_API.G_MISS_CHAR,

157: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
158: P_minisite_id NUMBER := FND_API.G_MISS_NUM,
159: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
160: P_source_last_update_date DATE := FND_API.G_MISS_DATE,
161: p_URL VARCHAR2 := FND_API.G_MISS_CHAR,
162: x_return_status OUT NOCOPY VARCHAR2 ,
163: x_msg_count OUT NOCOPY NUMBER ,
164: x_msg_data OUT NOCOPY VARCHAR2 ) ;
165: