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.PA_FUNDS_CONTROL_PKG dependencies on IGC_CC_INTERFACE

Line 10235: * to gl_bc_packets and igc_cc_interface tables

10231: If g_debug_mode = 'Y' Then
10232: log_message(p_msg_token1 => 'Inside the create_liqd_entry api ');
10233: End if;
10234: /** Bug fix : 1900229 During Check mode also insert liquidation and burden transaction
10235: * to gl_bc_packets and igc_cc_interface tables
10236: */
10237:
10238: IF p_calling_module = 'CBC' and p_mode in ('R','U','C','F') then
10239:

Line 10242: FROM igc_cc_interface

10238: IF p_calling_module = 'CBC' and p_mode in ('R','U','C','F') then
10239:
10240: SELECT nvl(MAX(batch_line_num),0)
10241: INTO l_max_batch_line_id
10242: FROM igc_cc_interface
10243: WHERE document_type = 'CC'
10244: AND cc_header_id = p_reference2;
10245:
10246:

Line 10247: INSERT INTO igc_cc_interface(

10243: WHERE document_type = 'CC'
10244: AND cc_header_id = p_reference2;
10245:
10246:
10247: INSERT INTO igc_cc_interface(
10248: CC_HEADER_ID,
10249: CC_VERSION_NUM,
10250: CC_ACCT_LINE_ID,
10251: CC_DET_PF_LINE_ID ,

Line 10347: FROM igc_cc_interface igc,

10343: --igc.BATCH_ID ,
10344: --igc.PA_FLAG ,
10345: --igc.RESULT_CODE_LEVEL ,
10346: --igc.RESULT_CODE_SOURCE
10347: FROM igc_cc_interface igc,
10348: pa_bc_packets pbc
10349: WHERE pbc.packet_id = p_packet_id
10350: AND pbc.document_header_id = igc.cc_header_id
10351: AND pbc.document_distribution_id = igc.cc_acct_line_id

Line 10569: FROM igc_cc_interface

10565:
10566: IF p_calling_module = 'CBC' then
10567: SELECT nvl(MAX(batch_line_num),0)
10568: INTO l_max_batch_line_id
10569: FROM igc_cc_interface
10570: WHERE document_type = 'CC'
10571: AND cc_header_id = p_reference2;
10572:
10573: INSERT INTO igc_cc_interface(

Line 10573: INSERT INTO igc_cc_interface(

10569: FROM igc_cc_interface
10570: WHERE document_type = 'CC'
10571: AND cc_header_id = p_reference2;
10572:
10573: INSERT INTO igc_cc_interface(
10574: CC_HEADER_ID,
10575: CC_VERSION_NUM,
10576: CC_ACCT_LINE_ID,
10577: CC_DET_PF_LINE_ID ,

Line 10672: FROM igc_cc_interface igc,

10668: --igc.BATCH_ID ,
10669: --igc.PA_FLAG ,
10670: --igc.RESULT_CODE_LEVEL ,
10671: --igc.RESULT_CODE_SOURCE
10672: FROM igc_cc_interface igc,
10673: pa_bc_packets pbc
10674: WHERE pbc.packet_id = p_packet_id
10675: AND pbc.document_type in ('CC_C_CO','CC_P_CO')
10676: /*** bug fix : 1883119

Line 10760: FROM igc_cc_interface igc

10756: CURSOR igc_status(l_cc_header_id number
10757: ,l_cc_type varchar2) is
10758: SELECT decode(count(*), count(decode(substr(nvl
10759: (igc.cbc_result_code,'P'),1,1),'P',1)),'P','F')
10760: FROM igc_cc_interface igc
10761: WHERE igc.cc_header_id = l_cc_header_id;
10762:
10763:
10764: CURSOR gl_status is

Line 11281: UPDATE igc_cc_interface igc

11277: If g_debug_mode = 'Y' Then
11278: log_message(p_msg_token1 =>' update CBC packet with result code ');
11279: End if;
11280:
11281: UPDATE igc_cc_interface igc
11282: SET igc.cbc_result_code =
11283: (select MAX(
11284: decode(substr(nvl(igc.cbc_result_code,'P'),1,1),'P',
11285: decode( pbc.result_code,'F100','F00',

Line 11461: * status code in igc_cc_interface table if pa pass and

11457:
11458: IF p_calling_module in('CBC','CBC_TIEBACK') then
11459:
11460: /** the calling module CBC_TIEBACK is used to update the
11461: * status code in igc_cc_interface table if pa pass and
11462: * cbc fc fails, if pa fails then cbc doesnot call tie back
11463: * since payment forcast lines are not funds checked we
11464: * should not update the status code of payment forcast line
11465: */

Line 11471: UPDATE igc_cc_interface igc

11467: open igc_status(p_reference2,p_reference1);
11468: fetch igc_status into l_igc_status;
11469: close igc_status;
11470:
11471: UPDATE igc_cc_interface igc
11472: SET igc.cbc_result_code = decode(substr(cbc_result_code,1,1),'P',
11473: decode(sign(nvl(igc.cc_func_dr_amt,0)
11474: - nvl(igc.cc_func_cr_amt,0)),
11475: -1, 'P32',

Line 11734: * IGC_CC_INTERFACE.CC_HEADER_ID

11730: * * This param is not null for EXP , CC document type and Base line mode
11731: * P_reference2 If the p_mode is 'R',U,C,F' and p_calling_module = 'CBC' then
11732: * this parameter holds the document header info for Contract Commitment
11733: * document Header Id from Contract Commitments
11734: * IGC_CC_INTERFACE.CC_HEADER_ID
11735: * Elsif p_mode is B, S and p_calling_module = 'BASELINE' then
11736: * this parameter holds the project_id
11737: * End if;
11738: * * This param is not null for CC document type and Base line mode

Line 12377: -- entries in gl bc packets and igc cc interface tables

12373: end if;
12374:
12375: ----------------------------------------------------------------------------------
12376: -- if the project funds check is success full then call encumbrance liquidation
12377: -- entries in gl bc packets and igc cc interface tables
12378: ----------------------------------------------------------------------------------
12379: If g_debug_mode = 'Y' then
12380: log_message(p_stage => 120, p_msg_token1 => 'Calling create_liqd_entry API');
12381: end if;

Line 12828: * P_reference2 = Igc_cc_interface.document_type

12824: * CBC --- Contract Commitments
12825: * P_reference1 :This Param is not null in case of Contract Commitment
12826: * If P_ext_bdgt_type = CBC
12827: * This param holds the information of document type
12828: * P_reference2 = Igc_cc_interface.document_type
12829: * elsif p_mode = B then
12830: * P_reference1 = project_id
12831: * Else
12832: * P_reference1 = NULL;

Line 12837: * P_reference2 = Igc_cc_interface.CC_HEADER_ID

12833: * End if;
12834: * P_reference2 :This Param is not null in case of Contract Commitment
12835: * If P_ext_bdgt_type = CBC
12836: * This param holds the information of document Header Id
12837: * P_reference2 = Igc_cc_interface.CC_HEADER_ID
12838: * elsif p_mode = B then
12839: * P_reference2 = budget_version_id
12840: * Else
12841: * P_reference2 = NULL;

Line 12899: FROM igc_cc_interface igc

12895:
12896: -------->6599207 ------As part of CC Enhancements
12897: CURSOR cbc_cur IS
12898: SELECT igc.rowid,igc.reference_9
12899: FROM igc_cc_interface igc
12900: WHERE igc.document_type = p_reference1
12901: AND igc.cc_header_id = p_reference2
12902: AND ((nvl(substr(igc.cbc_result_code,1,1),'P') = 'F'
12903: AND igc.status_code in ('F','R'))