DBA Data[Home] [Help]

APPS.PO_CLM_COLS_SUB_CHECK dependencies on PO_CLM_CLO_UTIL

Line 64: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

60: RAISE;
61: END;
62:
63: d_progress := 50;
64: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
65: FOR c_get_po_lines_rec IN c_get_po_lines(p_document_id) LOOP
66: IF c_get_po_lines_rec.IDV_HEADER_ID IS NOT NULL
67: AND c_get_po_lines_rec.IDV_LINE_ID IS NOT NULL
68: THEN

Line 197: IF l_document_type_code = 'BLANKET' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

193: RAISE;
194: END;
195:
196: d_progress := 50;
197: IF l_document_type_code = 'BLANKET' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
198: d_progress := 60;
199: BEGIN
200: SELECT CLM_MAX_ORDER_AMOUNT, AMOUNT_LIMIT
201: INTO l_idv_max_ord_amt, l_amt_limit

Line 337: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

333: RAISE;
334: END;
335:
336: d_progress := 50;
337: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
338: FOR c_get_po_lines_rec IN c_get_po_lines(p_document_id) LOOP
339: IF c_get_po_lines_rec.FROM_LINE_ID IS NOT NULL THEN
340:
341: d_progress := 60;

Line 477: IF l_document_type_code = 'BLANKET' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

473: RAISE;
474: END;
475:
476: d_progress := 50;
477: IF l_document_type_code = 'BLANKET' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
478: d_progress := 60;
479: BEGIN
480:
481: SELECT START_DATE, END_DATE

Line 750: IF l_document_type_code = 'BLANKET' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

746: RAISE;
747: END;
748:
749: d_progress := 50;
750: IF l_document_type_code = 'BLANKET' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
751: FOR c_get_po_lines_rec IN c_get_po_lines(p_document_id) LOOP
752: d_progress := 60;
753: PO_UDA_DEFAULTING_PKG.DEBUG('CLM_MIN_ORDER_QUANTITY :' || c_get_po_lines_rec.CLM_MIN_ORDER_QUANTITY , d_progress);
754: PO_UDA_DEFAULTING_PKG.DEBUG('CLM_MAX_ORDER_QUANTITY :' || c_get_po_lines_rec.CLM_MAX_ORDER_QUANTITY , d_progress);

Line 864: IF l_document_type_code = 'BLANKET' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

860: RAISE;
861: END;
862:
863: d_progress := 50;
864: IF l_document_type_code = 'BLANKET' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
865: FOR c_get_po_lines_rec IN c_get_po_lines(p_document_id) LOOP
866: d_progress := 60;
867: PO_UDA_DEFAULTING_PKG.DEBUG('CLM_MIN_ORDER_AMOUNT :' || c_get_po_lines_rec.CLM_MIN_ORDER_AMOUNT , d_progress);
868: PO_UDA_DEFAULTING_PKG.DEBUG('CLM_MAX_ORDER_AMOUNT :' || c_get_po_lines_rec.CLM_MAX_ORDER_AMOUNT , d_progress);

Line 1006: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

1002: RAISE;
1003: END;
1004:
1005: d_progress := 50;
1006: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
1007: FOR c_get_po_lines_rec IN c_get_po_lines(p_document_id) LOOP
1008: IF c_get_po_lines_rec.IDV_LINE_ID IS NOT NULL THEN
1009: d_progress := 60;
1010: BEGIN

Line 1143: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

1139: RAISE;
1140: END;
1141:
1142: d_progress := 50;
1143: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
1144: FOR c_get_po_lines_rec IN c_get_po_lines(p_document_id) LOOP
1145: IF c_get_po_lines_rec.IDV_LINE_ID IS NOT NULL THEN
1146: d_progress := 60;
1147: BEGIN

Line 1318: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

1314: RAISE;
1315: END;
1316:
1317: d_progress := 50;
1318: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
1319: FOR c_get_po_lines_rec IN c_get_po_lines(p_document_id) LOOP
1320: IF c_get_po_lines_rec.IDV_LINE_ID IS NOT NULL THEN
1321: d_progress := 60;
1322: BEGIN

Line 1454: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

1450: RAISE;
1451: END;
1452:
1453: d_progress := 50;
1454: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
1455:
1456: SELECT NVL(clm_amount_released, 0), amount_limit
1457: INTO l_clm_amt_released, l_amount_limit
1458: FROM PO_HEADERS_ALL

Line 1568: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

1564: RAISE;
1565: END;
1566:
1567: d_progress := 50;
1568: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
1569: l_total_amt := getAmountOrderedForIDV
1570: (
1571: p_level => 'HEADER'
1572: ,p_doc_level_id => p_document_id

Line 1703: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

1699: RAISE;
1700: END;
1701:
1702: d_progress := 50;
1703: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
1704: d_progress := 60;
1705: BEGIN
1706:
1707: IF l_source_id IS NOT NULL THEN

Line 1844: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN

1840: RAISE;
1841: END;
1842:
1843: d_progress := 50;
1844: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
1845: d_progress := 60;
1846: BEGIN
1847:
1848: IF l_source_id IS NOT NULL THEN