eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_COPYDOC_S1 dependencies on PO_DISTRIBUTIONS

Line 36: CURSOR po_distribution_cursor(x_line_location_id po_distributions.line_location_id%TYPE) IS

32: WHERE po_line_id = x_po_line_id
33: AND SHIPMENT_TYPE NOT IN ('SCHEDULED','BLANKET') --Bug: 1773758 1992096
34: ORDER BY shipment_num;
35:
36: CURSOR po_distribution_cursor(x_line_location_id po_distributions.line_location_id%TYPE) IS
37: SELECT *
38: FROM PO_DISTRIBUTIONS
39: WHERE line_location_id = x_line_location_id
40: AND distribution_type <> 'AGREEMENT' --bug 3338216: filter BPA dists

Line 38: FROM PO_DISTRIBUTIONS

34: ORDER BY shipment_num;
35:
36: CURSOR po_distribution_cursor(x_line_location_id po_distributions.line_location_id%TYPE) IS
37: SELECT *
38: FROM PO_DISTRIBUTIONS
39: WHERE line_location_id = x_line_location_id
40: AND distribution_type <> 'AGREEMENT' --bug 3338216: filter BPA dists
41: ORDER BY distribution_num;
42:

Line 81: x_po_distribution_record IN po_distributions%ROWTYPE,

77: p_orig_line_location_id IN NUMBER --
78: );
79:
80: PROCEDURE insert_distribution(
81: x_po_distribution_record IN po_distributions%ROWTYPE,
82: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
83: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
84: x_line_num IN po_online_report_text.line_num%TYPE,
85: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 161: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,

157: p_po_header_rec IN PO_HEADERS%ROWTYPE,
158: p_po_line_rec IN PO_LINES%ROWTYPE,
159: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
160: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
161: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
162: x_sequence IN OUT NOCOPY NUMBER,
163: x_return_code OUT NOCOPY NUMBER
164: );
165: --< Shared Proc FPJ End >

Line 1857: x_po_distribution_record IN po_distributions%ROWTYPE,

1853:
1854:
1855:
1856: PROCEDURE insert_distribution(
1857: x_po_distribution_record IN po_distributions%ROWTYPE,
1858: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1859: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1860: x_line_num IN po_online_report_text.line_num%TYPE,
1861: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 1874: l_award_id PO_DISTRIBUTIONS_ALL.award_id%TYPE := NULL;

1870:
1871: --
1872: l_msg_buf VARCHAR2(2000);
1873: l_gms_po_interface_obj gms_po_interface_type;
1874: l_award_id PO_DISTRIBUTIONS_ALL.award_id%TYPE := NULL;
1875: --
1876:
1877: BEGIN
1878:

Line 1935: INSERT INTO PO_DISTRIBUTIONS (

1931: * bgu, Oct. 06, 1999
1932: * Should not copy encumberance reserve related fields.
1933: */
1934:
1935: INSERT INTO PO_DISTRIBUTIONS (
1936: accrual_account_id,
1937: accrued_flag,
1938: accrue_on_receipt_flag,
1939: amount_billed,

Line 2985: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,

2981: p_po_header_rec IN PO_HEADERS%ROWTYPE,
2982: p_po_line_rec IN PO_LINES%ROWTYPE,
2983: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
2984: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
2985: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
2986: x_sequence IN OUT NOCOPY NUMBER,
2987: x_return_code OUT NOCOPY NUMBER
2988: )
2989: IS

Line 3000: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

2996: l_line_id PO_LINES_ALL.po_line_id%TYPE;
2997: l_line_num PO_LINES_ALL.line_num%TYPE;
2998: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
2999: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3000: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3001:
3002: BEGIN
3003:
3004: l_progress := '000';

Line 3106: fnd_attached_documents2_pkg.copy_attachments('PO_DISTRIBUTIONS',

3102: IF (l_internal_return_code = 0) THEN
3103: IF (p_copy_attachments) THEN
3104: l_progress := '060';
3105:
3106: fnd_attached_documents2_pkg.copy_attachments('PO_DISTRIBUTIONS',
3107: p_orig_po_distribution_id,
3108: '',
3109: '',
3110: '',

Line 3112: 'PO_DISTRIBUTIONS',

3108: '',
3109: '',
3110: '',
3111: '',
3112: 'PO_DISTRIBUTIONS',
3113: x_po_distribution_rec.po_distribution_id,
3114: '',
3115: '',
3116: '',

Line 3194: x_po_distribution_record po_distributions%ROWTYPE;

3190:
3191: x_po_header_record PO_HEADERS%ROWTYPE;
3192: x_po_line_record po_lines%ROWTYPE;
3193: x_po_shipment_record po_line_locations%ROWTYPE;
3194: x_po_distribution_record po_distributions%ROWTYPE;
3195:
3196: x_orig_po_line_id po_lines.po_line_id%TYPE;
3197: x_orig_line_location_id po_line_locations.line_location_id%TYPE;
3198: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;

Line 3198: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;

3194: x_po_distribution_record po_distributions%ROWTYPE;
3195:
3196: x_orig_po_line_id po_lines.po_line_id%TYPE;
3197: x_orig_line_location_id po_line_locations.line_location_id%TYPE;
3198: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;
3199:
3200: x_line_num po_online_report_text.line_num%TYPE := NULL;
3201: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
3202: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;

Line 3344: FROM PO_DISTRIBUTIONS POD

3340: x_progress := '042';
3341:
3342: BEGIN
3343: SELECT * INTO x_po_distribution_record
3344: FROM PO_DISTRIBUTIONS POD
3345: WHERE POD.PO_HEADER_ID = x_from_po_header_id
3346: AND POD.distribution_type = 'AGREEMENT';
3347:
3348: EXCEPTION