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_DOCUMENT_ARCHIVE_PVT dependencies on PO_HEADERS_ALL

Line 128: FROM PO_HEADERS_ALL PH,

124: -- SQL Why : Check if the document is approved and not archived
125: SELECT NVL(ph.revision_num, 0),
126: NVL(pha.revision_num, -1)
127: INTO x_revision_num, l_arch_revision_num
128: FROM PO_HEADERS_ALL PH,
129: PO_HEADERS_ARCHIVE_ALL PHA
130: WHERE ph.po_header_id = p_document_id
131: AND ph.approved_date IS NOT NULL
132: AND ph.approved_flag = 'Y'

Line 700: FROM PO_HEADERS_ALL

696: ,fon_ref_id
697: ,clm_payment_instr_code --
698: ,clm_contract_finance_code --
699: ,clm_special_contract_type --
700: FROM PO_HEADERS_ALL
701: WHERE po_header_id = p_document_id;
702:
703: l_progress := '030';
704:

Line 2201: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

2197: l_continue BOOLEAN := FALSE;
2198: l_clm_flag VARCHAR2(1) := 'N';
2199:
2200: -- Bug 3648552
2201: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2202: l_po_release_id PO_RELEASES_ALL.po_release_id%TYPE;
2203:
2204:
2205: BEGIN

Line 2976: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

2972: l_progress VARCHAR2(3);
2973: l_return_status VARCHAR2(1);
2974: l_msg_count NUMBER;
2975: l_msg_data VARCHAR2(2000);
2976: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
2977: l_pending_signature_flag PO_HEADERS_ALL.pending_signature_flag%TYPE;
2978: l_clear_amendment VARCHAR2(1);
2979:
2980:

Line 2977: l_pending_signature_flag PO_HEADERS_ALL.pending_signature_flag%TYPE;

2973: l_return_status VARCHAR2(1);
2974: l_msg_count NUMBER;
2975: l_msg_data VARCHAR2(2000);
2976: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
2977: l_pending_signature_flag PO_HEADERS_ALL.pending_signature_flag%TYPE;
2978: l_clear_amendment VARCHAR2(1);
2979:
2980:
2981: BEGIN

Line 3002: FROM po_headers_all

2998: SELECT NVL(conterms_exist_flag, 'N'),
2999: NVL(pending_signature_flag, 'N')
3000: INTO l_conterms_exist_flag,
3001: l_pending_signature_flag
3002: FROM po_headers_all
3003: WHERE po_header_id = p_document_id;
3004:
3005: IF (l_conterms_exist_flag = 'Y') THEN
3006: l_progress := '020';

Line 3184: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

3180: l_module VARCHAR2(100);
3181: l_progress VARCHAR2(3);
3182: l_revision_num NUMBER;
3183: l_return_status VARCHAR2(1);
3184: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
3185: l_draft_id NUMBER := 0;
3186: l_clm_flag VARCHAR2(1);
3187:
3188: BEGIN

Line 3541: FROM po_headers_all

3537: -- SQL What:Find out if it is a global agreement
3538: -- SQL Why :Archive org_assignment table if needed
3539: SELECT NVL(global_agreement_flag, 'N')
3540: INTO l_ga_flag
3541: FROM po_headers_all
3542: WHERE po_header_id = p_document_id;
3543:
3544: IF (l_ga_flag = 'Y') THEN
3545: l_progress := '170';

Line 5496: -- PO_HEADERS_ALL_EXT_B_ARCHIVE / PO_HEADERS_ALL_EXT_TL_ARCHIVE

5492: --Name: archive_uda_attribs
5493: --Pre-reqs:
5494: -- None.
5495: --Modifies:
5496: -- PO_HEADERS_ALL_EXT_B_ARCHIVE / PO_HEADERS_ALL_EXT_TL_ARCHIVE
5497: -- PO_LINES_ALL_EXT_B_ARCHIVE / PO_LINES_ALL_EXT_TL_ARCHIVE
5498: -- PO_LINE_LOC_ALL_EXT_B_ARCHIVE / PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
5499: --Locks:
5500: -- None.

Line 5549: FROM po_headers_all

5545:
5546: -- Check if Document is UDA Enabled
5547: SELECT 'PURCHASING', TYPE_LOOKUP_CODE, STYLE_ID
5548: INTO l_functional_area_code, l_document_type_code, l_document_style_id
5549: FROM po_headers_all
5550: WHERE PO_HEADER_ID = p_po_header_id;
5551:
5552: l_progress := '010';
5553: IF PO_LOG.d_stmt THEN

Line 5581: -- Start PO_HEADERS_ALL_EXT_B_ARCHIVE

5577: -- End Check if Document is UDA Enabled
5578:
5579: -- Archive UDA data only for UDA_enabled Docs, and only for DocTypes PO and PA
5580: IF l_enabled_flag = 'Y' AND p_document_type IN ('PO', 'PA') THEN
5581: -- Start PO_HEADERS_ALL_EXT_B_ARCHIVE
5582: l_progress := '030';
5583: IF PO_LOG.d_stmt THEN
5584: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_B');
5585: END IF;

Line 5584: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_B');

5580: IF l_enabled_flag = 'Y' AND p_document_type IN ('PO', 'PA') THEN
5581: -- Start PO_HEADERS_ALL_EXT_B_ARCHIVE
5582: l_progress := '030';
5583: IF PO_LOG.d_stmt THEN
5584: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_B');
5585: END IF;
5586:
5587: -- : Setting the latest_external_flag to N for all old records.
5588: UPDATE PO_HEADERS_ALL_EXT_B_ARCHIVE

Line 5588: UPDATE PO_HEADERS_ALL_EXT_B_ARCHIVE

5584: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_B');
5585: END IF;
5586:
5587: -- : Setting the latest_external_flag to N for all old records.
5588: UPDATE PO_HEADERS_ALL_EXT_B_ARCHIVE
5589: SET latest_external_flag = 'N'
5590: WHERE po_header_id = p_po_header_id
5591: AND latest_external_flag = 'Y';
5592:

Line 5593: INSERT INTO PO_HEADERS_ALL_EXT_B_ARCHIVE

5589: SET latest_external_flag = 'N'
5590: WHERE po_header_id = p_po_header_id
5591: AND latest_external_flag = 'Y';
5592:
5593: INSERT INTO PO_HEADERS_ALL_EXT_B_ARCHIVE
5594: (EXTENSION_ID
5595: ,ATTR_GROUP_ID
5596: ,PO_HEADER_ID
5597: ,DATA_LEVEL_ID

Line 5812: FROM PO_HEADERS_ALL_EXT_B

5808: ,UDA_TEMPLATE_ID
5809: ,DRAFT_ID
5810: ,p_revision_num
5811: ,'Y' --
5812: FROM PO_HEADERS_ALL_EXT_B
5813: WHERE po_header_id = p_po_header_id
5814: AND draft_id = -1;
5815:
5816: l_progress := '040';

Line 5820: -- End PO_HEADERS_ALL_EXT_B_ARCHIVE

5816: l_progress := '040';
5817: IF PO_LOG.d_stmt THEN
5818: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
5819: END IF;
5820: -- End PO_HEADERS_ALL_EXT_B_ARCHIVE
5821:
5822: -- Start PO_HEADERS_ALL_EXT_TL_ARCHIVE
5823: l_progress := '050';
5824: IF PO_LOG.d_stmt THEN

Line 5822: -- Start PO_HEADERS_ALL_EXT_TL_ARCHIVE

5818: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
5819: END IF;
5820: -- End PO_HEADERS_ALL_EXT_B_ARCHIVE
5821:
5822: -- Start PO_HEADERS_ALL_EXT_TL_ARCHIVE
5823: l_progress := '050';
5824: IF PO_LOG.d_stmt THEN
5825: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_TL');
5826: END IF;

Line 5825: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_TL');

5821:
5822: -- Start PO_HEADERS_ALL_EXT_TL_ARCHIVE
5823: l_progress := '050';
5824: IF PO_LOG.d_stmt THEN
5825: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_TL');
5826: END IF;
5827:
5828: INSERT INTO PO_HEADERS_ALL_EXT_TL_ARCHIVE
5829: (EXTENSION_ID

Line 5828: INSERT INTO PO_HEADERS_ALL_EXT_TL_ARCHIVE

5824: IF PO_LOG.d_stmt THEN
5825: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_TL');
5826: END IF;
5827:
5828: INSERT INTO PO_HEADERS_ALL_EXT_TL_ARCHIVE
5829: (EXTENSION_ID
5830: ,ATTR_GROUP_ID
5831: ,PO_HEADER_ID
5832: ,DATA_LEVEL_ID

Line 5951: FROM PO_HEADERS_ALL_EXT_TL

5947: ,UDA_TEMPLATE_ID
5948: ,DRAFT_ID
5949: ,p_revision_num
5950: ,NULL
5951: FROM PO_HEADERS_ALL_EXT_TL
5952: WHERE po_header_id = p_po_header_id
5953: AND draft_id = -1;
5954:
5955: l_progress := '060';

Line 5959: -- End PO_HEADERS_ALL_EXT_TL_ARCHIVE

5955: l_progress := '060';
5956: IF PO_LOG.d_stmt THEN
5957: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
5958: END IF;
5959: -- End PO_HEADERS_ALL_EXT_TL_ARCHIVE
5960:
5961: -- Archive UDA Line and Line Locations data only for PO or PA BLANKETS
5962: IF (p_document_type = 'PO') OR
5963: (p_document_type = 'PA' AND p_document_subtype='BLANKET') THEN

Line 6839: l_from_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

6835: IS
6836: d_mod CONSTANT VARCHAR2(100) := 'archive_attachments';
6837: l_progress VARCHAR2(4) := '000';
6838:
6839: l_from_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
6840: l_to_po_header_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6841: l_from_po_line_id PO_LINES_ALL.po_line_id%TYPE;
6842: l_to_po_line_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6843: l_from_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

Line 7100: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

7096: IS
7097: d_mod CONSTANT VARCHAR2(100) := 'sync_contract_terms_to_draft';
7098: l_progress VARCHAR2(4) := '000';
7099:
7100: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
7101: l_draft_id PO_HEADERS_ARCHIVE_ALL.DRAFT_ID%TYPE;
7102: l_return_status VARCHAR2(1);
7103:
7104:

Line 7122: FROM po_headers_all

7118: -- SQL What:Find out if contract terms exist
7119: -- SQL Why :Sync Contract Terms if needed
7120: SELECT NVL(conterms_exist_flag, 'N')
7121: INTO l_conterms_exist_flag
7122: FROM po_headers_all
7123: WHERE po_header_id = p_po_header_id;
7124:
7125: IF (l_conterms_exist_flag = 'Y') THEN
7126: l_progress := '020';