DBA Data[Home] [Help]

APPS.PO_COPYDOC_S5 dependencies on PO_DISTRIBUTIONS

Line 17: x_po_distribution_record IN OUT NOCOPY po_distributions%ROWTYPE,

13: --
14: PROCEDURE validate_distribution(
15: x_action_code IN VARCHAR2,
16: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
17: x_po_distribution_record IN OUT NOCOPY po_distributions%ROWTYPE,
18: x_po_header_id IN po_distributions.po_header_id%TYPE,
19: x_po_line_id IN po_distributions.po_line_id%TYPE,
20: x_line_location_id IN po_distributions.line_location_id%TYPE,
21: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 18: x_po_header_id IN po_distributions.po_header_id%TYPE,

14: PROCEDURE validate_distribution(
15: x_action_code IN VARCHAR2,
16: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
17: x_po_distribution_record IN OUT NOCOPY po_distributions%ROWTYPE,
18: x_po_header_id IN po_distributions.po_header_id%TYPE,
19: x_po_line_id IN po_distributions.po_line_id%TYPE,
20: x_line_location_id IN po_distributions.line_location_id%TYPE,
21: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
22: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

Line 19: x_po_line_id IN po_distributions.po_line_id%TYPE,

15: x_action_code IN VARCHAR2,
16: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
17: x_po_distribution_record IN OUT NOCOPY po_distributions%ROWTYPE,
18: x_po_header_id IN po_distributions.po_header_id%TYPE,
19: x_po_line_id IN po_distributions.po_line_id%TYPE,
20: x_line_location_id IN po_distributions.line_location_id%TYPE,
21: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
22: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
23: x_line_num IN po_online_report_text.line_num%TYPE,

Line 20: x_line_location_id IN po_distributions.line_location_id%TYPE,

16: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
17: x_po_distribution_record IN OUT NOCOPY po_distributions%ROWTYPE,
18: x_po_header_id IN po_distributions.po_header_id%TYPE,
19: x_po_line_id IN po_distributions.po_line_id%TYPE,
20: x_line_location_id IN po_distributions.line_location_id%TYPE,
21: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
22: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
23: x_line_num IN po_online_report_text.line_num%TYPE,
24: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 54: SELECT po_distributions_s.nextval

50: x_po_distribution_record.po_line_id := x_po_line_id;
51: x_po_distribution_record.line_location_id := x_line_location_id;
52:
53: BEGIN
54: SELECT po_distributions_s.nextval
55: INTO x_po_distribution_record.po_distribution_id
56: FROM SYS.DUAL;
57: EXCEPTION
58: WHEN OTHERS THEN

Line 220: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,

216: p_online_report_id IN NUMBER,
217: p_po_header_rec IN PO_HEADERS%ROWTYPE,
218: p_po_line_rec IN PO_LINES%ROWTYPE,
219: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
220: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
221: x_sequence IN OUT NOCOPY NUMBER
222: )
223: IS
224:

Line 235: l_accrual_account_id PO_DISTRIBUTIONS_ALL.accrual_account_id%TYPE;

231: l_dest_variance_success BOOLEAN;
232: l_variance_success BOOLEAN;
233: l_new_combination BOOLEAN;
234:
235: l_accrual_account_id PO_DISTRIBUTIONS_ALL.accrual_account_id%TYPE;
236: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE;
237: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE;
238: l_dest_charge_account_id PO_DISTRIBUTIONS_ALL.dest_charge_account_id%TYPE;
239: l_dest_variance_account_id PO_DISTRIBUTIONS_ALL.dest_variance_account_id%TYPE;

Line 236: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE;

232: l_variance_success BOOLEAN;
233: l_new_combination BOOLEAN;
234:
235: l_accrual_account_id PO_DISTRIBUTIONS_ALL.accrual_account_id%TYPE;
236: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE;
237: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE;
238: l_dest_charge_account_id PO_DISTRIBUTIONS_ALL.dest_charge_account_id%TYPE;
239: l_dest_variance_account_id PO_DISTRIBUTIONS_ALL.dest_variance_account_id%TYPE;
240: l_variance_account_id PO_DISTRIBUTIONS_ALL.variance_account_id%TYPE;

Line 237: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE;

233: l_new_combination BOOLEAN;
234:
235: l_accrual_account_id PO_DISTRIBUTIONS_ALL.accrual_account_id%TYPE;
236: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE;
237: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE;
238: l_dest_charge_account_id PO_DISTRIBUTIONS_ALL.dest_charge_account_id%TYPE;
239: l_dest_variance_account_id PO_DISTRIBUTIONS_ALL.dest_variance_account_id%TYPE;
240: l_variance_account_id PO_DISTRIBUTIONS_ALL.variance_account_id%TYPE;
241:

Line 238: l_dest_charge_account_id PO_DISTRIBUTIONS_ALL.dest_charge_account_id%TYPE;

234:
235: l_accrual_account_id PO_DISTRIBUTIONS_ALL.accrual_account_id%TYPE;
236: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE;
237: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE;
238: l_dest_charge_account_id PO_DISTRIBUTIONS_ALL.dest_charge_account_id%TYPE;
239: l_dest_variance_account_id PO_DISTRIBUTIONS_ALL.dest_variance_account_id%TYPE;
240: l_variance_account_id PO_DISTRIBUTIONS_ALL.variance_account_id%TYPE;
241:
242: l_accrual_account_desc VARCHAR2(2000);

Line 239: l_dest_variance_account_id PO_DISTRIBUTIONS_ALL.dest_variance_account_id%TYPE;

235: l_accrual_account_id PO_DISTRIBUTIONS_ALL.accrual_account_id%TYPE;
236: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE;
237: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE;
238: l_dest_charge_account_id PO_DISTRIBUTIONS_ALL.dest_charge_account_id%TYPE;
239: l_dest_variance_account_id PO_DISTRIBUTIONS_ALL.dest_variance_account_id%TYPE;
240: l_variance_account_id PO_DISTRIBUTIONS_ALL.variance_account_id%TYPE;
241:
242: l_accrual_account_desc VARCHAR2(2000);
243: l_budget_account_desc VARCHAR2(2000);

Line 240: l_variance_account_id PO_DISTRIBUTIONS_ALL.variance_account_id%TYPE;

236: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE;
237: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE;
238: l_dest_charge_account_id PO_DISTRIBUTIONS_ALL.dest_charge_account_id%TYPE;
239: l_dest_variance_account_id PO_DISTRIBUTIONS_ALL.dest_variance_account_id%TYPE;
240: l_variance_account_id PO_DISTRIBUTIONS_ALL.variance_account_id%TYPE;
241:
242: l_accrual_account_desc VARCHAR2(2000);
243: l_budget_account_desc VARCHAR2(2000);
244: l_charge_account_desc VARCHAR2(2000);