DBA Data[Home] [Help]

APPS.FV_SF224_TRANSACTIONS dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 2842: vl_checkrun_name Ap_Inv_Selection_Criteria_All.checkrun_name%TYPE;

2838: l_cursor_id INTEGER;
2839: l_ignore INTEGER;
2840: l_select VARCHAR2(2000);
2841:
2842: vl_checkrun_name Ap_Inv_Selection_Criteria_All.checkrun_name%TYPE;
2843: vl_treasury_symbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
2844: vl_misc_cd_flag VARCHAR2(1);
2845: vl_refund_cnt NUMBER:= 0;
2846:

Line 3942: FROM Ap_Inv_Selection_Criteria_All

3938: IF (vl_checkrun_name IS NOT NULL) THEN -- vl_checkrun
3939: BEGIN
3940: SELECT ce_bank_acct_use_id
3941: INTO vg_bank_acct_id
3942: FROM Ap_Inv_Selection_Criteria_All
3943: WHERE checkrun_name = vl_checkrun_name
3944: AND org_id = l_org_id;
3945: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3946: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 3960: 'bank_account_id from Ap_Inv_Selection_Criteria_All table.';

3956: Set_Exception('D');
3957: GOTO end_label;
3958: WHEN OTHERS THEN
3959: error_buf := SQLERRM||'- Error while deriving the '||
3960: 'bank_account_id from Ap_Inv_Selection_Criteria_All table.';
3961: error_code := 2;
3962: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error17', error_buf) ;
3963: RETURN;
3964: END;