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_OPEN_INTERFACE_PKG dependencies on IGC_CC_DET_PF

Line 144: SELECT igc_cc_det_pf_s.nextval

140: PROCEDURE DET_PF_INTERFACE_DERIVE
141: ( P_Det_Pf_Line_Id OUT NOCOPY NUMBER)
142: IS
143: BEGIN
144: SELECT igc_cc_det_pf_s.nextval
145: INTO P_Det_Pf_Line_Id FROM DUAL;
146: END;
147:
148: /***************************************************************************/

Line 207: FROM igc_cc_det_pf_interface ICDPI

203:
204: CURSOR c_interface_orphan_det_pf IS
205: SELECT ICDPI.interface_acct_line_id,
206: ICDPI.interface_det_pf_line_id
207: FROM igc_cc_det_pf_interface ICDPI
208: WHERE ICDPI.batch_id = g_batch_id
209: AND NOT EXISTS (SELECT ICALI.interface_acct_line_id
210: FROM igc_cc_headers_interface ICHI,
211: igc_cc_acct_lines_interface ICALI

Line 303: FROM igc_cc_det_pf ccd, igc_cc_det_pf_interface ccdi

299: END IF;
300: IF P_Interface_Parent_Det_Pf_Id IS NOT NULL AND P_Parent_Det_Pf_Id IS NULL THEN
301: BEGIN
302: SELECT ccd.cc_det_pf_line_id INTO P_Parent_Det_Pf_Id
303: FROM igc_cc_det_pf ccd, igc_cc_det_pf_interface ccdi
304: WHERE ccdi.interface_det_pf_line_id = P_Interface_Parent_Det_Pf_Id
305: AND ccd.cc_acct_line_id = P_Parent_Acct_Line_Id
306: AND ccdi.cc_det_pf_line_num = ccd.cc_det_pf_line_num;
307: EXCEPTION WHEN OTHERS THEN RAISE;

Line 999: FROM igc_cc_det_pf_interface

995: -- Get the PF date of the Cover CC
996: BEGIN
997: SELECT cc_det_pf_date
998: INTO l_cover_cc_det_pf_date
999: FROM igc_cc_det_pf_interface
1000: WHERE interface_det_pf_line_id = p_interface_parent_det_pf_id;
1001:
1002: EXCEPTION
1003: WHEN NO_DATA_FOUND

Line 1159: p_cc_det_pf_line_id IN igc_cc_det_pf.cc_det_pf_line_id%TYPE,

1155: PROCEDURE populate_pa_table
1156: (p_budget_type IN VARCHAR2,
1157: p_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
1158: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE,
1159: p_cc_det_pf_line_id IN igc_cc_det_pf.cc_det_pf_line_id%TYPE,
1160: p_cc_state IN igc_cc_headers.cc_state%TYPE,
1161: p_project_id IN igc_cc_acct_lines.project_id%TYPE,
1162: p_task_id IN igc_cc_acct_lines.task_id%TYPE,
1163: p_expenditure_type IN igc_cc_acct_lines.expenditure_type%TYPE,

Line 1736: FROM igc_cc_det_pf_interface b

1732:
1733:
1734: SELECT count(interface_det_pf_line_id)
1735: INTO l_curr_year_pf_lines
1736: FROM igc_cc_det_pf_interface b
1737: WHERE b.cc_det_pf_date <= l_end_date
1738: AND b.interface_acct_line_id IN (SELECT interface_acct_line_id
1739: FROM igc_cc_acct_lines_interface a
1740: WHERE a.interface_header_id = l_interface_header_record.Interface_Header_Id);

Line 2422: DELETE IGC.igc_cc_det_pf_interface

2418: DELETE IGC.igc_cc_headers_interface
2419: WHERE batch_id = P_Batch_Id;
2420: DELETE IGC.igc_cc_acct_lines_interface
2421: WHERE batch_id = P_Batch_Id;
2422: DELETE IGC.igc_cc_det_pf_interface
2423: WHERE batch_id = P_Batch_Id;
2424:
2425: */
2426: END IF;

Line 3964: FROM igc_cc_det_pf_interface

3960: -- Validate Acct Entered Amt. Sum of Det_Pf_Entered_Amt + Withheld Amount should be
3961: -- equal to Acct Entered Amt.
3962: BEGIN
3963: SELECT NVL(SUM(cc_det_pf_entered_amt), 0) INTO l_entered_amt
3964: FROM igc_cc_det_pf_interface
3965: WHERE interface_acct_line_id = P_Interface_Acct_Line_Id;
3966:
3967: -- Validation changed for 2043221, Bidisha S , 24 Oct 2001
3968: -- Ent Amount = SUM (PF Amount) + Withheld Amount

Line 4495: l_interface_det_pf_record igc_cc_det_pf_interface%ROWTYPE;

4491: l_return_status VARCHAR2(1);
4492: l_msg_count NUMBER;
4493: l_msg_data VARCHAR2(2000);
4494: l_msg_buf VARCHAR2(2000);
4495: l_interface_det_pf_record igc_cc_det_pf_interface%ROWTYPE;
4496:
4497: CURSOR c_interface_det_pf_records IS
4498: SELECT * FROM igc_cc_det_pf_interface
4499: WHERE batch_id = g_batch_id

Line 4498: SELECT * FROM igc_cc_det_pf_interface

4494: l_msg_buf VARCHAR2(2000);
4495: l_interface_det_pf_record igc_cc_det_pf_interface%ROWTYPE;
4496:
4497: CURSOR c_interface_det_pf_records IS
4498: SELECT * FROM igc_cc_det_pf_interface
4499: WHERE batch_id = g_batch_id
4500: AND interface_acct_line_id = P_Interface_Acct_Line_Id;
4501: BEGIN
4502: -- Process the det pf line records one by one

Line 4546: IGC_CC_DET_PF_PKG.Insert_Row(

4542: l_parent_acct_line_id,
4543: l_parent_det_pf_id );
4544: END IF;
4545:
4546: IGC_CC_DET_PF_PKG.Insert_Row(
4547: 1.0,
4548: FND_API.G_TRUE,
4549: FND_API.G_FALSE,
4550: FND_API.G_VALID_LEVEL_FULL,

Line 4655: END IF; -- Insert into igc_cc_det_pf was sucessfull.

4651: p_sob_id => p_set_of_books_id,
4652: p_org_id => p_org_id);
4653:
4654: END IF; -- PA Funds check required
4655: END IF; -- Insert into igc_cc_det_pf was sucessfull.
4656: END IF; -- Phase is final and no validation errors were found
4657: END LOOP;
4658: CLOSE c_interface_det_pf_records;
4659:

Line 4785: FROM igc_cc_det_pf_interface

4781: ELSE
4782: BEGIN
4783: SELECT interface_det_pf_line_id
4784: INTO l_interface_parent_det_pf_id
4785: FROM igc_cc_det_pf_interface
4786: WHERE interface_det_pf_line_id = P_Interface_Parent_Det_Pf_Id;
4787: EXCEPTION WHEN NO_DATA_FOUND THEN
4788: l_error_message := NULL;
4789: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_DET_PF_LINE_NOT_EXISTS');

Line 4789: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_DET_PF_LINE_NOT_EXISTS');

4785: FROM igc_cc_det_pf_interface
4786: WHERE interface_det_pf_line_id = P_Interface_Parent_Det_Pf_Id;
4787: EXCEPTION WHEN NO_DATA_FOUND THEN
4788: l_error_message := NULL;
4789: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_DET_PF_LINE_NOT_EXISTS');
4790: FND_MESSAGE.SET_TOKEN('INT_PARENT_DET_PF_LINE_ID', TO_CHAR(P_Interface_Parent_Det_Pf_Id), TRUE);
4791: l_error_message := FND_MESSAGE.GET;
4792: INTERFACE_HANDLE_ERRORS
4793: ( P_Interface_Header_Id,

Line 4805: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_DET_PF_LINE_ID_NULL');

4801: END IF;
4802: ELSE
4803: IF P_Interface_Parent_Det_Pf_Id IS NOT NULL THEN
4804: l_error_message := NULL;
4805: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_DET_PF_LINE_ID_NULL');
4806: l_error_message := FND_MESSAGE.GET;
4807: INTERFACE_HANDLE_ERRORS
4808: ( P_Interface_Header_Id,
4809: P_Interface_Acct_Line_Id,

Line 4868: FROM igc_cc_det_pf_interface

4864: -- be less than the sum of Det_Pf_Func_Amt of its Releases.
4865: BEGIN
4866: IF P_Cc_Type = 'C' THEN
4867: SELECT NVL(SUM(cc_det_pf_func_amt), 0) INTO l_func_amt
4868: FROM igc_cc_det_pf_interface
4869: WHERE interface_par_det_pf_line_id = P_Interface_Det_Pf_Id;
4870: IF NVL(P_Cc_Det_Pf_Func_Amt, 0) < NVL(l_func_amt, 0) THEN
4871: l_error_message := NULL;
4872: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_FUNC_AMT_COV_DIFFERS');

Line 4988: FROM igc_cc_det_pf_interface

4984: IF P_Cc_Type = 'R' THEN
4985: IF P_Interface_Parent_Det_Pf_Id IS NOT NULL THEN
4986: BEGIN
4987: SELECT cc_det_pf_encmbrnc_date INTO l_det_pf_date
4988: FROM igc_cc_det_pf_interface
4989: WHERE interface_det_pf_line_id = P_Interface_Parent_Det_Pf_Id;
4990: IF l_det_pf_date <> P_Cc_Det_Pf_Encmbrnc_Date THEN
4991: l_error_message := NULL;
4992: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_PF_ENC_RELDT_MORE_COVDT');