APPS.IGC_CC_PO_INTERFACE_PKG dependencies on PO_HEADERS_ALL

Line 12: p_po_headers_rec IN OUT NOCOPY po_headers_all%ROWTYPE)

8:
9: PROCEDURE Initialize_Header_Row(p_mode IN VARCHAR2,
10: p_encumbrance_on IN VARCHAR2,
11: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
12: p_po_headers_rec IN OUT NOCOPY po_headers_all%ROWTYPE)
13: IS
14:
15: l_po_headers_rec po_headers_all%ROWTYPE;
16: l_employee_id NUMBER;

Line 15: l_po_headers_rec po_headers_all%ROWTYPE;

11: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
12: p_po_headers_rec IN OUT NOCOPY po_headers_all%ROWTYPE)
13: IS
14:
15: l_po_headers_rec po_headers_all%ROWTYPE;
16: l_employee_id NUMBER;
17: E_EMPLOYEE_NOT_FOUND EXCEPTION;
18: BEGIN
19: -- Bug 3605536 GSCC warnings fixed

Line 430: p_po_headers_rec IN po_headers_all%ROWTYPE,

426:
427:
428: PROCEDURE Initialize_Line_Locs_Row(p_mode IN VARCHAR2,
429: p_encumbrance_on IN VARCHAR2,
430: p_po_headers_rec IN po_headers_all%ROWTYPE,
431: p_po_lines_rec IN po_lines_all%ROWTYPE,
432: p_po_line_locs_rec IN OUT NOCOPY po_line_locations_all%ROWTYPE)
433: IS
434: l_po_line_locs_rec po_line_locations_all%ROWTYPE;

Line 783: l_po_headers_rec po_headers_all%ROWTYPE;

779:
780: l_cc_headers_rec igc_cc_headers%ROWTYPE;
781: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
782:
783: l_po_headers_rec po_headers_all%ROWTYPE;
784: l_po_lines_rec po_lines_all%ROWTYPE;
785: l_po_line_locs_rec po_line_locations_all%ROWTYPE;
786:
787: l_po_found BOOLEAN;

Line 935: FROM PO_HEADERS_ALL

931:
932: BEGIN
933:
934: SELECT * INTO l_po_headers_rec
935: FROM PO_HEADERS_ALL
936: WHERE segment1 = l_cc_headers_rec.cc_num AND
937: type_lookup_code = 'STANDARD' AND
938: org_id = l_cc_headers_rec.org_id;
939: EXCEPTION

Line 1018: IGC_CC_PO_HEADERS_ALL_PVT.Update_Row(1.0,

1014: l_po_headers_rec.approved_flag := 'N';
1015: l_po_headers_rec.approved_date := NULL;
1016: END IF;
1017:
1018: IGC_CC_PO_HEADERS_ALL_PVT.Update_Row(1.0,
1019: FND_API.G_FALSE,
1020: FND_API.G_FALSE,
1021: FND_API.G_VALID_LEVEL_NONE,
1022: l_return_status,

Line 1176: l_po_headers_rec po_headers_all%ROWTYPE;

1172: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1173: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
1174: l_cc_pmt_fcst_rec igc_cc_det_pf%ROWTYPE;
1175:
1176: l_po_headers_rec po_headers_all%ROWTYPE;
1177: l_po_lines_rec po_lines_all%ROWTYPE;
1178: l_po_line_locs_rec po_line_locations_all%ROWTYPE;
1179: l_po_dist_rec po_distributions_all%ROWTYPE;
1180:

Line 1369: FROM PO_HEADERS_ALL

1365:
1366: BEGIN
1367:
1368: SELECT * INTO l_po_headers_rec
1369: FROM PO_HEADERS_ALL
1370: WHERE segment1 = l_cc_headers_rec.cc_num AND
1371: type_lookup_code = 'STANDARD' AND
1372: org_id = l_cc_headers_rec.org_id;
1373:

Line 1420: IGC_CC_PO_HEADERS_ALL_PVT.Update_Row(1.0,

1416:
1417: IF (l_po_found)
1418: THEN
1419: Initialize_Header_Row('U',l_encumbrance_on, l_cc_headers_rec, l_po_headers_rec);
1420: IGC_CC_PO_HEADERS_ALL_PVT.Update_Row(1.0,
1421: FND_API.G_FALSE,
1422: FND_API.G_FALSE,
1423: FND_API.G_VALID_LEVEL_NONE,
1424: l_return_status,

Line 1734: /* Insert row into PO_HEADERS_ALL */

1730: /* PO does not exist */
1731:
1732: IF ( not l_po_found ) AND (l_curr_year_pf_lines > 0)
1733: THEN
1734: /* Insert row into PO_HEADERS_ALL */
1735:
1736: Initialize_Header_Row('I',l_encumbrance_on, l_cc_headers_rec, l_po_headers_rec);
1737:
1738: IGC_CC_PO_HEADERS_ALL_PVT.Insert_Row(1.0,

Line 1738: IGC_CC_PO_HEADERS_ALL_PVT.Insert_Row(1.0,

1734: /* Insert row into PO_HEADERS_ALL */
1735:
1736: Initialize_Header_Row('I',l_encumbrance_on, l_cc_headers_rec, l_po_headers_rec);
1737:
1738: IGC_CC_PO_HEADERS_ALL_PVT.Insert_Row(1.0,
1739: FND_API.G_FALSE,
1740: FND_API.G_FALSE,
1741: FND_API.G_VALID_LEVEL_NONE,
1742: l_return_status,

Line 1956: FROM po_headers_all

1952: --SELECT *
1953: -- Reducing the number of columns selected reduces the shared
1954: -- memory used. Performance tuning project
1955: SELECT po_header_id
1956: FROM po_headers_all
1957: WHERE segment1 = p_cc_num AND
1958: type_lookup_code = 'STANDARD' AND
1959: org_id = p_org_id
1960: FOR UPDATE NOWAIT;