DBA Data[Home] [Help]

APPS.IGC_CC_PO_INTERFACE_PKG dependencies on PO_LINES_ALL

Line 215: p_po_lines_rec IN OUT NOCOPY po_lines_all%ROWTYPE,

211: PROCEDURE Initialize_Lines_Row(p_mode IN VARCHAR2,
212: p_po_header_id IN NUMBER,
213: p_org_id IN NUMBER,
214: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,
215: p_po_lines_rec IN OUT NOCOPY po_lines_all%ROWTYPE,
216: p_yr_start_date IN DATE,
217: p_yr_end_date IN DATE)
218: IS
219: l_po_lines_rec po_lines_all%ROWTYPE;

Line 219: l_po_lines_rec po_lines_all%ROWTYPE;

215: p_po_lines_rec IN OUT NOCOPY po_lines_all%ROWTYPE,
216: p_yr_start_date IN DATE,
217: p_yr_end_date IN DATE)
218: IS
219: l_po_lines_rec po_lines_all%ROWTYPE;
220: l_line_type_id po_line_types_tl.line_type_id%TYPE;
221: E_CC_PO_LINE_TYPE EXCEPTION;
222:
223: -- M van der geest, added 18-OKT-2001

Line 293: /* tax_classif_code of igc_cc_acct_lines is assigned to tax_name of po_lines_all

289: l_po_lines_rec.taxable_flag := p_cc_acct_lines_rec.cc_acct_taxable_flag ;
290:
291: l_po_lines_rec.tax_name := p_cc_acct_lines_rec.tax_classif_code;
292:
293: /* tax_classif_code of igc_cc_acct_lines is assigned to tax_name of po_lines_all
294: for r12 EBtax uptake for CC */
295:
296: /* Commented for bug 6472296 - r12 EBtax uptake for CC
297: BEGIN

Line 431: p_po_lines_rec IN po_lines_all%ROWTYPE,

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;
435:

Line 784: l_po_lines_rec po_lines_all%ROWTYPE;

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;
788: l_new_account_line BOOLEAN;

Line 1047: FROM po_lines_all pol

1043:
1044: BEGIN
1045:
1046: SELECT * INTO l_po_lines_rec
1047: FROM po_lines_all pol
1048: WHERE
1049: pol.po_header_id = l_po_headers_rec.po_header_id AND
1050: pol.line_num = l_cc_acct_lines_rec.cc_acct_line_num;
1051: EXCEPTION

Line 1177: l_po_lines_rec po_lines_all%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:
1181: l_encumbered_period_name gl_periods.period_name%TYPE;

Line 1451: FROM po_lines_all pol

1447:
1448: BEGIN
1449:
1450: SELECT * INTO l_po_lines_rec
1451: FROM po_lines_all pol
1452: WHERE
1453: pol.po_header_id = l_po_headers_rec.po_header_id AND
1454: pol.line_num = l_cc_acct_lines_rec.cc_acct_line_num;
1455: EXCEPTION

Line 1505: IGC_CC_PO_LINES_ALL_PVT.Insert_Row(1.0,

1501: l_po_lines_rec,
1502: l_start_date,
1503: l_end_date);
1504:
1505: IGC_CC_PO_LINES_ALL_PVT.Insert_Row(1.0,
1506: FND_API.G_FALSE,
1507: FND_API.G_FALSE,
1508: FND_API.G_VALID_LEVEL_NONE,
1509: l_return_status,

Line 1595: IGC_CC_PO_LINES_ALL_PVT.Update_Row(1.0,

1591: l_po_lines_rec,
1592: l_start_date,
1593: l_end_date);
1594:
1595: IGC_CC_PO_LINES_ALL_PVT.Update_Row(1.0,
1596: FND_API.G_FALSE,
1597: FND_API.G_FALSE,
1598: FND_API.G_VALID_LEVEL_NONE,
1599: l_return_status,

Line 1780: /* Insert row into PO_LINES_ALL */

1776: END;
1777:
1778: IF (l_curr_year_pf_lines > 0)
1779: THEN
1780: /* Insert row into PO_LINES_ALL */
1781:
1782: Initialize_Lines_Row('I',
1783: l_po_headers_rec.po_header_id,
1784: l_cc_headers_rec.org_id,

Line 1789: IGC_CC_PO_LINES_ALL_PVT.Insert_Row(1.0,

1785: l_cc_acct_lines_rec,
1786: l_po_lines_rec,
1787: l_start_date,
1788: l_end_date);
1789: IGC_CC_PO_LINES_ALL_PVT.Insert_Row(1.0,
1790: FND_API.G_FALSE,
1791: FND_API.G_FALSE,
1792: FND_API.G_VALID_LEVEL_NONE,
1793: l_return_status,