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 39: CURSOR po_distribution_cursor(x_line_location_id po_distributions.line_location_id%TYPE) IS

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

Line 41: FROM PO_DISTRIBUTIONS

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

Line 60: FROM PO_DISTRIBUTIONS

56: AND clm_base_line_num IS NOT NULL;
57:
58: CURSOR clm_po_distribution_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS
59: SELECT DISTINCT group_line_id
60: FROM PO_DISTRIBUTIONS
61: WHERE po_header_id = x_po_header_id
62: AND distribution_type <> 'AGREEMENT'
63: AND group_line_id IS NOT NULL;
64:

Line 103: x_po_distribution_record IN po_distributions%ROWTYPE,

99: p_orig_line_location_id IN NUMBER --
100: );
101:
102: PROCEDURE insert_distribution(
103: x_po_distribution_record IN po_distributions%ROWTYPE,
104: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
105: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
106: x_line_num IN po_online_report_text.line_num%TYPE,
107: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 186: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,

182: p_po_header_rec IN PO_HEADERS%ROWTYPE,
183: p_po_line_rec IN PO_LINES%ROWTYPE,
184: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
185: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
186: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
187: x_sequence IN OUT NOCOPY NUMBER,
188: x_return_code OUT NOCOPY NUMBER
189: );
190: --< Shared Proc FPJ End >

Line 2005: x_po_distribution_record IN po_distributions%ROWTYPE,

2001:
2002:
2003:
2004: PROCEDURE insert_distribution(
2005: x_po_distribution_record IN po_distributions%ROWTYPE,
2006: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2007: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2008: x_line_num IN po_online_report_text.line_num%TYPE,
2009: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

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

2018:
2019: --
2020: l_msg_buf VARCHAR2(2000);
2021: l_gms_po_interface_obj gms_po_interface_type;
2022: l_award_id PO_DISTRIBUTIONS_ALL.award_id%TYPE := NULL;
2023: --
2024:
2025: BEGIN
2026:

Line 2083: INSERT INTO PO_DISTRIBUTIONS (

2079: * bgu, Oct. 06, 1999
2080: * Should not copy encumberance reserve related fields.
2081: */
2082:
2083: INSERT INTO PO_DISTRIBUTIONS (
2084: accrual_account_id,
2085: accrued_flag,
2086: accrue_on_receipt_flag,
2087: amount_billed,

Line 3318: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,

3314: p_po_header_rec IN PO_HEADERS%ROWTYPE,
3315: p_po_line_rec IN PO_LINES%ROWTYPE,
3316: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
3317: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
3318: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
3319: x_sequence IN OUT NOCOPY NUMBER,
3320: x_return_code OUT NOCOPY NUMBER
3321: )
3322: IS

Line 3333: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

3329: l_line_id PO_LINES_ALL.po_line_id%TYPE;
3330: l_line_num PO_LINES_ALL.line_num%TYPE;
3331: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
3332: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3333: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3334:
3335: BEGIN
3336:
3337: l_progress := '000';

Line 3439: fnd_attached_documents2_pkg.copy_attachments('PO_DISTRIBUTIONS',

3435: IF (l_internal_return_code = 0) THEN
3436: IF (p_copy_attachments) THEN
3437: l_progress := '060';
3438:
3439: fnd_attached_documents2_pkg.copy_attachments('PO_DISTRIBUTIONS',
3440: p_orig_po_distribution_id,
3441: '',
3442: '',
3443: '',

Line 3445: 'PO_DISTRIBUTIONS',

3441: '',
3442: '',
3443: '',
3444: '',
3445: 'PO_DISTRIBUTIONS',
3446: x_po_distribution_rec.po_distribution_id,
3447: '',
3448: '',
3449: '',

Line 3527: x_po_distribution_record po_distributions%ROWTYPE;

3523:
3524: x_po_header_record PO_HEADERS%ROWTYPE;
3525: x_po_line_record po_lines%ROWTYPE;
3526: x_po_shipment_record po_line_locations%ROWTYPE;
3527: x_po_distribution_record po_distributions%ROWTYPE;
3528:
3529: x_orig_po_line_id po_lines.po_line_id%TYPE;
3530: x_orig_line_location_id po_line_locations.line_location_id%TYPE;
3531: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;

Line 3531: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;

3527: x_po_distribution_record po_distributions%ROWTYPE;
3528:
3529: x_orig_po_line_id po_lines.po_line_id%TYPE;
3530: x_orig_line_location_id po_line_locations.line_location_id%TYPE;
3531: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;
3532:
3533: x_document_num VARCHAR(100);
3534: x_line_num po_online_report_text.line_num%TYPE := NULL;
3535: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;

Line 3753: FROM PO_DISTRIBUTIONS POD

3749: x_progress := '042';
3750:
3751: BEGIN
3752: SELECT * INTO x_po_distribution_record
3753: FROM PO_DISTRIBUTIONS POD
3754: WHERE POD.PO_HEADER_ID = x_from_po_header_id
3755: AND POD.distribution_type = 'AGREEMENT';
3756:
3757: EXCEPTION

Line 4159: UPDATE PO_DISTRIBUTIONS

4155: line_num = l_line_num AND
4156: line_num_display = l_line_num_display AND ROWNUM =1 ;
4157:
4158:
4159: UPDATE PO_DISTRIBUTIONS
4160: SET group_line_id = l_group_line_id
4161: WHERE po_header_id = x_to_po_header_id AND
4162: group_line_id IS NOT NULL AND
4163: group_line_id = l_cursor_group_line_id;

Line 4643: ,x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE

4639: ,p_to_pk_value IN NUMBER
4640: ,x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE
4641: ,x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE
4642: ,x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE
4643: ,x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE
4644: ,x_return_status OUT NOCOPY VARCHAR2
4645: ,x_msg_count OUT NOCOPY NUMBER
4646: ,x_msg_data OUT NOCOPY VARCHAR2
4647: )

Line 4794: UPDATE PO_DISTRIBUTIONS_ALL

4790: ELSIF p_level = 'DISTRIBUTION' THEN
4791:
4792: IF PO_CLM_CLO_UTIL.Isclminstalled THEN
4793:
4794: UPDATE PO_DISTRIBUTIONS_ALL
4795: SET uda_template_id = x_po_distribution_rec.uda_template_id,
4796: clm_misc_loa = x_po_distribution_rec.clm_misc_loa,
4797: clm_defence_funding = x_po_distribution_rec.clm_defence_funding,
4798: clm_fms_case_number = x_po_distribution_rec.clm_fms_case_number,

Line 4811: FROM po_distributions_all

4807: END IF;
4808:
4809: SELECT UDA_TEMPLATE_ID
4810: INTO l_template_id
4811: FROM po_distributions_all
4812: WHERE PO_DISTRIBUTION_ID = p_from_pk_value;
4813:
4814: IF l_template_id IS NULL THEN
4815: RETURN;