DBA Data[Home] [Help]

APPS.IGS_FI_GEN_005 dependencies on IGS_FI_CONTROL

Line 927: FUNCTION finp_get_receivables_inst RETURN IGS_FI_CONTROL.Rec_Installed%TYPE AS

923: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
924: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
925: END finp_set_pymnt_schdl;
926:
927: FUNCTION finp_get_receivables_inst RETURN IGS_FI_CONTROL.Rec_Installed%TYPE AS
928: ------------------------------------------------------------------
929: --
930: --Change History:
931: --Who When What

Line 933: -- no record has been found in igs_fi_control table

929: --
930: --Change History:
931: --Who When What
932: --smadathi 27-Feb-2002 Bug 2238413. Exception will be raised if
933: -- no record has been found in igs_fi_control table
934: -------------------------------------------------------------------
935: lv_rec_installed IGS_FI_CONTROL.Rec_Installed%TYPE;
936:
937: -- Cursor fro getting the value of the Rec_Installed flag

Line 935: lv_rec_installed IGS_FI_CONTROL.Rec_Installed%TYPE;

931: --Who When What
932: --smadathi 27-Feb-2002 Bug 2238413. Exception will be raised if
933: -- no record has been found in igs_fi_control table
934: -------------------------------------------------------------------
935: lv_rec_installed IGS_FI_CONTROL.Rec_Installed%TYPE;
936:
937: -- Cursor fro getting the value of the Rec_Installed flag
938: -- in the table IGS_FI_CONTROL
939: CURSOR cur_ctrl IS

Line 938: -- in the table IGS_FI_CONTROL

934: -------------------------------------------------------------------
935: lv_rec_installed IGS_FI_CONTROL.Rec_Installed%TYPE;
936:
937: -- Cursor fro getting the value of the Rec_Installed flag
938: -- in the table IGS_FI_CONTROL
939: CURSOR cur_ctrl IS
940: SELECT rec_installed
941: FROM igs_fi_control;
942: BEGIN

Line 941: FROM igs_fi_control;

937: -- Cursor fro getting the value of the Rec_Installed flag
938: -- in the table IGS_FI_CONTROL
939: CURSOR cur_ctrl IS
940: SELECT rec_installed
941: FROM igs_fi_control;
942: BEGIN
943:
944: -- Open the cursor and fetch the value of the REC_INSTALLED flag
945: OPEN cur_ctrl;

Line 947: -- If no records are found in IGS_FI_CONTROL table

943:
944: -- Open the cursor and fetch the value of the REC_INSTALLED flag
945: OPEN cur_ctrl;
946: FETCH cur_ctrl INTO lv_rec_installed;
947: -- If no records are found in IGS_FI_CONTROL table
948: -- exception is raised.
949: IF cur_ctrl%NOTFOUND THEN
950: CLOSE cur_ctrl;
951: FND_MESSAGE.SET_NAME('IGS','IGS_FI_SYSTEM_OPT_SETUP');

Line 966: FUNCTION finp_get_acct_meth RETURN igs_fi_control.accounting_method%TYPE AS

962: lv_rec_installed := NVL(lv_rec_installed,'N');
963: RETURN lv_rec_installed;
964: END finp_get_receivables_inst;
965:
966: FUNCTION finp_get_acct_meth RETURN igs_fi_control.accounting_method%TYPE AS
967: /*|| Created By :Sarakshi
968: || Created On :02-Feb-2002
969: || Purpose : For returning the accounting method.
970: || Known limitations, enhancements or remarks :

Line 979: FROM igs_fi_control;

975: || (reverse chronological order - newest change first) */
976:
977: CURSOR cur_acc IS
978: SELECT manage_accounts,accounting_method
979: FROM igs_fi_control;
980:
981: l_accounting_method igs_fi_control.accounting_method%TYPE;
982: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
983:

Line 981: l_accounting_method igs_fi_control.accounting_method%TYPE;

977: CURSOR cur_acc IS
978: SELECT manage_accounts,accounting_method
979: FROM igs_fi_control;
980:
981: l_accounting_method igs_fi_control.accounting_method%TYPE;
982: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
983:
984: BEGIN
985: OPEN cur_acc;

Line 982: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;

978: SELECT manage_accounts,accounting_method
979: FROM igs_fi_control;
980:
981: l_accounting_method igs_fi_control.accounting_method%TYPE;
982: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
983:
984: BEGIN
985: OPEN cur_acc;
986: FETCH cur_acc INTO l_v_manage_accounts, l_accounting_method;