APPS.IGS_AD_IMP_003 dependencies on IGS_AD_FEE_INT

Line 1549: FROM igs_ad_fee_int a

1545: AS
1546:
1547: CURSOR c_appl_fee IS
1548: SELECT cst_insert dmlmode,rowid,a.*
1549: FROM igs_ad_fee_int a
1550: WHERE interface_run_id = p_interface_run_id
1551: AND status = '2'
1552: AND (
1553: ( NVL(match_ind,'15') = '15'

Line 1567: FROM igs_ad_fee_int a

1563: )
1564: )
1565: UNION ALL
1566: SELECT cst_update dmlmode, rowid, a.*
1567: FROM igs_ad_fee_int a
1568: WHERE interface_run_id = p_interface_run_id
1569: AND status = '2'
1570: AND (
1571: (p_rule = 'I')

Line 1625: UPDATE igs_ad_fee_int

1621: IF p_rule IN ('E' ,'I' ) THEN
1622:
1623: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
1624:
1625: UPDATE igs_ad_fee_int
1626: SET status = '3',
1627: error_code = 'E700',
1628: error_text = l_error_text1
1629: WHERE interface_run_id = p_interface_run_id

Line 1635: UPDATE igs_ad_fee_int

1631: AND NVL(match_ind,'15') <> '15';
1632: END IF;
1633:
1634: IF p_rule = 'R' THEN
1635: UPDATE igs_ad_fee_int
1636: SET status = '1',
1637: error_code = NULL,
1638: error_text = NULL
1639: WHERE interface_run_id = p_interface_run_id

Line 1646: UPDATE igs_ad_fee_int a

1642: END IF;
1643:
1644: IF p_rule IN ( 'R', 'I') THEN
1645: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E681', 8405);
1646: UPDATE igs_ad_fee_int a
1647: SET status = '3'
1648: ,error_code = 'E681',
1649: error_text = l_error_text1
1650: WHERE interface_run_id = p_interface_run_id

Line 1661: UPDATE igs_ad_fee_int a

1657: AND TRUNC(b.fee_date) = TRUNC(a.fee_date));
1658: END IF;
1659:
1660: IF p_rule = 'E' THEN
1661: UPDATE igs_ad_fee_int a
1662: SET status = '1',
1663: error_code = NULL,
1664: error_text = NULL,
1665: match_ind = '19'

Line 1744: UPDATE igs_ad_fee_int

1740: x_credit_card_status_code => l_dup_recd.credit_card_status_code
1741: );
1742: END IF;
1743:
1744: UPDATE igs_ad_fee_int
1745: SET status = cst_s_val_1,
1746: error_code = NULL,
1747: error_text = NULL,
1748: match_ind = DECODE (l_fee_int_rec.dmlmode, cst_update, cst_mi_val_18,cst_insert, cst_mi_val_11)

Line 1796: UPDATE igs_ad_fee_int

1792: END IF;
1793:
1794: ROLLBACK TO fee_int_save;
1795:
1796: UPDATE igs_ad_fee_int
1797: SET status = cst_s_val_3,
1798: error_code = l_error_code ,
1799: error_text = l_error_text
1800: WHERE rowid = l_fee_int_rec.rowid;

Line 1817: UPDATE igs_ad_fee_int a

1813: COMMIT;
1814: -- END IF;
1815:
1816:
1817: UPDATE igs_ad_fee_int a
1818: SET status = cst_s_val_1,
1819: error_code = NULL,
1820: error_text = NULL,
1821: match_ind = cst_mi_val_23

Line 1837: UPDATE igs_ad_fee_int a

1833: AND b.fee_amount = a.fee_amount);
1834:
1835:
1836: IF p_rule = 'R' THEN
1837: UPDATE igs_ad_fee_int a
1838: SET
1839: status = cst_s_val_3
1840: , match_ind = cst_mi_val_20
1841: , dup_app_req_id = ( SELECT APP_REQ_ID FROM igs_ad_app_req b

Line 1863: UPDATE igs_ad_fee_int

1859: -- Set STATUS to 3 for interface records with RULE = R and invalid MATCH IND
1860: IF p_rule = 'R' THEN
1861: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
1862:
1863: UPDATE igs_ad_fee_int
1864: SET
1865: status = cst_s_val_3
1866: , error_code = cst_ec_val_E700,
1867: error_text = l_error_text1