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_VALIDATIONS_PKG dependencies on IGC_CC_INTERFACE

Line 304: -- IGC_CC_INTERFACE table and set the global variable which indicates an

300: -- --------------------------------------------------------------------
301: -- Check to see if the CCID is not enabled. If not enabled then setup
302: -- the appropriate global variable indicating that there was a validation
303: -- error and update the status and result status for the record in the
304: -- IGC_CC_INTERFACE table and set the global variable which indicates an
305: -- error has happened during the validation. This will prevent the funds
306: -- check from being performed.
307: -- --------------------------------------------------------------------
308:

Line 330: -- record in the IGC_CC_INTERFACE table and set the global variable

326: -- --------------------------------------------------------------------
327: -- Check to see if the CCID does not have POSTING enabled. If not then
328: -- setup the appropriate global variable indicating that there was a
329: -- validation error and update the status and result status for the
330: -- record in the IGC_CC_INTERFACE table and set the global variable
331: -- which indicates an error has happened during the validation. This
332: -- will prevent the funds check from being performed.
333: -- --------------------------------------------------------------------
334: IF (l_posting_flag = 'N') AND (p_det_sum_value ='D') THEN

Line 344: -- record in the IGC_CC_INTERFACE table and set the global variable

340: -- --------------------------------------------------------------------
341: -- Check to see if the CCID does not have budgeting enabled. If not
342: -- then setup the appropriate global variable indicating that there was
343: -- a validation error and update the status and result status for the
344: -- record in the IGC_CC_INTERFACE table and set the global variable
345: -- which indicates an error has happened during the validation. This
346: -- will prevent the funds check from being performed.
347: -- ---------------------------------------------------------------------
348: p_result_code := 'F23';

Line 1489: p_documt_type IN igc_cc_interface.document_type%TYPE,

1485: p_sob_id IN gl_sets_of_books.set_of_books_id%TYPE,
1486: p_cbc_enabled IN VARCHAR2,
1487: p_cc_head_id IN igc_cbc_je_batches.cc_header_id%TYPE,
1488: p_actl_flag IN VARCHAR2,
1489: p_documt_type IN igc_cc_interface.document_type%TYPE,
1490: -- p_sum_line_num OUT NOCOPY igc_cbc_je_lines.cbc_je_line_num%TYPE,
1491: p_cbc_flag OUT NOCOPY VARCHAR2,
1492: p_sbc_flag OUT NOCOPY VARCHAR2
1493: -- p_packet_id IN NUMBER

Line 1504: FROM igc_cc_interface_v

1500: SELECT count(*)
1501: /*
1502: ,max(batch_line_num)
1503: */
1504: FROM igc_cc_interface_v
1505: WHERE budget_dest_flag ='C'
1506: AND cc_header_id = p_cc_head_id
1507: AND actual_flag = p_actl_flag
1508: AND document_type = p_documt_type;

Line 1512: FROM igc_cc_interface_v

1508: AND document_type = p_documt_type;
1509:
1510: CURSOR c_sbc_count IS --Check if SBC records in the interface table
1511: SELECT count(*)
1512: FROM igc_cc_interface_v
1513: WHERE budget_dest_flag = 'S'
1514: AND cc_header_id = p_cc_head_id
1515: AND actual_flag = p_actl_flag
1516: AND document_type = p_documt_type;

Line 1520: FROM igc_cc_interface_v

1516: AND document_type = p_documt_type;
1517:
1518: CURSOR c_sob_count IS -- Check sob in the table, must be 1 or 0
1519: SELECT count(DISTINCT set_of_books_id)
1520: FROM igc_cc_interface_v
1521: WHERE cc_header_id = p_cc_head_id
1522: AND actual_flag = p_actl_flag
1523: AND document_type = p_documt_type;
1524:

Line 1528: FROM igc_cc_interface_v

1524:
1525: /* THIS CHECK IS NOT REQIRED ANYMORE BECAUSE OF PA INTEGRATION
1526: CURSOR c_result_count IS --Check result code in the table, must be 0
1527: SELECT count(*)
1528: FROM igc_cc_interface_v
1529: WHERE cc_header_id = p_cc_head_id
1530: AND actual_flag = p_actl_flag
1531: AND document_type = p_documt_type
1532: AND ( cbc_result_code IS NOT NULL

Line 1538: FROM igc_cc_interface_v

1534: /*
1535: --R12 uptake. Encumbrance Details are seeded in R12. Bug No 6341012
1536: CURSOR c_enc_count IS --Check encumbrance_type_id Must be 0
1537: SELECT count(*)
1538: FROM igc_cc_interface_v
1539: WHERE cc_header_id = p_cc_head_id
1540: AND actual_flag = 'E'
1541: AND document_type = p_documt_type
1542: AND encumbrance_type_id IS NULL;

Line 1551: FROM igc_cc_interface_v

1547: --Packet ID does not exist in R12. Hence Commented. Bug No 6341012
1548: CURSOR c_cbc_count_packet IS --Check if CBC records in the interface table
1549: SELECT count(*),
1550: max(batch_line_num)
1551: FROM igc_cc_interface_v
1552: WHERE budget_dest_flag ='C'
1553: AND reference_6 = p_packet_id
1554: AND actual_flag = p_actl_flag ;
1555:

Line 1558: FROM igc_cc_interface_v

1554: AND actual_flag = p_actl_flag ;
1555:
1556: CURSOR c_sbc_count_packet IS --Check if SBC records in the interface table
1557: SELECT count(*)
1558: FROM igc_cc_interface_v
1559: WHERE budget_dest_flag = 'S'
1560: AND reference_6 = p_packet_id
1561: AND actual_flag = p_actl_flag ;
1562:

Line 1565: FROM igc_cc_interface_v

1561: AND actual_flag = p_actl_flag ;
1562:
1563: CURSOR c_enc_count_packet IS --Check encumbrance_type_id Must be 0
1564: SELECT count(*)
1565: FROM igc_cc_interface_v
1566: WHERE reference_6 = p_packet_id
1567: AND actual_flag = 'E'
1568: AND encumbrance_type_id IS NULL;
1569: */