APPS.ASO_QUOTE_PUB_W1 dependencies on FND_API

Line 16: a number := fnd_api.g_miss_num;

12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_QUOTE_PUB_W2';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ASOVQW2B.PLS';
14:
15: FUNCTION rosetta_g_miss_num_map(n number) RETURN number as
16: a number := fnd_api.g_miss_num;
17: b number := 0-1962.0724;
18: BEGIN
19: IF n=a THEN RETURN b; END IF;
20: IF n=b THEN RETURN a; END IF;

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

74: x_atp_postal_code OUT NOCOPY jtf_varchar2_table_600,
75: x_atp_match_item_id OUT NOCOPY jtf_number_table,
76:
77: /* parameters for the quote header record */
78: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
79: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
80: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

75: x_atp_match_item_id OUT NOCOPY jtf_number_table,
76:
77: /* parameters for the quote header record */
78: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
79: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
80: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
83: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

76:
77: /* parameters for the quote header record */
78: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
79: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
80: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
83: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,

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

77: /* parameters for the quote header record */
78: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
79: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
80: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
83: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,

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

78: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
79: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
80: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
83: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
86: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,

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

79: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
80: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
83: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
86: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
87: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,

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

80: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
81: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
83: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
86: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
87: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
88: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,

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

81: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
82: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
83: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
86: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
87: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
88: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

82: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
83: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
86: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
87: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
88: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,

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

83: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
84: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
86: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
87: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
88: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,

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

84: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
86: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
87: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
88: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
92: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,

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

85: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
86: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
87: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
88: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
92: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

86: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
87: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
88: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
92: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,

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

87: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
88: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
92: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
95: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,

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

88: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
92: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
95: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
96: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

89: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
92: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
95: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
96: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

90: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
91: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
92: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
95: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
96: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,

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

91: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
92: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
95: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
96: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

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

92: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
95: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
96: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,

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

93: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
95: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
96: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,

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

94: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
95: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
96: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

95: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
96: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 100: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,

96: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

97: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

98: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
99: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

99: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
100: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,

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

100: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
101: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
108: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,

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

101: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
108: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

102: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
108: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

103: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
108: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,

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

104: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
108: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,

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

105: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
108: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
113: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,

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

106: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
108: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
113: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
114: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,

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

107: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
108: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
113: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
114: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
115: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,

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

108: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
109: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
113: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
114: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
115: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,

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

109: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
113: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
114: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
115: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,

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

110: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
113: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
114: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
115: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
118: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,

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

111: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
112: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
113: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
114: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
115: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
118: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
119: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,

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

112: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
113: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
114: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
115: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
118: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
119: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,

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

113: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
114: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
115: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
118: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
119: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

114: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
115: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
118: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
119: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,

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

115: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
116: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
118: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
119: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
123: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

116: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
117: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
118: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
119: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
123: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

117: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
118: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
119: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
123: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

118: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
119: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
123: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,

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

119: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
123: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

120: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
121: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
123: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

121: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
123: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

122: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
123: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

123: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

124: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 129: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

125: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

126: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
127: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

127: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

128: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

129: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

130: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

131: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

132: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

133: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

134: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

135: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

136: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

137: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

138: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

139: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

140: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

141: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

142: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

143: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,

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

144: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
152: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,

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

145: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
152: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,

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

146: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
152: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

147: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
152: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

148: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
152: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

149: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
152: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

150: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
152: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

151: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
152: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

152: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

153: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
154: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

154: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

155: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

156: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

157: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,

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

158: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

159: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,

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

160: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

161: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

162: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

163: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,

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

164: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

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

165: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
166: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

166: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

167: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

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

168: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,

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

169: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,

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

170: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,

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

171: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
179: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

172: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
179: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,

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

173: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
179: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,

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

174: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
179: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
182: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,

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

175: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
179: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
182: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
183: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,

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

176: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
179: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
182: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
183: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
184: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,

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

177: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
179: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
182: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
183: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
184: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
185: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 182: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,

178: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
179: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
182: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
183: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
184: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
185: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 183: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,

179: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
182: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
183: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
184: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
185: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,

Line 184: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,

180: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
181: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
182: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
183: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
184: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
185: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,

Line 185: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,

181: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
182: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
183: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
184: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
185: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
189: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 186: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

182: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
183: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
184: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
185: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
189: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 187: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,

183: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
184: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
185: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
189: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 188: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,

184: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
185: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
189: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,

Line 189: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,

185: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
189: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
193: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 190: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

186: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
189: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
193: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 191: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

187: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
189: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
193: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 192: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,

188: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
189: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
193: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 193: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,

189: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
193: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,

Line 194: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,

190: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
193: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
198: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,

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

191: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
193: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
198: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
199: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

192: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
193: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
198: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
199: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,

Line 197: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,

193: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
198: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
199: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
201: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,

Line 198: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,

194: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
198: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
199: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
201: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
202: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 199: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

195: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
198: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
199: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
201: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
202: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,

Line 200: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,

196: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
198: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
199: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
201: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
202: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
204: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 201: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,

197: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
198: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
199: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
201: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
202: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
204: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,

Line 202: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,

198: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
199: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
201: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
202: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
204: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
206: p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 203: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,

199: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
201: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
202: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
204: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
206: p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,

Line 204: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,

200: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
201: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
202: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
204: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
206: p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
208: p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

Line 205: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,

201: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
202: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
204: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
206: p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
208: p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 206: p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,

202: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
204: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
206: p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
208: p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 207: p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,

203: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
204: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
206: p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
208: p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 208: p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

204: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
206: p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
208: p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 209: p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,

205: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
206: p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
208: p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 210: p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

206: p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
208: p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

Line 211: p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

207: p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
208: p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
215:

Line 212: p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,

208: p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
215:
216: /* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */

Line 213: p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

209: p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
215:
216: /* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */
217: p_ql_creation_date IN jtf_date_table := NULL,

Line 214: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

210: p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
215:
216: /* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */
217: p_ql_creation_date IN jtf_date_table := NULL,
218: p_ql_created_by IN jtf_number_table := NULL,

Line 374: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,

370: p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
371: p_qls_object_version_number IN jtf_number_table := NULL,
372: /* Standard IN parameters */
373: P_API_VERSION_NUMBER IN NUMBER := 1,
374: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,
375: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
376:
377: /* Standard OUT parameters */
378: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 375: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

371: p_qls_object_version_number IN jtf_number_table := NULL,
372: /* Standard IN parameters */
373: P_API_VERSION_NUMBER IN NUMBER := 1,
374: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,
375: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
376:
377: /* Standard OUT parameters */
378: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
379: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 856: p_init_msg_list => FND_API.G_FALSE,

852:
853: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
854: (
855: p_api_version => 1.0,
856: p_init_msg_list => FND_API.G_FALSE,
857: x_return_status => x_return_status,
858: x_msg_count => x_msg_count,
859: x_msg_data => x_msg_data,
860: p_channel_code => p_instr_channel_code,