DBA Data[Home] [Help]

APPS.AP_PO_AMT_MATCH_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 1035: ap_invoice_distributions_s.nextval

1031: 'EXPENSE',PD.expenditure_organization_id,
1032: NULL), --expenditure_organization_id
1033: DECODE(PD.destination_type_code,
1034: 'EXPENSE', PD.award_id), --award_id
1035: ap_invoice_distributions_s.nextval
1036: FROM po_distributions_ap_v PD
1037: WHERE line_location_id = x_po_line_location_id;
1038:
1039: l_total_amount number;

Line 1161: ap_invoice_distributions_s.nextval

1157: award_id,
1158: expenditure_type,
1159: expenditure_item_date,
1160: expenditure_organization_id,
1161: ap_invoice_distributions_s.nextval
1162: INTO x_dist_tab(i).accrue_on_receipt_flag,
1163: x_dist_tab(i).po_ccid,
1164: x_dist_tab(i).project_id,
1165: x_dist_tab(i).task_id,

Line 3308: ap_invoice_distributions_s.nextval

3304: round((x_correction_amount * aid.amount/ail.amount)
3305: /g_min_acct_unit) * g_min_acct_unit
3306: ) amount,
3307: aid.dist_code_combination_id,
3308: ap_invoice_distributions_s.nextval
3309: FROM ap_invoice_lines ail,
3310: ap_invoice_distributions aid
3311: WHERE ail.invoice_id = x_corrected_invoice_id
3312: AND ail.line_number = x_corrected_line_number

Line 3385: SELECT ap_invoice_distributions_s.nextval

3381: FOR i IN nvl(x_corr_dist_tab.first,0) ..nvl(x_corr_dist_tab.last,0) LOOP
3382:
3383: IF (x_corr_dist_tab.exists(i)) THEN
3384:
3385: SELECT ap_invoice_distributions_s.nextval
3386: INTO x_corr_dist_tab(i).invoice_distribution_id
3387: FROM DUAL;
3388:
3389: x_corr_dist_tab(i).corrected_quantity := Null;