[Home] [Help]
1198: --Created by : Priya Athipatla, Oracle IDC
1199: --Date created: 08-OCT-2002
1200: --
1201: --Purpose: Private procedure to update value of conv_process_run_ind
1202: -- in the igs_fi_control_all table to 0 or 1 when the holds process is
1203: -- not-running/running anymore.
1204: --
1205: --Known limitations/enhancements and/or remarks:
1206: --
1224: ------------------------------------------------------------------
1225:
1226: CURSOR c_get_data IS
1227: SELECT fc.rowid, fc.*
1228: FROM igs_fi_control_all fc;
1229:
1230: l_rec_get_data c_get_data%ROWTYPE;
1231:
1232: BEGIN
1326: WHERE balance_rule_id = cp_balance_rule_id;
1327:
1328: l_rec_get_balances c_get_balances%ROWTYPE;
1329: l_process_start_dt igs_fi_person_holds.process_start_dt%TYPE;
1330: l_conv_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
1331: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
1332: l_version_number igs_fi_balance_rules.version_number%TYPE;
1333: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;
1334: l_balance_amt igs_fi_balances.holds_balance%TYPE := 0;
1649: --pathipat 23-Apr-2003 Enh 2831569 - Commercial Receivables build - Added call to
1650: -- igs_fi_com_rec_interface.chk_manage_account()
1651: ------------------------------------------------------------------
1652:
1653: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
1654: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
1655: l_org_id VARCHAR2(15);
1656:
1657: BEGIN