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.IGC_CBC_PO_GRP dependencies on PO_HEADERS

Line 82: FROM po_headers

78: -- Cursor to check if the BPA should be encumbered.
79: CURSOR c_chk_bpa_enc (p_po_header_id NUMBER)
80: IS
81: SELECT encumbrance_required_flag
82: FROM po_headers
83: WHERE po_header_id = p_po_header_id;
84: --
85: -- PUBLIC ROUTINES
86: --

Line 477: l_max_bpa_accounting_date po_headers.cbc_accounting_date%TYPE;

473:
474: -- Added for PRC.FP.J, 3173178
475: l_max_bpa_fiscal_year NUMBER;
476: l_min_bpa_fiscal_year NUMBER;
477: l_max_bpa_accounting_date po_headers.cbc_accounting_date%TYPE;
478: l_min_bpa_accounting_date po_headers.cbc_accounting_date%TYPE;
479:
480: -- cursor to find the GL period status
481:

Line 478: l_min_bpa_accounting_date po_headers.cbc_accounting_date%TYPE;

474: -- Added for PRC.FP.J, 3173178
475: l_max_bpa_fiscal_year NUMBER;
476: l_min_bpa_fiscal_year NUMBER;
477: l_max_bpa_accounting_date po_headers.cbc_accounting_date%TYPE;
478: l_min_bpa_accounting_date po_headers.cbc_accounting_date%TYPE;
479:
480: -- cursor to find the GL period status
481:
482: CURSOR c_get_gl_prd_sts( p_sob_id IN NUMBER

Line 653: FROM po_headers

649: IF p_document_type IN ('PA', 'PO') THEN
650:
651: SELECT cbc_accounting_date
652: INTO l_prev_cbc_acct_date
653: FROM po_headers
654: WHERE po_header_id = p_document_id;
655:
656: ELSIF (p_document_type LIKE 'REL%') THEN
657:

Line 852: -- Will Check Releases Accounting Date with that of PO Headers,

848: x_return_status := FND_API.G_RET_STS_ERROR;
849: END IF;
850: END IF;
851:
852: -- Will Check Releases Accounting Date with that of PO Headers,
853: -- If it is less than the cbc accounting date in PO Headers then it will be rejected.
854:
855: IF p_document_type LIKE 'REL%' AND
856: p_document_sub_type IN ( 'SCHEDULED', 'BLANKET') THEN

Line 853: -- If it is less than the cbc accounting date in PO Headers then it will be rejected.

849: END IF;
850: END IF;
851:
852: -- Will Check Releases Accounting Date with that of PO Headers,
853: -- If it is less than the cbc accounting date in PO Headers then it will be rejected.
854:
855: IF p_document_type LIKE 'REL%' AND
856: p_document_sub_type IN ( 'SCHEDULED', 'BLANKET') THEN
857:

Line 860: from po_headers po, po_releases por

856: p_document_sub_type IN ( 'SCHEDULED', 'BLANKET') THEN
857:
858: select po.cbc_accounting_date
859: into l_po_cbc_acct_date
860: from po_headers po, po_releases por
861: where po.po_header_id = por.po_header_id
862: and por.po_release_id = p_document_id;
863:
864: IF p_cbc_acct_date < l_po_cbc_acct_date THEN

Line 897: FROM po_headers poh,

893: SELECT MAX(poh.cbc_accounting_date),
894: MIN(poh.cbc_accounting_date)
895: INTO l_max_bpa_accounting_date,
896: l_min_bpa_accounting_date
897: FROM po_headers poh,
898: Po_requisition_lines prl
899: WHERE prl.requisition_header_id = p_document_id
900: AND prl.blanket_po_header_id = poh.po_header_id
901: AND prl.blanket_po_header_id IS NOT NULL

Line 915: FROM po_headers bpa_h,

911: SELECT MAX(bpa_h.cbc_accounting_date),
912: MIN(bpa_h.cbc_accounting_date)
913: INTO l_max_bpa_accounting_date,
914: l_min_bpa_accounting_date
915: FROM po_headers bpa_h,
916: Po_lines pol,
917: Po_line_locations poll,
918: Po_distributions bpa_d
919: WHERE pol.po_header_id = p_document_id

Line 1022: -- Cursor to get accounting date FROM PO headers for this document

1018: l_req_enc_flag VARCHAR2(1) ;
1019: l_pur_enc_flag VARCHAR2(1) ;
1020: l_sob_id NUMBER;
1021:
1022: -- Cursor to get accounting date FROM PO headers for this document
1023: Cursor c_get_po_date IS
1024: SELECT cbc_accounting_date
1025: FROM po_headers
1026: WHERE po_header_id = p_document_id ;

Line 1025: FROM po_headers

1021:
1022: -- Cursor to get accounting date FROM PO headers for this document
1023: Cursor c_get_po_date IS
1024: SELECT cbc_accounting_date
1025: FROM po_headers
1026: WHERE po_header_id = p_document_id ;
1027:
1028: -- Cursor to get accounting date FROM PO_Req headers for this document
1029: Cursor c_get_req_date IS

Line 1097: po_headers poh

1093: -- Cursor to get the latest accounting date FROM PO's relating to the release
1094: Cursor c_rel_po_date IS
1095: SELECT poh.cbc_accounting_date
1096: FROM po_releases por,
1097: po_headers poh
1098: WHERE por.po_release_id = p_document_id
1099: AND por.po_header_id = poh.po_header_id ;
1100:
1101: -- Cursor to get financial information

Line 1112: FROM po_headers bpa_h,

1108: -- Added for PRC.FP.J, get the accounting date for the
1109: -- Blanket Agreements for Standard Purchase Orders.
1110: Cursor c_max_bpa_po_date IS
1111: SELECT max(bpa_h.cbc_accounting_date)
1112: FROM po_headers bpa_h,
1113: Po_lines pol,
1114: Po_distributions bpa_d
1115: WHERE pol.po_header_id = p_document_id
1116: AND pol.from_header_id IS NOT NULL

Line 1127: FROM po_headers bpa_h,

1123: -- Get the accounting date for the backing blanket agreements
1124: -- for the requisitions.
1125: Cursor c_max_bpa_req_date IS
1126: SELECT MAX(bpa_h.cbc_accounting_date)
1127: FROM po_headers bpa_h,
1128: Po_requisition_lines prl
1129: WHERE prl.requisition_header_id = p_document_id
1130: AND prl.blanket_po_header_id = bpa_h.po_header_id
1131: AND prl.blanket_po_header_id IS NOT NULL

Line 1528: UPDATE po_headers

1524: IF p_document_type IN ('PA', 'PO')
1525: THEN
1526: -- Bug 2885953 added if statement and removed nvl from update for performance enhancement
1527: IF p_cbc_acct_date IS NOT NULL THEN
1528: UPDATE po_headers
1529: -- SET cbc_accounting_date = NVL(p_cbc_acct_date, cbc_accounting_date)
1530: SET cbc_accounting_date = p_cbc_acct_date
1531: WHERE po_header_id = p_document_id ;
1532:

Line 1651: PO_Headers h

1647: p.gl_encumbered_date PO_GL_Date,
1648: p.set_of_books_id sob_id,
1649: h.cbc_accounting_date PO_Acct_Date
1650: From PO_Distributions_V p,
1651: PO_Headers h
1652: Where p.po_header_id = p_document_id
1653: And p.po_line_id = nvl(p_line_id, p.po_line_id)
1654: And p.line_location_id = nvl(p_line_location_id, p.line_location_id)
1655: And p.po_header_id = h.po_header_id