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_CC_REP_YEP_PVT dependencies on IGC_CC_HEADERS

Line 36: igc_cc_headers cch

32: FROM
33: ap_invoice_distributions_all apid,
34: po_distributions_all pod,
35: po_headers_all phh,
36: igc_cc_headers cch
37: WHERE
38: apid.po_distribution_id = pod.po_distribution_id AND
39: pod.po_header_id = phh.po_header_id AND
40: phh.org_id = cch.org_id AND

Line 152: FROM IGC_CC_HEADERS

148: RETURN BOOLEAN AS
149:
150: CURSOR C(p_cc_header_id NUMBER) IS
151: SELECT *
152: FROM IGC_CC_HEADERS
153: WHERE
154: CC_HEADER_ID = p_CC_HEADER_ID
155: FOR UPDATE
156: NOWAIT;

Line 201: FROM IGC_CC_HEADERS B,

197: SELECT 'Y'
198: FROM PO_HEADERS_ALL A
199: WHERE
200: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
201: FROM IGC_CC_HEADERS B,
202: PO_HEADERS_ALL C
203: WHERE B.ORG_ID = C.ORG_ID AND
204: B.CC_NUM = C.SEGMENT1 AND
205: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

Line 212: FROM IGC_CC_HEADERS B,

208: SELECT 'Y'
209: FROM PO_HEADERS_ALL A
210: WHERE
211: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
212: FROM IGC_CC_HEADERS B,
213: PO_HEADERS_ALL C
214: WHERE B.ORG_ID = C.ORG_ID AND
215: B.CC_NUM = C.SEGMENT1 AND
216: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

Line 280: FROM IGC_CC_HEADERS

276: RETURN VARCHAR2 AS
277:
278: CURSOR C3 IS
279: SELECT *
280: FROM IGC_CC_HEADERS
281: WHERE IGC_CC_HEADERS.CC_HEADER_ID = p_CC_HEADER_ID;
282:
283: CURSOR C4(HEADER_ID NUMBER) IS
284: SELECT *

Line 281: WHERE IGC_CC_HEADERS.CC_HEADER_ID = p_CC_HEADER_ID;

277:
278: CURSOR C3 IS
279: SELECT *
280: FROM IGC_CC_HEADERS
281: WHERE IGC_CC_HEADERS.CC_HEADER_ID = p_CC_HEADER_ID;
282:
283: CURSOR C4(HEADER_ID NUMBER) IS
284: SELECT *
285: FROM IGC_CC_ACCT_LINES

Line 295: FROM IGC_CC_HEADERS

291: WHERE IGC_CC_DET_PF_V.CC_ACCT_LINE_ID = ACCT_LINE_ID;
292:
293: CURSOR C9 IS
294: SELECT *
295: FROM IGC_CC_HEADERS
296: WHERE PARENT_HEADER_ID IN ( SELECT A.PARENT_HEADER_ID
297: FROM IGC_CC_HEADERS A , IGC_CC_HEADERS B
298: WHERE A.PARENT_HEADER_ID = B.CC_HEADER_ID
299: AND A.PARENT_HEADER_ID = p_CC_HEADER_ID);

Line 297: FROM IGC_CC_HEADERS A , IGC_CC_HEADERS B

293: CURSOR C9 IS
294: SELECT *
295: FROM IGC_CC_HEADERS
296: WHERE PARENT_HEADER_ID IN ( SELECT A.PARENT_HEADER_ID
297: FROM IGC_CC_HEADERS A , IGC_CC_HEADERS B
298: WHERE A.PARENT_HEADER_ID = B.CC_HEADER_ID
299: AND A.PARENT_HEADER_ID = p_CC_HEADER_ID);
300:
301:

Line 309: l_CC_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;

305: V9 C9%ROWTYPE;
306: l_INVOICE_STATUS BOOLEAN;
307: l_PERIOD_COUNTER NUMBER := 0;
308: l_STATUS_COUNTER NUMBER :=0;
309: l_CC_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
310: l_OVERBILLED_COUNTER NUMBER := 0;
311: l_COUNTER NUMBER :=0;
312: l_PROCESS_TYPE VARCHAR2(25);
313: l_STATE IGC_CC_HEADERS.CC_STATE%TYPE;

Line 313: l_STATE IGC_CC_HEADERS.CC_STATE%TYPE;

309: l_CC_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
310: l_OVERBILLED_COUNTER NUMBER := 0;
311: l_COUNTER NUMBER :=0;
312: l_PROCESS_TYPE VARCHAR2(25);
313: l_STATE IGC_CC_HEADERS.CC_STATE%TYPE;
314: l_PREVIOUS_APPRVL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
315: l_DUMMY VARCHAR2(1);
316: l_EXCEPTION igc_cc_process_exceptions.exception_reason%TYPE := NULL;
317:

Line 314: l_PREVIOUS_APPRVL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;

310: l_OVERBILLED_COUNTER NUMBER := 0;
311: l_COUNTER NUMBER :=0;
312: l_PROCESS_TYPE VARCHAR2(25);
313: l_STATE IGC_CC_HEADERS.CC_STATE%TYPE;
314: l_PREVIOUS_APPRVL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
315: l_DUMMY VARCHAR2(1);
316: l_EXCEPTION igc_cc_process_exceptions.exception_reason%TYPE := NULL;
317:
318: BEGIN

Line 1316: UPDATE IGC_CC_HEADERS

1312: AND A.PROCESS_TYPE = p_PROCESS_TYPE
1313: AND A.ORG_ID = p_ORG_ID
1314: AND A.SET_OF_BOOKS_ID = p_SOB_ID;
1315:
1316: UPDATE IGC_CC_HEADERS
1317: SET CC_APPRVL_STATUS = 'IP'
1318: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;
1319: END IF;
1320:

Line 1318: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;

1314: AND A.SET_OF_BOOKS_ID = p_SOB_ID;
1315:
1316: UPDATE IGC_CC_HEADERS
1317: SET CC_APPRVL_STATUS = 'IP'
1318: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;
1319: END IF;
1320:
1321: END IF;
1322:

Line 1514: UPDATE IGC_CC_HEADERS

1510: AND A.PROCESS_TYPE = p_PROCESS_TYPE
1511: AND A.ORG_ID = p_ORG_ID
1512: AND A.SET_OF_BOOKS_ID = p_SOB_ID;
1513:
1514: UPDATE IGC_CC_HEADERS
1515: SET CC_APPRVL_STATUS = 'IP'
1516: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;
1517:
1518: SELECT CC_STATE,CC_APPRVL_STATUS

Line 1516: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;

1512: AND A.SET_OF_BOOKS_ID = p_SOB_ID;
1513:
1514: UPDATE IGC_CC_HEADERS
1515: SET CC_APPRVL_STATUS = 'IP'
1516: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;
1517:
1518: SELECT CC_STATE,CC_APPRVL_STATUS
1519: INTO l_STATE,l_PREVIOUS_APPRVL_STATUS
1520: FROM IGC_CC_HEADERS

Line 1520: FROM IGC_CC_HEADERS

1516: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;
1517:
1518: SELECT CC_STATE,CC_APPRVL_STATUS
1519: INTO l_STATE,l_PREVIOUS_APPRVL_STATUS
1520: FROM IGC_CC_HEADERS
1521: WHERE CC_HEADER_ID = V9.CC_HEADER_ID;
1522:
1523:
1524: IF l_STATE = 'CM' AND l_PREVIOUS_APPRVL_STATUS = 'AP'

Line 1534: FROM IGC_CC_HEADERS B,

1530: FROM PO_HEADERS_ALL A
1531: WHERE
1532: A.PO_HEADER_ID =
1533: (SELECT C.PO_HEADER_ID
1534: FROM IGC_CC_HEADERS B,
1535: PO_HEADERS_ALL C
1536: WHERE B.ORG_ID = C.ORG_ID AND
1537: B.CC_NUM = C.SEGMENT1 AND
1538: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

Line 1546: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

1542: UPDATE PO_HEADERS_ALL
1543: SET APPROVED_FLAG = 'N'
1544: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN
1545: (SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
1546: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
1547: WHERE a.SEGMENT1 = b.CC_NUM
1548: AND a.ORG_ID = b.ORG_ID
1549: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
1550: AND b.CC_HEADER_ID = V9.CC_HEADER_ID);

Line 1749: UPDATE IGC_CC_HEADERS

1745: AND A.PROCESS_TYPE = p_PROCESS_TYPE
1746: AND A.ORG_ID = p_ORG_ID
1747: AND A.SET_OF_BOOKS_ID = p_SOB_ID;
1748:
1749: UPDATE IGC_CC_HEADERS
1750: SET CC_APPRVL_STATUS = 'IP'
1751: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;
1752:
1753: SELECT CC_STATE,CC_APPRVL_STATUS

Line 1751: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;

1747: AND A.SET_OF_BOOKS_ID = p_SOB_ID;
1748:
1749: UPDATE IGC_CC_HEADERS
1750: SET CC_APPRVL_STATUS = 'IP'
1751: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;
1752:
1753: SELECT CC_STATE,CC_APPRVL_STATUS
1754: INTO l_STATE,l_PREVIOUS_APPRVL_STATUS
1755: FROM IGC_CC_HEADERS

Line 1755: FROM IGC_CC_HEADERS

1751: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;
1752:
1753: SELECT CC_STATE,CC_APPRVL_STATUS
1754: INTO l_STATE,l_PREVIOUS_APPRVL_STATUS
1755: FROM IGC_CC_HEADERS
1756: WHERE CC_HEADER_ID = V9.CC_HEADER_ID;
1757:
1758: IF l_STATE = 'CM' AND l_PREVIOUS_APPRVL_STATUS = 'AP'
1759: THEN

Line 1768: FROM IGC_CC_HEADERS B,

1764: FROM PO_HEADERS_ALL A
1765: WHERE
1766: A.PO_HEADER_ID =
1767: (SELECT C.PO_HEADER_ID
1768: FROM IGC_CC_HEADERS B,
1769: PO_HEADERS_ALL C
1770: WHERE B.ORG_ID = C.ORG_ID AND
1771: B.CC_NUM = C.SEGMENT1 AND
1772: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

Line 1780: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

1776: UPDATE PO_HEADERS_ALL
1777: SET APPROVED_FLAG = 'N'
1778: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN
1779: (SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
1780: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
1781: WHERE a.SEGMENT1 = b.CC_NUM
1782: AND a.ORG_ID = b.ORG_ID
1783: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
1784: AND b.CC_HEADER_ID = V9.CC_HEADER_ID);

Line 1976: UPDATE IGC_CC_HEADERS

1972: AND A.PROCESS_TYPE = p_PROCESS_TYPE
1973: AND A.ORG_ID = p_ORG_ID
1974: AND A.SET_OF_BOOKS_ID = p_SOB_ID;
1975:
1976: UPDATE IGC_CC_HEADERS
1977: SET CC_APPRVL_STATUS = 'IP'
1978: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;
1979:
1980: SELECT CC_STATE,CC_APPRVL_STATUS

Line 1978: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;

1974: AND A.SET_OF_BOOKS_ID = p_SOB_ID;
1975:
1976: UPDATE IGC_CC_HEADERS
1977: SET CC_APPRVL_STATUS = 'IP'
1978: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;
1979:
1980: SELECT CC_STATE,CC_APPRVL_STATUS
1981: INTO l_STATE,l_PREVIOUS_APPRVL_STATUS
1982: FROM IGC_CC_HEADERS

Line 1982: FROM IGC_CC_HEADERS

1978: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V9.CC_HEADER_ID;
1979:
1980: SELECT CC_STATE,CC_APPRVL_STATUS
1981: INTO l_STATE,l_PREVIOUS_APPRVL_STATUS
1982: FROM IGC_CC_HEADERS
1983: WHERE CC_HEADER_ID = V9.CC_HEADER_ID;
1984:
1985: IF l_STATE = 'CM' AND l_PREVIOUS_APPRVL_STATUS = 'AP'
1986: THEN

Line 1995: FROM IGC_CC_HEADERS B,

1991: FROM PO_HEADERS_ALL A
1992: WHERE
1993: A.PO_HEADER_ID =
1994: (SELECT C.PO_HEADER_ID
1995: FROM IGC_CC_HEADERS B,
1996: PO_HEADERS_ALL C
1997: WHERE B.ORG_ID = C.ORG_ID AND
1998: B.CC_NUM = C.SEGMENT1 AND
1999: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

Line 2007: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

2003: UPDATE PO_HEADERS_ALL
2004: SET APPROVED_FLAG = 'N'
2005: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN
2006: (SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
2007: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
2008: WHERE a.SEGMENT1 = b.CC_NUM
2009: AND a.ORG_ID = b.ORG_ID
2010: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
2011: AND b.CC_HEADER_ID = V9.CC_HEADER_ID);

Line 2313: igc_cc_headers cch

2309: SELECT pod.po_distribution_id
2310: FROM
2311: po_distributions_all pod,
2312: po_headers_all phh,
2313: igc_cc_headers cch
2314: WHERE
2315: pod.po_header_id = phh.po_header_id AND
2316: phh.org_id = cch.org_id AND
2317: phh.type_lookup_code = 'STANDARD' AND

Line 2518: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,

2514: -- p_cc_conf_enc_type_id IN NUMBER,
2515: -- p_req_encumbrance_type_id IN financials_system_params_all.req_encumbrance_type_id%TYPE,
2516: -- p_purch_encumbrance_type_id IN financials_system_params_all.purch_encumbrance_type_id%TYPE,
2517: p_currency_code IN VARCHAR2,
2518: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
2519: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,
2520: p_cc_pmt_fcst_rec IN igc_cc_det_pf%ROWTYPE,
2521: p_mode IN VARCHAR2,
2522: p_type IN VARCHAR2,

Line 2558: l_cover_cc_num igc_cc_headers.cc_num%TYPE;

2554:
2555: -- bug 2043221 ssmales - added declaration on line below
2556: l_withheld_tran_amt NUMBER;
2557:
2558: l_cover_cc_num igc_cc_headers.cc_num%TYPE;
2559: l_cover_cc_version_num igc_cc_headers.cc_version_num%TYPE;
2560: l_cover_set_of_books_id igc_cc_headers.set_of_books_id%TYPE;
2561: l_cover_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;
2562:

Line 2559: l_cover_cc_version_num igc_cc_headers.cc_version_num%TYPE;

2555: -- bug 2043221 ssmales - added declaration on line below
2556: l_withheld_tran_amt NUMBER;
2557:
2558: l_cover_cc_num igc_cc_headers.cc_num%TYPE;
2559: l_cover_cc_version_num igc_cc_headers.cc_version_num%TYPE;
2560: l_cover_set_of_books_id igc_cc_headers.set_of_books_id%TYPE;
2561: l_cover_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;
2562:
2563: l_cover_cc_acct_desc igc_cc_acct_lines.cc_acct_desc%TYPE;

Line 2560: l_cover_set_of_books_id igc_cc_headers.set_of_books_id%TYPE;

2556: l_withheld_tran_amt NUMBER;
2557:
2558: l_cover_cc_num igc_cc_headers.cc_num%TYPE;
2559: l_cover_cc_version_num igc_cc_headers.cc_version_num%TYPE;
2560: l_cover_set_of_books_id igc_cc_headers.set_of_books_id%TYPE;
2561: l_cover_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;
2562:
2563: l_cover_cc_acct_desc igc_cc_acct_lines.cc_acct_desc%TYPE;
2564: l_cover_budg_code_comb_id igc_cc_acct_lines.cc_budget_code_combination_id%TYPE;

Line 2561: l_cover_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;

2557:
2558: l_cover_cc_num igc_cc_headers.cc_num%TYPE;
2559: l_cover_cc_version_num igc_cc_headers.cc_version_num%TYPE;
2560: l_cover_set_of_books_id igc_cc_headers.set_of_books_id%TYPE;
2561: l_cover_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;
2562:
2563: l_cover_cc_acct_desc igc_cc_acct_lines.cc_acct_desc%TYPE;
2564: l_cover_budg_code_comb_id igc_cc_acct_lines.cc_budget_code_combination_id%TYPE;
2565: l_cover_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;

Line 2569: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

2565: l_cover_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;
2566:
2567:
2568: /* Begin for fix for bug 1689924*/
2569: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
2570: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;
2571: /* End for fix for bug 1689924*/
2572: P_Error_Code VARCHAR2(32); /*EB Tax uptake - Bug No : 6472296*/
2573: l_taxable_flag VARCHAR2(2); /*Bug 6472296 EB Tax uptake - CC*/

Line 2582: FROM igc_cc_headers

2578: (p_process_type = 'F')
2579: THEN
2580: SELECT cc_num,cc_version_num, set_of_books_id, cc_acct_date
2581: INTO l_cover_cc_num, l_cover_cc_version_num, l_cover_set_of_books_id, l_cover_cc_acct_date
2582: FROM igc_cc_headers
2583: WHERE cc_header_id = p_cc_headers_rec.parent_header_id;
2584:
2585: SELECT cc_acct_desc, cc_budget_code_combination_id
2586: INTO l_cover_cc_acct_desc, l_cover_budg_code_comb_id

Line 3436: l_cc_headers_rec igc_cc_headers%ROWTYPE;

3432: ) RETURN VARCHAR2
3433: IS
3434: l_interface_row_count NUMBER;
3435: l_insert_status VARCHAR2(1);
3436: l_cc_headers_rec igc_cc_headers%ROWTYPE;
3437: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
3438: l_cc_pmt_fcst_rec igc_cc_det_pf%ROWTYPE;
3439:
3440: l_cover_set_of_books_id igc_cc_headers.set_of_books_id%TYPE;

Line 3440: l_cover_set_of_books_id igc_cc_headers.set_of_books_id%TYPE;

3436: l_cc_headers_rec igc_cc_headers%ROWTYPE;
3437: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
3438: l_cc_pmt_fcst_rec igc_cc_det_pf%ROWTYPE;
3439:
3440: l_cover_set_of_books_id igc_cc_headers.set_of_books_id%TYPE;
3441:
3442: l_process_account_row BOOLEAN := FALSE;
3443:
3444: l_debug VARCHAR2(1);

Line 3481: FROM igc_cc_headers

3477: BEGIN
3478:
3479: SELECT *
3480: INTO l_cc_headers_rec
3481: FROM igc_cc_headers
3482: WHERE cc_header_id = p_cc_header_id;
3483:
3484: EXCEPTION
3485:

Line 3497: FROM igc_cc_headers

3493: IF (l_cc_headers_rec.cc_type = 'R')
3494: THEN
3495: SELECT set_of_books_id
3496: INTO l_cover_set_of_books_id
3497: FROM igc_cc_headers
3498: WHERE cc_header_id = l_cc_headers_rec.parent_header_id;
3499: END IF;
3500:
3501: /* Delete existing interface rows */

Line 3542: FROM igc_cc_headers

3538: BEGIN
3539:
3540: DELETE igc_cc_interface
3541: WHERE cc_header_id IN (SELECT cc_header_id
3542: FROM igc_cc_headers
3543: WHERE parent_header_id = p_cc_header_id )
3544: AND actual_flag = 'E';
3545: EXCEPTION
3546: WHEN OTHERS