[Home] [Help]
1090: INTO l_result
1091: FROM po_control_rules pocr
1092: , po_control_groups pocg
1093: , po_position_controls popc
1094: , po_session_gt pgt
1095: WHERE pgt.key = p_session_gt_key
1096: AND pgt.num1 IS NOT NULL
1097: AND pgt.num2 IS NULL -- Bug 4610058
1098: --
1192: INTO l_result
1193: FROM po_control_rules pocr
1194: , po_control_groups pocg
1195: , po_position_controls popc
1196: , po_session_gt pgt
1197: WHERE pgt.key = p_session_gt_key
1198: AND pgt.num1 IS NOT NULL
1199: AND pgt.num2 IS NULL -- Bug 4610058
1200: AND pgt.char1 = 'N'
1842: PO_LOG.stmt(d_module, d_progress, 'l_flex_segment_where', l_flex_segment_where);
1843: END IF;
1844:
1845: -- Bind variables created in sql string:
1846: -- 1 - key into po_session_gt table
1847: -- 2 - p_auth_check_ids.position_id
1848: -- 3 - p_auth_check_ids.job_id
1849: -- 4 - p_auth_check_ids.ctl_function_id
1850: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'
1852: x_range_check_sql := 'SELECT '
1853: || l_hint -- bug 12359144
1854: || ' sign(min(nvl(POCR.amount_limit, -1) '
1855: || ' - sum(' || l_sum_col || ')))'
1856: || ' FROM po_session_gt pgt, po_control_rules pocr'
1857: || ' , po_control_groups pocg, po_position_controls popc'
1858: || l_flex_table
1859: || ' WHERE pgt.key = :1 AND ' || l_sum_col || ' IS NOT NULL'
1860: || ' AND pgt.char1 = DECODE(POCR.RULE_TYPE_CODE,''INCLUDE'',nvl(pgt.char1, ''N''),''EXCLUDE'',''N'') ' --Bug 13835378 fix
1991: PO_LOG.stmt(d_module, d_progress, 'l_flex_segment_where', l_flex_segment_where);
1992: END IF;
1993:
1994: -- Bind variables created in sql string:
1995: -- 1 - key into po_session_gt table
1996: -- 2 - p_auth_check_ids.position_id
1997: -- 3 - p_auth_check_ids.job_id
1998: -- 4 - p_auth_check_ids.ctl_function_id
1999: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'
1998: -- 4 - p_auth_check_ids.ctl_function_id
1999: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'
2000:
2001: x_range_check_sql := 'SELECT nvl(min(-1),0) '
2002: || ' FROM po_session_gt pgt '
2003: || l_flex_table
2004: || ' WHERE pgt.key = :1 '
2005: || ' AND pgt.char1 = ''N'' ' --Bug 13835378 fix. Cancelled lines should not be considered.
2006: || l_flex_join
2231: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2232: END IF;
2233:
2234: /*
2235: * PO_SESSION_GT:
2236: * key = key into table
2237: * num1 = unit total for most checks
2238: * num2 = unit total for item/cat limit checks for PAs only
2239: * num3 = code combination id (for account limit check)
2243: * char1 = cancel_flag
2244: * char2 = closed_code
2245: */
2246:
2247: SELECT PO_SESSION_GT_S.nextval INTO x_session_gt_key FROM dual;
2248:
2249: d_progress := 10;
2250: IF (PO_LOG.d_stmt) THEN
2251: PO_LOG.stmt(d_module, d_progress, 'x_session_gt_key', x_session_gt_key);
2256: THEN
2257:
2258: d_progress := 20;
2259:
2260: INSERT INTO PO_SESSION_GT(
2261: key
2262: , num1
2263: , num2
2264: , num3
2302:
2303: /* bug 16168687 : replacing function get_req_distribution_total with
2304: get_req_dist_total*/
2305:
2306: INSERT INTO PO_SESSION_GT(
2307: key
2308: , num1
2309: , num2
2310: , num3
2336: THEN
2337:
2338: d_progress := 40;
2339:
2340: INSERT INTO PO_SESSION_GT(
2341: key
2342: , num1
2343: , num2
2344: , num3
2373: THEN
2374:
2375: d_progress := 50;
2376:
2377: INSERT INTO PO_SESSION_GT(
2378: key
2379: , num1
2380: , num2
2381: , num3
2399: WHERE poh.po_header_id = p_document_id;
2400:
2401: d_progress := 60;
2402:
2403: INSERT INTO PO_SESSION_GT(
2404: key
2405: , num1
2406: , num2
2407: , num3