DBA Data[Home] [Help]

APPS.AP_PO_AMT_MATCH_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 937: ap_invoice_distributions_s.nextval

933: 'EXPENSE',PD.expenditure_organization_id,
934: NULL), --expenditure_organization_id
935: DECODE(PD.destination_type_code,
936: 'EXPENSE', PD.award_id), --award_id
937: ap_invoice_distributions_s.nextval
938: FROM po_distributions_ap_v PD
939: WHERE line_location_id = x_po_line_location_id;
940:
941: l_total_amount number;

Line 1062: ap_invoice_distributions_s.nextval

1058: award_id,
1059: expenditure_type,
1060: expenditure_item_date,
1061: expenditure_organization_id,
1062: ap_invoice_distributions_s.nextval
1063: INTO x_dist_tab(i).accrue_on_receipt_flag,
1064: x_dist_tab(i).po_ccid,
1065: x_dist_tab(i).project_id,
1066: x_dist_tab(i).task_id,

Line 3155: ap_invoice_distributions_s.nextval

3151: round((x_correction_amount * aid.amount/ail.amount)
3152: /g_min_acct_unit) * g_min_acct_unit
3153: ) amount,
3154: aid.dist_code_combination_id,
3155: ap_invoice_distributions_s.nextval
3156: FROM ap_invoice_lines ail,
3157: ap_invoice_distributions aid
3158: WHERE ail.invoice_id = x_corrected_invoice_id
3159: AND ail.line_number = x_corrected_line_number

Line 3231: SELECT ap_invoice_distributions_s.nextval

3227: FOR i IN nvl(x_corr_dist_tab.first,0) ..nvl(x_corr_dist_tab.last,0) LOOP
3228:
3229: IF (x_corr_dist_tab.exists(i)) THEN
3230:
3231: SELECT ap_invoice_distributions_s.nextval
3232: INTO x_corr_dist_tab(i).invoice_distribution_id
3233: FROM DUAL;
3234:
3235: x_corr_dist_tab(i).corrected_quantity := Null;