eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_SF224_TRANSACTIONS dependencies on AP_CHECKS_ALL

Line 31: g_payment_type_flag ap_checks_all.PAYMENT_TYPE_FLAG%TYPE;

27: g_enter VARCHAR2(10);
28: g_exit VARCHAR2(10);
29: g_sysdate DATE;
30:
31: g_payment_type_flag ap_checks_all.PAYMENT_TYPE_FLAG%TYPE;
32: g_check_void_date DATE;
33: g_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
34:
35: sob NUMBER;

Line 2752: l_void_check_number ap_checks_all.void_check_number%TYPE;

2748: l_gwa_reporter_category_code fv_alc_gwa_categories.gwa_reporter_category_code%TYPE;
2749: l_alc_addresses_id fv_alc_addresses_all.fv_alc_addresses_id%TYPE;
2750:
2751: --Added for reclassification changes
2752: l_void_check_number ap_checks_all.void_check_number%TYPE;
2753: l_voided_reclassified_payment VARCHAR2(1);
2754: l_reclass_receipt_number ar_cash_receipts_all.receipt_number%TYPE;
2755: l_receipt_reclassified VARCHAR2(1);
2756: l_ar_reclass_attribute VARCHAR2(15);

Line 3028: FROM ap_checks_all

3024:
3025: BEGIN
3026: SELECT checkrun_name
3027: INTO l_document_number
3028: FROM ap_checks_all
3029: WHERE check_id = TO_NUMBER(l_reference_3);
3030: EXCEPTION WHEN NO_DATA_FOUND THEN
3031: SELECT SUBSTR(name,1,50)
3032: INTO l_document_number

Line 3209: from ap_checks_all

3205: ELSE
3206: BEGIN
3207: select 'Y', payment_type_flag, void_date
3208: into l_exists, g_payment_type_flag, g_check_void_date
3209: from ap_checks_all
3210: Where check_id = to_number(l_REFERENCE_3) ;
3211: EXCEPTION
3212: when no_data_found then
3213: x_name := 'Invalid Check Id - ' || l_reference_3 ;

Line 3409: FROM ap_checks_all

3405: -- get the document number
3406: BEGIN
3407: SELECT checkrun_name
3408: INTO l_document_number
3409: FROM ap_checks_all
3410: WHERE check_id = to_number(l_reference_3);
3411: EXCEPTION
3412: WHEN NO_DATA_FOUND THEN
3413: SELECT SUBSTR(name,1,50)

Line 3425: from AP_CHECKS_ALL

3421: ELSE
3422: BEGIN
3423: select 'Y'
3424: into l_exists
3425: from AP_CHECKS_ALL
3426: Where check_id = to_number(l_reference_3);
3427: Exception
3428: when no_data_found then
3429: x_name := 'Invalid Check Id - ' || l_reference_3 ;

Line 3729: FROM Ap_Checks_All

3725: END IF;
3726: BEGIN
3727: SELECT ce_bank_acct_use_id
3728: INTO vg_bank_acct_id
3729: FROM Ap_Checks_All
3730: WHERE check_id = TO_NUMBER(l_reference_3);
3731: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3732: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOUND THE BANK ACCOUNT ID');
3733: END IF;

Line 3745: 'bank_account_id from Ap_Checks_All table.';

3741: Set_Exception('D');
3742: GOTO end_label;
3743: WHEN OTHERS THEN
3744: error_buf := SQLERRM||'- Error while deriving the '||
3745: 'bank_account_id from Ap_Checks_All table.';
3746: error_code := 2;
3747: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error14', error_buf) ;
3748: RETURN;
3749: END;

Line 3870: FROM Ap_Checks_All

3866: END IF; -- ref6-2
3867: BEGIN
3868: SELECT ce_bank_acct_use_id
3869: INTO vg_bank_acct_id
3870: FROM Ap_Checks_All
3871: WHERE check_id = TO_NUMBER(l_reference_3);
3872: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3873: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOUND THE BANK ACCOUNT ID');
3874: END IF;

Line 3882: 'bank_account_id from Ap_Checks_All table.';

3878: Set_Exception('D');
3879: GOTO end_label;
3880: WHEN OTHERS THEN
3881: error_buf := SQLERRM||'- Error while deriving the '||
3882: 'bank_account_id from Ap_Checks_All table.';
3883: error_code := 2;
3884: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error19', error_buf) ;
3885: RETURN;
3886: END;

Line 3954: FROM ap_checks_all apc,

3950: INTO l_invoice_id ,
3951: l_vendor_id,
3952: l_inv_amount,
3953: l_check_date
3954: FROM ap_checks_all apc,
3955: ap_invoices_all api
3956: WHERE api.invoice_id = NVL(l_reference, 0)
3957: AND apc.check_id = to_number(l_reference_3)
3958: AND l_payables_ia_paygroup = api.pay_group_lookup_code

Line 3983: FROM Ap_Checks_All

3979: l_error_stage := 1;
3980: BEGIN
3981: SELECT ce_bank_acct_use_id
3982: INTO vg_bank_acct_id
3983: FROM Ap_Checks_All
3984: WHERE check_id = TO_NUMBER(l_reference_3);
3985: EXCEPTION
3986: WHEN NO_DATA_FOUND THEN
3987: -- Unable to find the bank_account_id

Line 3991: 'bank_account_id from Ap_Checks_All table when '||

3987: -- Unable to find the bank_account_id
3988: Set_Exception('D');
3989: WHEN OTHERS THEN
3990: error_buf := SQLERRM||'- Error while deriving the '||
3991: 'bank_account_id from Ap_Checks_All table when '||
3992: 'category<>Trea Conf.';
3993: error_code := 2;
3994: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error24', error_buf) ;
3995: RETURN;

Line 4030: FROM ap_checks_all apc,

4026: SELECT nvl(apc.treasury_pay_date,apc.check_date),
4027: apc.void_date
4028: INTO l_accomplish_date,
4029: l_void_date
4030: FROM ap_checks_all apc,
4031: ap_invoices_all api
4032: WHERE api.invoice_id = Nvl(l_reference, 0)
4033: AND apc.check_id = nvl(l_reference_3,0);
4034: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4179: FROM ap_checks_all

4175: BEGIN
4176: -- check_id
4177: SELECT void_date
4178: INTO l_accomplish_date
4179: FROM ap_checks_all
4180: WHERE check_id = To_number (nvl(l_reference_3,'0')) ;
4181: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4182: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4183: 'VOID DATE/ACCOMPLISH DATE IS '||

Line 4214: FROM Ap_Checks_All

4210: END ;
4211: BEGIN
4212: SELECT ce_bank_acct_use_id
4213: INTO vg_bank_acct_id
4214: FROM Ap_Checks_All
4215: WHERE check_id = TO_NUMBER(l_reference_3);
4216: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4217: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOUND THE BANK ACCT ID');
4218: END IF;

Line 4229: 'bank_account_id from Ap_Checks_All table when name like VOID.';

4225: END IF;
4226: Set_Exception('D');
4227: WHEN OTHERS THEN
4228: error_buf := SQLERRM||'- Error while deriving the '||
4229: 'bank_account_id from Ap_Checks_All table when name like VOID.';
4230: error_code := 2;
4231: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error29', error_buf) ;
4232: RETURN;
4233: END;

Line 4387: FROM ap_checks_all apc

4383: AND l_reference_2 IS NOT NULL AND l_reference_3 IS NOT NULL AND l_reference_9 IS NOT NULL THEN
4384: BEGIN
4385: SELECT apc.void_check_number /* replace attribute1 with new field name */
4386: INTO l_void_check_number
4387: FROM ap_checks_all apc
4388: WHERE apc.check_id = to_number(l_reference_3);
4389: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4390: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Void Check Number : '|| l_void_check_number );
4391: END IF;

Line 5460: ap_checks_all apc,

5456: FROM po_distributions
5457: WHERE po_distribution_id = apid.po_distribution_id)))
5458: obligation_number
5459: FROM
5460: ap_checks_all apc,
5461: ap_invoice_payments_all apip,
5462: ap_invoices_all api,
5463: ap_invoice_distributions_all apid
5464: WHERE apip.set_of_books_id = l_set_of_books_id