[Home] [Help]
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
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;
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
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);
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;
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
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
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
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');
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');
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');