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.PO_VAL_DISTRIBUTIONS dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 819: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;

815: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
816: , x_result_type OUT NOCOPY VARCHAR2
817: )
818: IS
819: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
820: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
821: l_gl_enc_period_name PO_DISTRIBUTIONS_ALL.gl_encumbered_period_name %TYPE;
822: l_results_count NUMBER;
823: l_gl_encumbered_date DATE;

Line 820: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;

816: , x_result_type OUT NOCOPY VARCHAR2
817: )
818: IS
819: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
820: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
821: l_gl_enc_period_name PO_DISTRIBUTIONS_ALL.gl_encumbered_period_name %TYPE;
822: l_results_count NUMBER;
823: l_gl_encumbered_date DATE;
824: BEGIN

Line 835: FROM financials_system_params_all

831:
832: FOR I IN 1..p_dist_id_tbl.COUNT LOOP
833: SELECT purch_encumbrance_flag, set_of_books_id
834: INTO l_po_enc_flag, l_sob_id
835: FROM financials_system_params_all
836: WHERE org_id = p_org_id_tbl(i);
837:
838: IF (l_po_enc_flag = 'Y' AND p_dist_type_tbl(i) <> 'PREPAYMENT') THEN --Bug 14664343
839: -- GL Date Project: Start

Line 989: l_ledger_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;

985: )
986: IS
987: d_mod CONSTANT VARCHAR2(100) := D_check_fv_validations;
988:
989: l_ledger_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
990: l_return_status VARCHAR2(1);
991: l_error_message VARCHAR2(2000);
992: l_results_count NUMBER;
993: l_result_type VARCHAR2(30);

Line 1015: FROM financials_system_params_all

1011: IF FV_INSTALL.enabled(p_org_id_tbl(i)) THEN
1012:
1013: SELECT set_of_books_id
1014: INTO l_ledger_id
1015: FROM financials_system_params_all
1016: WHERE org_id = p_org_id_tbl(i);
1017:
1018: FV_PO_VALIDATE_GRP.CHECK_AGREEMENT_DATES(
1019: x_code_combination_id => p_ccid_tbl(i),

Line 1109: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;

1105: , x_result_type OUT NOCOPY VARCHAR2
1106: )
1107: IS
1108: d_mod CONSTANT VARCHAR2(100) := D_funded_value_ge_zero;
1109: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
1110: l_results_count NUMBER;
1111: l_is_clm_enabled VARCHAR2(1);
1112: BEGIN
1113:

Line 1132: FROM financials_system_params_all

1128:
1129: FOR I IN 1..p_dist_id_tbl.COUNT LOOP
1130: SELECT purch_encumbrance_flag
1131: INTO l_po_enc_flag
1132: FROM financials_system_params_all
1133: WHERE org_id = p_org_id_tbl(i);
1134:
1135: l_is_clm_enabled := po_doc_style_helper.get_clm_flag(p_style_id => p_style_id_tbl(i));
1136:

Line 1193: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;

1189: , x_result_type OUT NOCOPY VARCHAR2
1190: )
1191: IS
1192: d_mod CONSTANT VARCHAR2(100) := D_funded_val_le_tot_order_val;
1193: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
1194: l_results_count NUMBER;
1195: l_is_clm_enabled VARCHAR2(1);
1196: l_total_order_value NUMBER;
1197:

Line 1230: FROM financials_system_params_all

1226:
1227: FOR I IN 1..p_dist_id_tbl.COUNT LOOP
1228: SELECT purch_encumbrance_flag
1229: INTO l_po_enc_flag
1230: FROM financials_system_params_all
1231: WHERE org_id = p_org_id_tbl(i);
1232:
1233: IF l_func_currency_code IS NULL THEN
1234: -- 13943396 Get currency_code to extract the precision value

Line 1238: financials_system_params_all fsp

1234: -- 13943396 Get currency_code to extract the precision value
1235: SELECT glsob.currency_code
1236: INTO l_func_currency_code
1237: FROM gl_sets_of_books glsob,
1238: financials_system_params_all fsp
1239: WHERE glsob.set_of_books_id = fsp.set_of_books_id
1240: AND fsp.org_id = p_org_id_tbl(i);
1241:
1242: --13943396 Extract the precision value to round the Funded value

Line 1326: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;

1322: , x_result_type OUT NOCOPY VARCHAR2
1323: )
1324: IS
1325: d_mod CONSTANT VARCHAR2(100) := D_qty_funded_ge_exc_qty;
1326: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
1327: l_results_count NUMBER;
1328: l_is_clm_enabled VARCHAR2(1);
1329: BEGIN
1330:

Line 1350: FROM financials_system_params_all

1346:
1347: FOR I IN 1..p_dist_id_tbl.COUNT LOOP
1348: SELECT purch_encumbrance_flag
1349: INTO l_po_enc_flag
1350: FROM financials_system_params_all
1351: WHERE org_id = p_org_id_tbl(i);
1352:
1353: l_is_clm_enabled := po_doc_style_helper.get_clm_flag(p_style_id => p_style_id_tbl(i));
1354:

Line 1421: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;

1417: , x_result_type OUT NOCOPY VARCHAR2
1418: )
1419: IS
1420: d_mod CONSTANT VARCHAR2(100) := D_amount_funded_ge_exc_amount;
1421: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
1422: l_results_count NUMBER;
1423: l_is_clm_enabled VARCHAR2(1);
1424: BEGIN
1425:

Line 1445: FROM financials_system_params_all

1441:
1442: FOR I IN 1..p_dist_id_tbl.COUNT LOOP
1443: SELECT purch_encumbrance_flag
1444: INTO l_po_enc_flag
1445: FROM financials_system_params_all
1446: WHERE org_id = p_org_id_tbl(i);
1447:
1448: l_is_clm_enabled := po_doc_style_helper.get_clm_flag(p_style_id => p_style_id_tbl(i));
1449:

Line 1516: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;

1512: , x_result_type OUT NOCOPY VARCHAR2
1513: )
1514: IS
1515: d_mod CONSTANT VARCHAR2(100) := D_funded_value_gt_backing_req;
1516: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
1517: l_results_count NUMBER;
1518: l_is_clm_enabled VARCHAR2(1);
1519: l_backing_req_fund_value NUMBER;
1520: BEGIN

Line 1540: FROM financials_system_params_all

1536:
1537: FOR I IN 1..p_dist_id_tbl.COUNT LOOP
1538: SELECT purch_encumbrance_flag
1539: INTO l_po_enc_flag
1540: FROM financials_system_params_all
1541: WHERE org_id = p_org_id_tbl(i);
1542:
1543: l_is_clm_enabled := po_doc_style_helper.get_clm_flag(p_style_id => p_style_id_tbl(i));
1544:

Line 1840: FROM FINANCIALS_SYSTEM_PARAMS_ALL

1836: AND p_dist_type_tbl(i) = c_STANDARD
1837: AND PO_DOC_STYLE_HELPER.get_clm_flag(p_style_id => p_style_id_tbl(i)) = 'Y'
1838: AND EXISTS(
1839: SELECT NULL
1840: FROM FINANCIALS_SYSTEM_PARAMS_ALL
1841: WHERE org_id = p_org_id_tbl(i)
1842: AND purch_encumbrance_flag = 'Y'
1843: AND req_encumbrance_flag = 'Y');
1844: