APPS.PO_DOCUMENT_ACTION_CHECK dependencies on PO_SESSION_GT

Line 1078: , po_session_gt pgt

1074: INTO l_result
1075: FROM po_control_rules pocr
1076: , po_control_groups pocg
1077: , po_position_controls popc
1078: , po_session_gt pgt
1079: WHERE pgt.key = p_session_gt_key
1080: AND pgt.num1 IS NOT NULL
1081: AND pgt.num2 IS NULL -- Bug 4610058
1082: --

Line 1180: , po_session_gt pgt

1176: INTO l_result
1177: FROM po_control_rules pocr
1178: , po_control_groups pocg
1179: , po_position_controls popc
1180: , po_session_gt pgt
1181: WHERE pgt.key = p_session_gt_key
1182: AND pgt.num1 IS NOT NULL
1183: AND pgt.num2 IS NULL -- Bug 4610058
1184: AND pgt.char1 = 'N'

Line 1822: -- 1 - key into po_session_gt table

1818: PO_LOG.stmt(d_module, d_progress, 'l_flex_segment_where', l_flex_segment_where);
1819: END IF;
1820:
1821: -- Bind variables created in sql string:
1822: -- 1 - key into po_session_gt table
1823: -- 2 - p_auth_check_ids.position_id
1824: -- 3 - p_auth_check_ids.job_id
1825: -- 4 - p_auth_check_ids.ctl_function_id
1826: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'

Line 1830: || ' FROM po_session_gt pgt, po_control_rules pocr'

1826: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'
1827:
1828: x_range_check_sql := 'SELECT sign(min(nvl(POCR.amount_limit, -1) '
1829: || ' - sum(' || l_sum_col || ')))'
1830: || ' FROM po_session_gt pgt, po_control_rules pocr'
1831: || ' , po_control_groups pocg, po_position_controls popc'
1832: || l_flex_table
1833: || ' WHERE pgt.key = :1 AND ' || l_sum_col || ' IS NOT NULL'
1834: || ' AND pgt.char1 = ''N'' '

Line 1969: -- 1 - key into po_session_gt table

1965: PO_LOG.stmt(d_module, d_progress, 'l_flex_segment_where', l_flex_segment_where);
1966: END IF;
1967:
1968: -- Bind variables created in sql string:
1969: -- 1 - key into po_session_gt table
1970: -- 2 - p_auth_check_ids.position_id
1971: -- 3 - p_auth_check_ids.job_id
1972: -- 4 - p_auth_check_ids.ctl_function_id
1973: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'

Line 1976: || ' FROM po_session_gt pgt '

1972: -- 4 - p_auth_check_ids.ctl_function_id
1973: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'
1974:
1975: x_range_check_sql := 'SELECT nvl(min(-1),0) '
1976: || ' FROM po_session_gt pgt '
1977: || l_flex_table
1978: || ' WHERE pgt.key = :1 '
1979: || l_flex_join
1980: || ' AND NOT EXISTS ( '

Line 2202: * PO_SESSION_GT:

2198: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2199: END IF;
2200:
2201: /*
2202: * PO_SESSION_GT:
2203: * key = key into table
2204: * num1 = unit total for most checks
2205: * num2 = unit total for item/cat limit checks for PAs only
2206: * num3 = code combination id (for account limit check)

Line 2214: SELECT PO_SESSION_GT_S.nextval INTO x_session_gt_key FROM dual;

2210: * char1 = cancel_flag
2211: * char2 = closed_code
2212: */
2213:
2214: SELECT PO_SESSION_GT_S.nextval INTO x_session_gt_key FROM dual;
2215:
2216: d_progress := 10;
2217: IF (PO_LOG.d_stmt) THEN
2218: PO_LOG.stmt(d_module, d_progress, 'x_session_gt_key', x_session_gt_key);

Line 2226: INSERT INTO PO_SESSION_GT(

2222: THEN
2223:
2224: d_progress := 20;
2225:
2226: INSERT INTO PO_SESSION_GT(
2227: key
2228: , num1
2229: , num2
2230: , num3

Line 2270: INSERT INTO PO_SESSION_GT(

2266: THEN
2267:
2268: d_progress := 30;
2269:
2270: INSERT INTO PO_SESSION_GT(
2271: key
2272: , num1
2273: , num2
2274: , num3

Line 2304: INSERT INTO PO_SESSION_GT(

2300: THEN
2301:
2302: d_progress := 40;
2303:
2304: INSERT INTO PO_SESSION_GT(
2305: key
2306: , num1
2307: , num2
2308: , num3

Line 2341: INSERT INTO PO_SESSION_GT(

2337: THEN
2338:
2339: d_progress := 50;
2340:
2341: INSERT INTO PO_SESSION_GT(
2342: key
2343: , num1
2344: , num2
2345: , num3

Line 2367: INSERT INTO PO_SESSION_GT(

2363: WHERE poh.po_header_id = p_document_id;
2364:
2365: d_progress := 60;
2366:
2367: INSERT INTO PO_SESSION_GT(
2368: key
2369: , num1
2370: , num2
2371: , num3