APPS.IGF_AP_ISIR_IMPORT_PKG dependencies on IGF_AP_OUTCORR_WF

Line 1701: igf_ap_outcorr_wf_pkg.insert_row (

1697: BEGIN
1698:
1699: OPEN cur_get_name;
1700: FETCH cur_get_name INTO l_given_names,l_person_number;
1701: igf_ap_outcorr_wf_pkg.insert_row (
1702: x_rowid => l_rowid,
1703: x_person_number => l_person_number,
1704: x_given_names => l_given_names,
1705: x_transaction_number => g_transaction_num,

Line 1741: l_ow_id igf_ap_outcorr_wf.ow_id%type;

1737: l_item_type VARCHAR2(200);
1738: l_item_key VARCHAR2(300);
1739: l_interim_str VARCHAR2(500);
1740: l_cnt NUMBER ;
1741: l_ow_id igf_ap_outcorr_wf.ow_id%type;
1742: l_given_names igf_ap_outcorr_wf.given_names%TYPE;
1743:
1744: CURSOR cur_get_name
1745: IS

Line 1742: l_given_names igf_ap_outcorr_wf.given_names%TYPE;

1738: l_item_key VARCHAR2(300);
1739: l_interim_str VARCHAR2(500);
1740: l_cnt NUMBER ;
1741: l_ow_id igf_ap_outcorr_wf.ow_id%type;
1742: l_given_names igf_ap_outcorr_wf.given_names%TYPE;
1743:
1744: CURSOR cur_get_name
1745: IS
1746: SELECT given_names,

Line 1755: FROM igf_ap_outcorr_wf wf

1751: CURSOR cur_upd_key
1752: IS
1753: SELECT wf.*,
1754: wf.rowid row_id
1755: FROM igf_ap_outcorr_wf wf
1756: WHERE item_key = 'NEW';
1757:
1758: CURSOR cur_get_data
1759: IS

Line 1761: FROM igf_ap_outcorr_wf

1757:
1758: CURSOR cur_get_data
1759: IS
1760: SELECT *
1761: FROM igf_ap_outcorr_wf
1762: WHERE item_key = l_item_key;
1763:
1764: l_msg_body cur_get_data%ROWTYPE;
1765: l_upd_key cur_upd_key%ROWTYPE;

Line 1776: IGF_AP_OUTCORR_WF_PKG.update_row(

1772:
1773: LOOP
1774: FETCH cur_upd_key INTO l_upd_key;
1775: EXIT WHEN cur_upd_key%NOTFOUND;
1776: IGF_AP_OUTCORR_WF_PKG.update_row(
1777: x_rowid => l_upd_key.row_id,
1778: x_person_number => l_upd_key.person_number,
1779: x_given_names => l_upd_key.given_names,
1780: x_transaction_number => l_upd_key.transaction_number,

Line 1817: --delete from igf_ap_outcorr_wf;

1813: END LOOP;
1814: CLOSE cur_get_data;
1815:
1816: END IF;
1817: --delete from igf_ap_outcorr_wf;
1818:
1819: IF display_type = 'text/plain' THEN
1820: document_type := 'text/plain';
1821: RETURN;