DBA Data[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on AP_INVOICES_INTERFACE_S

Line 116: lv_source AP_INVOICES_INTERFACE.source%TYPE ;

112: for_accounting_date_rec for_accounting_date%ROWTYPE;
113: for_invoice_num_rec for_invoice_num%ROWTYPE;
114: count_orgs NUMBER :=0 ; -- Bug 4928860
115: v_org_id NUMBER;
116: lv_source AP_INVOICES_INTERFACE.source%TYPE ;
117: lv_lookup_type_code ap_invoices_interface.invoice_type_lookup_code%TYPE; --rchandan for bug#4428980
118: lv_description ap_invoices_interface.description%type; --rchandan for bug#4428980
119:
120: /* start additions by ssumaith - bug# 4448789 */

Line 156: Select ap_invoices_interface_s.nextval

152: ELSE
153: v_org_id := p_org_id;
154: END IF;
155:
156: Select ap_invoices_interface_s.nextval
157: Into inv_interface_id
158: From dual;
159:
160: SELECT ap_invoice_lines_interface_s.NEXTVAL

Line 379: lv_source ap_invoices_interface.source%type; --Ravi for literal removal

375: count_orgs NUMBER :=0 ; -- Bug 4928860
376: v_org_id NUMBER;
377: lv_description ap_invoices_interface.description%type; -- Ravi for literal removal
378: lv_lookup_type_code ap_invoices_interface.invoice_type_lookup_code%TYPE; --Ravi for literal removal
379: lv_source ap_invoices_interface.source%type; --Ravi for literal removal
380: --Added by Wenqiong for Bug #1168411 BOE enhancement
381: lv_tax_account_code ap_invoice_lines_interface.dist_code_combination_id%TYPE;
382:
383: /* start additions by ssumaith - bug# 4448789 */

Line 467: SELECT ap_invoices_interface_s.NEXTVAL

463: ELSE
464: v_org_id := p_org_id;
465: END IF;
466:
467: SELECT ap_invoices_interface_s.NEXTVAL
468: INTO inv_interface_id
469: FROM dual;
470:
471: SELECT ap_invoice_lines_interface_s.NEXTVAL

Line 863: p_status IN ap_invoices_interface.STATUS%TYPE DEFAULT NULL,

859: p_attribute12 IN ap_invoices_interface.ATTRIBUTE12%TYPE DEFAULT NULL,
860: p_attribute13 IN ap_invoices_interface.ATTRIBUTE13%TYPE DEFAULT NULL,
861: p_attribute14 IN ap_invoices_interface.ATTRIBUTE14%TYPE DEFAULT NULL,
862: p_attribute15 IN ap_invoices_interface.ATTRIBUTE15%TYPE DEFAULT NULL,
863: p_status IN ap_invoices_interface.STATUS%TYPE DEFAULT NULL,
864: p_source IN ap_invoices_interface.SOURCE%TYPE DEFAULT NULL,
865: p_group_id IN ap_invoices_interface.GROUP_ID%TYPE DEFAULT NULL,
866: p_request_id IN ap_invoices_interface.REQUEST_ID%TYPE DEFAULT NULL,
867: p_payment_cross_rate_type IN ap_invoices_interface.PAYMENT_CROSS_RATE_TYPE%TYPE DEFAULT NULL,

Line 864: p_source IN ap_invoices_interface.SOURCE%TYPE DEFAULT NULL,

860: p_attribute13 IN ap_invoices_interface.ATTRIBUTE13%TYPE DEFAULT NULL,
861: p_attribute14 IN ap_invoices_interface.ATTRIBUTE14%TYPE DEFAULT NULL,
862: p_attribute15 IN ap_invoices_interface.ATTRIBUTE15%TYPE DEFAULT NULL,
863: p_status IN ap_invoices_interface.STATUS%TYPE DEFAULT NULL,
864: p_source IN ap_invoices_interface.SOURCE%TYPE DEFAULT NULL,
865: p_group_id IN ap_invoices_interface.GROUP_ID%TYPE DEFAULT NULL,
866: p_request_id IN ap_invoices_interface.REQUEST_ID%TYPE DEFAULT NULL,
867: p_payment_cross_rate_type IN ap_invoices_interface.PAYMENT_CROSS_RATE_TYPE%TYPE DEFAULT NULL,
868: p_payment_cross_rate_date IN ap_invoices_interface.PAYMENT_CROSS_RATE_DATE%TYPE DEFAULT NULL,

Line 1068: ap_invoices_interface_s.NEXTVAL,

1064: REQUESTER_ID,
1065: SHIP_TO_LOCATION,
1066: EXTERNAL_DOC_REF*/)--commented by Sanjikum for Bug#4183001
1067: VALUES(
1068: ap_invoices_interface_s.NEXTVAL,
1069: p_invoice_num,
1070: p_invoice_type_lookup_code,
1071: p_invoice_date,
1072: p_po_number,