APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_DOC_STYLE_HELPER

Line 1135: l_is_clm_enabled := po_doc_style_helper.get_clm_flag(p_style_id => p_style_id_tbl(i));

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:
1137: IF (l_po_enc_flag = 'Y' AND l_is_clm_enabled = 'Y' AND Nvl(p_funded_value_tbl(i),0) < 0) THEN
1138:
1139: x_results.add_result(

Line 1251: l_is_clm_enabled := po_doc_style_helper.get_clm_flag(p_style_id => p_style_id_tbl(i));

1247:
1248: END IF;
1249:
1250:
1251: l_is_clm_enabled := po_doc_style_helper.get_clm_flag(p_style_id => p_style_id_tbl(i));
1252:
1253: IF (l_po_enc_flag = 'Y' AND l_is_clm_enabled = 'Y') THEN
1254:
1255: IF (p_quantity_ordered_tbl(i) IS NOT NULL) THEN

Line 1353: l_is_clm_enabled := po_doc_style_helper.get_clm_flag(p_style_id => p_style_id_tbl(i));

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:
1355: IF (l_po_enc_flag = 'Y' AND l_is_clm_enabled = 'Y' AND
1356: (NVL(p_quantity_billed_tbl(i),0) > 0 OR NVL(p_quantity_delivered_tbl(i),0) >0)) THEN
1357:

Line 1448: l_is_clm_enabled := po_doc_style_helper.get_clm_flag(p_style_id => p_style_id_tbl(i));

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:
1450: IF (l_po_enc_flag = 'Y' AND l_is_clm_enabled = 'Y'
1451: --bug 13773450: for lines having matching basis as quantity no need to check these conditions.
1452: AND p_line_matching_basis_tbl(i) <> 'QUANTITY'

Line 1543: l_is_clm_enabled := po_doc_style_helper.get_clm_flag(p_style_id => p_style_id_tbl(i));

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:
1545: IF (l_po_enc_flag = 'Y' AND l_is_clm_enabled = 'Y' AND
1546: p_req_distribution_id_tbl(i) IS NOT NULL) THEN
1547:

Line 1837: AND PO_DOC_STYLE_HELPER.get_clm_flag(p_style_id => p_style_id_tbl(i)) = 'Y'

1833: AND draft_id = Nvl(p_draft_id_tbl(i), -1))
1834: FROM dual
1835: WHERE p_req_dist_id_tbl(i) IS NOT NULL
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)