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.AP_IMPORT_VALIDATION_PKG dependencies on FND_PLSQL_CACHE

Line 15270: l_valueOut fnd_plsql_cache.generic_cache_value_type;

15266: l_period_name VARCHAR2(15);
15267: l_dummy VARCHAR2(100);
15268: l_key VARCHAR2(1000);
15269: l_numof_values NUMBER;
15270: l_valueOut fnd_plsql_cache.generic_cache_value_type;
15271: l_values fnd_plsql_cache.generic_cache_values_type;
15272: l_ret_code VARCHAR2(1);
15273: l_exception VARCHAR2(10);
15274: l_current_invoice_status VARCHAR2(1) := 'Y';

Line 15271: l_values fnd_plsql_cache.generic_cache_values_type;

15267: l_dummy VARCHAR2(100);
15268: l_key VARCHAR2(1000);
15269: l_numof_values NUMBER;
15270: l_valueOut fnd_plsql_cache.generic_cache_value_type;
15271: l_values fnd_plsql_cache.generic_cache_values_type;
15272: l_ret_code VARCHAR2(1);
15273: l_exception VARCHAR2(10);
15274: l_current_invoice_status VARCHAR2(1) := 'Y';
15275: l_accounting_date DATE := p_invoice_lines_rec.accounting_date;

Line 15354: fnd_plsql_cache.generic_1tom_get_values(

15350: l_key := TO_CHAR(p_set_of_books_id)||' '||
15351: TO_CHAR(NVL(l_accounting_date,
15352: AP_IMPORT_INVOICES_PKG.g_inv_sysdate),'dd-mm-yyyy');
15353:
15354: fnd_plsql_cache.generic_1tom_get_values(
15355: AP_IMPORT_INVOICES_PKG.lg_many_controller,
15356: AP_IMPORT_INVOICES_PKG.lg_generic_storage,
15357: l_key,
15358: l_numof_values,

Line 15402: fnd_plsql_cache.generic_1tom_put_values(

15398: l_valueOut.varchar2_2 := l_exception;
15399: l_values(1) := l_valueOut;
15400: l_numof_values := 1;
15401:
15402: fnd_plsql_cache.generic_1tom_put_values(
15403: AP_IMPORT_INVOICES_PKG.lg_many_controller,
15404: AP_IMPORT_INVOICES_PKG.lg_generic_storage,
15405: l_key,
15406: l_numof_values,

Line 15435: fnd_plsql_cache.generic_1tom_put_values(

15431: l_valueOut.varchar2_2 := l_exception;
15432: l_values(1) := l_valueOut;
15433: l_numof_values := 1;
15434:
15435: fnd_plsql_cache.generic_1tom_put_values(
15436: AP_IMPORT_INVOICES_PKG.lg_many_controller,
15437: AP_IMPORT_INVOICES_PKG.lg_generic_storage,
15438: l_key,
15439: l_numof_values,

Line 15568: l_valueOut fnd_plsql_cache.generic_cache_value_type;

15564: current_calling_sequence VARCHAR2(2000);
15565: debug_info VARCHAR2(500);
15566: l_key VARCHAR2(1000);
15567: l_numof_values NUMBER;
15568: l_valueOut fnd_plsql_cache.generic_cache_value_type;
15569: l_values fnd_plsql_cache.generic_cache_values_type;
15570: l_ret_code VARCHAR2(1);
15571: l_validate_res VARCHAR2(10);
15572:

Line 15569: l_values fnd_plsql_cache.generic_cache_values_type;

15565: debug_info VARCHAR2(500);
15566: l_key VARCHAR2(1000);
15567: l_numof_values NUMBER;
15568: l_valueOut fnd_plsql_cache.generic_cache_value_type;
15569: l_values fnd_plsql_cache.generic_cache_values_type;
15570: l_ret_code VARCHAR2(1);
15571: l_validate_res VARCHAR2(10);
15572:
15573: BEGIN

Line 15950: fnd_plsql_cache.generic_1tom_get_values(

15946:
15947: l_key := to_char(nvl(p_chart_of_accounts_id,0))||' '
15948: ||l_pa_concatenated_segments||' '
15949: ||to_char(AP_IMPORT_INVOICES_PKG.g_inv_sysdate,'dd-mm-yyyy');
15950: fnd_plsql_cache.generic_1tom_get_values(
15951: AP_IMPORT_INVOICES_PKG.lg_many_controller1,
15952: AP_IMPORT_INVOICES_PKG.lg_generic_storage1,
15953: l_key,
15954: l_numof_values,

Line 16000: fnd_plsql_cache.generic_1tom_put_values(

15996: l_valueOut.varchar2_3 := l_reason_unbuilt_flex;
15997: l_values(1) := l_valueOut;
15998: l_numof_values := 1;
15999:
16000: fnd_plsql_cache.generic_1tom_put_values(
16001: AP_IMPORT_INVOICES_PKG.lg_many_controller1,
16002: AP_IMPORT_INVOICES_PKG.lg_generic_storage1,
16003: l_key,
16004: l_numof_values,

Line 16143: l_valueOut fnd_plsql_cache.generic_cache_value_type;

16139: l_unbuilt_flex VARCHAR2(240):='';
16140: l_reason_unbuilt_flex VARCHAR2(2000):='';
16141: l_key VARCHAR2(1000);
16142: l_numof_values NUMBER;
16143: l_valueOut fnd_plsql_cache.generic_cache_value_type;
16144: l_values fnd_plsql_cache.generic_cache_values_type;
16145: l_ret_code VARCHAR2(1);
16146: l_validate_res VARCHAR2(10);
16147: current_calling_sequence VARCHAR2(2000);

Line 16144: l_values fnd_plsql_cache.generic_cache_values_type;

16140: l_reason_unbuilt_flex VARCHAR2(2000):='';
16141: l_key VARCHAR2(1000);
16142: l_numof_values NUMBER;
16143: l_valueOut fnd_plsql_cache.generic_cache_value_type;
16144: l_values fnd_plsql_cache.generic_cache_values_type;
16145: l_ret_code VARCHAR2(1);
16146: l_validate_res VARCHAR2(10);
16147: current_calling_sequence VARCHAR2(2000);
16148: debug_info VARCHAR2(500);

Line 16347: fnd_plsql_cache.generic_1tom_get_values(

16343: l_key := TO_CHAR(NVL(p_chart_of_accounts_id,0))||' '||
16344: p_invoice_lines_rec.dist_code_concatenated||' '||
16345: to_char(p_accounting_date,'dd-mm-yyyy');
16346:
16347: fnd_plsql_cache.generic_1tom_get_values(
16348: AP_IMPORT_INVOICES_PKG.lg_many_controller1,
16349: AP_IMPORT_INVOICES_PKG.lg_generic_storage1,
16350: l_key,
16351: l_numof_values,

Line 16390: fnd_plsql_cache.generic_1tom_put_values(

16386: l_valueOut.varchar2_2 := l_validate_res;
16387: l_values(1) := l_valueOut;
16388: l_numof_values := 1;
16389:
16390: fnd_plsql_cache.generic_1tom_put_values(
16391: AP_IMPORT_INVOICES_PKG.lg_many_controller1,
16392: AP_IMPORT_INVOICES_PKG.lg_generic_storage1,
16393: l_key,
16394: l_numof_values,

Line 18906: l_valueOut fnd_plsql_cache.generic_cache_value_type;

18902: debug_info VARCHAR2(500);
18903: -- Bug 5572876. Caching Income Tax Type and Income Tax Region
18904: l_key VARCHAR2(1000);
18905: l_numof_values NUMBER;
18906: l_valueOut fnd_plsql_cache.generic_cache_value_type;
18907: l_values fnd_plsql_cache.generic_cache_values_type;
18908: l_ret_code VARCHAR2(1);
18909: l_exception VARCHAR2(10);
18910: l_key1 VARCHAR2(1000);

Line 18907: l_values fnd_plsql_cache.generic_cache_values_type;

18903: -- Bug 5572876. Caching Income Tax Type and Income Tax Region
18904: l_key VARCHAR2(1000);
18905: l_numof_values NUMBER;
18906: l_valueOut fnd_plsql_cache.generic_cache_value_type;
18907: l_values fnd_plsql_cache.generic_cache_values_type;
18908: l_ret_code VARCHAR2(1);
18909: l_exception VARCHAR2(10);
18910: l_key1 VARCHAR2(1000);
18911: l_numof_values1 NUMBER;

Line 18912: l_valueOut1 fnd_plsql_cache.generic_cache_value_type;

18908: l_ret_code VARCHAR2(1);
18909: l_exception VARCHAR2(10);
18910: l_key1 VARCHAR2(1000);
18911: l_numof_values1 NUMBER;
18912: l_valueOut1 fnd_plsql_cache.generic_cache_value_type;
18913: l_values1 fnd_plsql_cache.generic_cache_values_type;
18914: l_ret_code1 VARCHAR2(1);
18915: l_exception1 VARCHAR2(10);
18916: l_income_tax_type ap_income_tax_types.income_tax_type%TYPE;

Line 18913: l_values1 fnd_plsql_cache.generic_cache_values_type;

18909: l_exception VARCHAR2(10);
18910: l_key1 VARCHAR2(1000);
18911: l_numof_values1 NUMBER;
18912: l_valueOut1 fnd_plsql_cache.generic_cache_value_type;
18913: l_values1 fnd_plsql_cache.generic_cache_values_type;
18914: l_ret_code1 VARCHAR2(1);
18915: l_exception1 VARCHAR2(10);
18916: l_income_tax_type ap_income_tax_types.income_tax_type%TYPE;
18917: l_income_tax_region ap_income_tax_regions.region_short_name%TYPE;

Line 19030: fnd_plsql_cache.generic_1tom_get_values(

19026: -- Invalid Info
19027:
19028: l_key := p_invoice_lines_rec.type_1099;
19029:
19030: fnd_plsql_cache.generic_1tom_get_values(
19031: AP_IMPORT_INVOICES_PKG.lg_incometax_controller,
19032: AP_IMPORT_INVOICES_PKG.lg_incometax_storage,
19033: l_key,
19034: l_numof_values,

Line 19081: fnd_plsql_cache.generic_1tom_put_values(

19077: l_valueOut.varchar2_2 := l_exception;
19078: l_values(1) := l_valueOut;
19079: l_numof_values := 1;
19080:
19081: fnd_plsql_cache.generic_1tom_put_values(
19082: AP_IMPORT_INVOICES_PKG.lg_incometax_controller,
19083: AP_IMPORT_INVOICES_PKG.lg_incometax_storage,
19084: l_key,
19085: l_numof_values,

Line 19118: fnd_plsql_cache.generic_1tom_put_values(

19114: l_valueOut.varchar2_2 := l_exception;
19115: l_values(1) := l_valueOut;
19116: l_numof_values := 1;
19117:
19118: fnd_plsql_cache.generic_1tom_put_values(
19119: AP_IMPORT_INVOICES_PKG.lg_incometax_controller,
19120: AP_IMPORT_INVOICES_PKG.lg_incometax_storage,
19121: l_key,
19122: l_numof_values,

Line 19146: fnd_plsql_cache.generic_1tom_get_values(

19142:
19143: -- Invalid Info
19144: l_key1 := p_invoice_lines_rec.income_tax_region;
19145:
19146: fnd_plsql_cache.generic_1tom_get_values(
19147: AP_IMPORT_INVOICES_PKG.lg_incometaxr_controller,
19148: AP_IMPORT_INVOICES_PKG.lg_incometaxr_storage,
19149: l_key1,
19150: l_numof_values1,

Line 19198: fnd_plsql_cache.generic_1tom_put_values(

19194: l_valueOut1.varchar2_2 := l_exception1;
19195: l_values1(1) := l_valueOut1;
19196: l_numof_values1 := 1;
19197:
19198: fnd_plsql_cache.generic_1tom_put_values(
19199: AP_IMPORT_INVOICES_PKG.lg_incometaxr_controller,
19200: AP_IMPORT_INVOICES_PKG.lg_incometaxr_storage,
19201: l_key1,
19202: l_numof_values1,

Line 19232: fnd_plsql_cache.generic_1tom_put_values(

19228: l_valueOut1.varchar2_2 := l_exception1;
19229: l_values1(1) := l_valueOut1;
19230: l_numof_values1 := 1;
19231:
19232: fnd_plsql_cache.generic_1tom_put_values(
19233: AP_IMPORT_INVOICES_PKG.lg_incometaxr_controller,
19234: AP_IMPORT_INVOICES_PKG.lg_incometaxr_storage,
19235: l_key1,
19236: l_numof_values1,