APPS.IBE_QUOTE_W2_PVT dependencies on JTF_NUMBER_TABLE

Line 107: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,

103: END;
104:
105: FUNCTION construct_quote_access_tbl(
106: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
107: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
108: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
109: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
110: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
111: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,

Line 108: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,

104:
105: FUNCTION construct_quote_access_tbl(
106: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
107: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
108: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
109: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
110: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
111: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
112: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,

Line 109: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,

105: FUNCTION construct_quote_access_tbl(
106: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
107: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
108: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
109: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
110: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
111: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
112: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
113: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,

Line 110: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,

106: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
107: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
108: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
109: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
110: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
111: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
112: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
113: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
114: p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,

Line 112: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,

108: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
109: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
110: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
111: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
112: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
113: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
114: p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
115: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
116: p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,

Line 113: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,

109: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
110: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
111: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
112: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
113: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
114: p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
115: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
116: p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
117: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,

Line 115: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,

111: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
112: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
113: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
114: p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
115: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
116: p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
117: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
118: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
119: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,

Line 117: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,

113: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
114: p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
115: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
116: p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
117: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
118: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
119: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
120: p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
121: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,

Line 118: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,

114: p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
115: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
116: p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
117: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
118: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
119: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
120: p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
121: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
122: p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,

Line 119: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,

115: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
116: p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
117: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
118: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
119: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
120: p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
121: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
122: p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
123: p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,

Line 121: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,

117: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
118: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
119: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
120: p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
121: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
122: p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
123: p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
124: p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
125: p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,

Line 122: p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,

118: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
119: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
120: p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
121: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
122: p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
123: p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
124: p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
125: p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
126: p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,

Line 123: p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,

119: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
120: p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
121: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
122: p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
123: p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
124: p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
125: p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
126: p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,
127: p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,

Line 127: p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,

123: p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
124: p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
125: p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
126: p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,
127: p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,
128: p_qsh_EMAIL_ADDRESS JTF_VARCHAR2_TABLE_2000 :=NULL,
129: p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL)
130: RETURN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE IS
131:

Line 268: p_qte_line_index IN jtf_number_table := NULL,

264:
265:
266: FUNCTION construct_sales_credit_tbl(
267: p_operation_code IN jtf_varchar2_table_100 := NULL,
268: p_qte_line_index IN jtf_number_table := NULL,
269: p_sales_credit_id IN jtf_number_table := NULL,
270: p_creation_date IN jtf_date_table := NULL,
271: p_created_by IN jtf_number_table := NULL,
272: p_last_updated_by IN jtf_number_table := NULL,

Line 269: p_sales_credit_id IN jtf_number_table := NULL,

265:
266: FUNCTION construct_sales_credit_tbl(
267: p_operation_code IN jtf_varchar2_table_100 := NULL,
268: p_qte_line_index IN jtf_number_table := NULL,
269: p_sales_credit_id IN jtf_number_table := NULL,
270: p_creation_date IN jtf_date_table := NULL,
271: p_created_by IN jtf_number_table := NULL,
272: p_last_updated_by IN jtf_number_table := NULL,
273: p_last_update_date IN jtf_date_table := NULL,

Line 271: p_created_by IN jtf_number_table := NULL,

267: p_operation_code IN jtf_varchar2_table_100 := NULL,
268: p_qte_line_index IN jtf_number_table := NULL,
269: p_sales_credit_id IN jtf_number_table := NULL,
270: p_creation_date IN jtf_date_table := NULL,
271: p_created_by IN jtf_number_table := NULL,
272: p_last_updated_by IN jtf_number_table := NULL,
273: p_last_update_date IN jtf_date_table := NULL,
274: p_last_update_login IN jtf_number_table := NULL,
275: p_request_id IN jtf_number_table := NULL,

Line 272: p_last_updated_by IN jtf_number_table := NULL,

268: p_qte_line_index IN jtf_number_table := NULL,
269: p_sales_credit_id IN jtf_number_table := NULL,
270: p_creation_date IN jtf_date_table := NULL,
271: p_created_by IN jtf_number_table := NULL,
272: p_last_updated_by IN jtf_number_table := NULL,
273: p_last_update_date IN jtf_date_table := NULL,
274: p_last_update_login IN jtf_number_table := NULL,
275: p_request_id IN jtf_number_table := NULL,
276: p_program_application_id IN jtf_number_table := NULL,

Line 274: p_last_update_login IN jtf_number_table := NULL,

270: p_creation_date IN jtf_date_table := NULL,
271: p_created_by IN jtf_number_table := NULL,
272: p_last_updated_by IN jtf_number_table := NULL,
273: p_last_update_date IN jtf_date_table := NULL,
274: p_last_update_login IN jtf_number_table := NULL,
275: p_request_id IN jtf_number_table := NULL,
276: p_program_application_id IN jtf_number_table := NULL,
277: p_program_id IN jtf_number_table := NULL,
278: p_program_update_date IN jtf_date_table := NULL,

Line 275: p_request_id IN jtf_number_table := NULL,

271: p_created_by IN jtf_number_table := NULL,
272: p_last_updated_by IN jtf_number_table := NULL,
273: p_last_update_date IN jtf_date_table := NULL,
274: p_last_update_login IN jtf_number_table := NULL,
275: p_request_id IN jtf_number_table := NULL,
276: p_program_application_id IN jtf_number_table := NULL,
277: p_program_id IN jtf_number_table := NULL,
278: p_program_update_date IN jtf_date_table := NULL,
279: p_quote_header_id IN jtf_number_table := NULL,

Line 276: p_program_application_id IN jtf_number_table := NULL,

272: p_last_updated_by IN jtf_number_table := NULL,
273: p_last_update_date IN jtf_date_table := NULL,
274: p_last_update_login IN jtf_number_table := NULL,
275: p_request_id IN jtf_number_table := NULL,
276: p_program_application_id IN jtf_number_table := NULL,
277: p_program_id IN jtf_number_table := NULL,
278: p_program_update_date IN jtf_date_table := NULL,
279: p_quote_header_id IN jtf_number_table := NULL,
280: p_quote_line_id IN jtf_number_table := NULL,

Line 277: p_program_id IN jtf_number_table := NULL,

273: p_last_update_date IN jtf_date_table := NULL,
274: p_last_update_login IN jtf_number_table := NULL,
275: p_request_id IN jtf_number_table := NULL,
276: p_program_application_id IN jtf_number_table := NULL,
277: p_program_id IN jtf_number_table := NULL,
278: p_program_update_date IN jtf_date_table := NULL,
279: p_quote_header_id IN jtf_number_table := NULL,
280: p_quote_line_id IN jtf_number_table := NULL,
281: p_percent IN jtf_number_table := NULL,

Line 279: p_quote_header_id IN jtf_number_table := NULL,

275: p_request_id IN jtf_number_table := NULL,
276: p_program_application_id IN jtf_number_table := NULL,
277: p_program_id IN jtf_number_table := NULL,
278: p_program_update_date IN jtf_date_table := NULL,
279: p_quote_header_id IN jtf_number_table := NULL,
280: p_quote_line_id IN jtf_number_table := NULL,
281: p_percent IN jtf_number_table := NULL,
282: p_resource_id IN jtf_number_table := NULL,
283: p_sales_credit_type IN jtf_varchar2_table_300 := NULL,

Line 280: p_quote_line_id IN jtf_number_table := NULL,

276: p_program_application_id IN jtf_number_table := NULL,
277: p_program_id IN jtf_number_table := NULL,
278: p_program_update_date IN jtf_date_table := NULL,
279: p_quote_header_id IN jtf_number_table := NULL,
280: p_quote_line_id IN jtf_number_table := NULL,
281: p_percent IN jtf_number_table := NULL,
282: p_resource_id IN jtf_number_table := NULL,
283: p_sales_credit_type IN jtf_varchar2_table_300 := NULL,
284: p_resource_group_id IN jtf_number_table := NULL,

Line 281: p_percent IN jtf_number_table := NULL,

277: p_program_id IN jtf_number_table := NULL,
278: p_program_update_date IN jtf_date_table := NULL,
279: p_quote_header_id IN jtf_number_table := NULL,
280: p_quote_line_id IN jtf_number_table := NULL,
281: p_percent IN jtf_number_table := NULL,
282: p_resource_id IN jtf_number_table := NULL,
283: p_sales_credit_type IN jtf_varchar2_table_300 := NULL,
284: p_resource_group_id IN jtf_number_table := NULL,
285: p_employee_person_id IN jtf_number_table := NULL,

Line 282: p_resource_id IN jtf_number_table := NULL,

278: p_program_update_date IN jtf_date_table := NULL,
279: p_quote_header_id IN jtf_number_table := NULL,
280: p_quote_line_id IN jtf_number_table := NULL,
281: p_percent IN jtf_number_table := NULL,
282: p_resource_id IN jtf_number_table := NULL,
283: p_sales_credit_type IN jtf_varchar2_table_300 := NULL,
284: p_resource_group_id IN jtf_number_table := NULL,
285: p_employee_person_id IN jtf_number_table := NULL,
286: p_sales_credit_type_id IN jtf_number_table := NULL,

Line 284: p_resource_group_id IN jtf_number_table := NULL,

280: p_quote_line_id IN jtf_number_table := NULL,
281: p_percent IN jtf_number_table := NULL,
282: p_resource_id IN jtf_number_table := NULL,
283: p_sales_credit_type IN jtf_varchar2_table_300 := NULL,
284: p_resource_group_id IN jtf_number_table := NULL,
285: p_employee_person_id IN jtf_number_table := NULL,
286: p_sales_credit_type_id IN jtf_number_table := NULL,
287: p_attribute_category IN jtf_varchar2_table_100 := NULL,
288: p_attribute1 IN jtf_varchar2_table_300 := NULL,

Line 285: p_employee_person_id IN jtf_number_table := NULL,

281: p_percent IN jtf_number_table := NULL,
282: p_resource_id IN jtf_number_table := NULL,
283: p_sales_credit_type IN jtf_varchar2_table_300 := NULL,
284: p_resource_group_id IN jtf_number_table := NULL,
285: p_employee_person_id IN jtf_number_table := NULL,
286: p_sales_credit_type_id IN jtf_number_table := NULL,
287: p_attribute_category IN jtf_varchar2_table_100 := NULL,
288: p_attribute1 IN jtf_varchar2_table_300 := NULL,
289: p_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 286: p_sales_credit_type_id IN jtf_number_table := NULL,

282: p_resource_id IN jtf_number_table := NULL,
283: p_sales_credit_type IN jtf_varchar2_table_300 := NULL,
284: p_resource_group_id IN jtf_number_table := NULL,
285: p_employee_person_id IN jtf_number_table := NULL,
286: p_sales_credit_type_id IN jtf_number_table := NULL,
287: p_attribute_category IN jtf_varchar2_table_100 := NULL,
288: p_attribute1 IN jtf_varchar2_table_300 := NULL,
289: p_attribute2 IN jtf_varchar2_table_300 := NULL,
290: p_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 844: p_quote_header_id IN jtf_number_table := NULL,

840: END Construct_Qte_Header_Rec;
841:
842:
843: FUNCTION construct_qte_line_tbl(
844: p_quote_header_id IN jtf_number_table := NULL,
845: p_quote_line_id IN jtf_number_table := NULL
846: )
847: RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type
848: IS

Line 845: p_quote_line_id IN jtf_number_table := NULL

841:
842:
843: FUNCTION construct_qte_line_tbl(
844: p_quote_header_id IN jtf_number_table := NULL,
845: p_quote_line_id IN jtf_number_table := NULL
846: )
847: RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type
848: IS
849: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

Line 1005: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,

1001: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1002: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1003:
1004: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
1005: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
1006: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
1007: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
1008: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
1009: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,

Line 1006: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,

1002: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1003:
1004: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
1005: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
1006: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
1007: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
1008: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
1009: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1010: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,

Line 1007: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,

1003:
1004: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
1005: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
1006: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
1007: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
1008: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
1009: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1010: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
1011: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,

Line 1008: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,

1004: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
1005: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
1006: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
1007: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
1008: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
1009: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1010: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
1011: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
1012: p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,

Line 1010: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,

1006: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
1007: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
1008: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
1009: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1010: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
1011: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
1012: p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
1013: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
1014: p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,

Line 1011: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,

1007: p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
1008: p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
1009: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1010: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
1011: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
1012: p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
1013: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
1014: p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1015: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,

Line 1013: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,

1009: p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1010: p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
1011: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
1012: p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
1013: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
1014: p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1015: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
1016: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
1017: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,

Line 1015: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,

1011: p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
1012: p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
1013: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
1014: p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1015: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
1016: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
1017: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
1018: p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
1019: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,

Line 1016: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,

1012: p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
1013: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
1014: p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1015: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
1016: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
1017: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
1018: p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
1019: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
1020: p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,

Line 1017: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,

1013: p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
1014: p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
1015: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
1016: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
1017: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
1018: p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
1019: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
1020: p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
1021: p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,

Line 1019: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,

1015: p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
1016: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
1017: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
1018: p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
1019: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
1020: p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
1021: p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
1022: p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
1023: p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,

Line 1020: p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,

1016: p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
1017: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
1018: p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
1019: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
1020: p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
1021: p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
1022: p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
1023: p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
1024: p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,

Line 1021: p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,

1017: p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
1018: p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
1019: p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
1020: p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
1021: p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
1022: p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
1023: p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
1024: p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,
1025: p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,

Line 1025: p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,

1021: p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
1022: p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
1023: p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
1024: p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,
1025: p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,
1026: p_qsh_EMAIL_ADDRESS JTF_VARCHAR2_TABLE_2000 :=NULL,
1027: p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL,
1028: p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
1029: p_party_id NUMBER := FND_API.G_MISS_NUM,