DBA Data[Home] [Help]

APPS.IBE_QUOTE_W2_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 106: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,

102: END IF;
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,

Line 129: p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=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:
132: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE;
133: l_table_size NUMBER;

Line 267: p_operation_code IN jtf_varchar2_table_100 := NULL,

263:
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,

Line 287: p_attribute_category IN jtf_varchar2_table_100 := 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,
291: p_attribute4 IN jtf_varchar2_table_300 := NULL,

Line 1004: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,

1000: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
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,

Line 1027: p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=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,
1030: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
1031: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,