APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_ACTION_HISTORY

Line 1305: UPDATE po_action_history poah

1301: THEN
1302:
1303: d_progress := 50;
1304:
1305: UPDATE po_action_history poah
1306: SET poah.action_code = p_action
1307: , poah.action_date = SYSDATE
1308: , poah.offline_code = NULL
1309: , poah.employee_id = l_emp_id

Line 1341: UPDATE po_action_history poah

1337: THEN
1338:
1339: d_progress := 110;
1340:
1341: UPDATE po_action_history poah
1342: SET poah.sequence_num = poah.sequence_num + 1
1343: WHERE poah.object_id = p_document_id
1344: AND poah.object_type_code = p_document_type
1345: AND poah.object_sub_type_code = p_document_subtype

Line 1355: FROM po_action_history poah

1351: -- Ported it over, as it will fix a PDOI issue.
1352:
1353: SELECT count(1)
1354: INTO l_count_hist
1355: FROM po_action_history poah
1356: WHERE poah.object_id = p_document_id
1357: AND poah.object_type_code = p_document_type
1358: AND poah.object_sub_type_code = p_document_subtype
1359: AND poah.action_code IS NOT NULL;

Line 1376: INSERT INTO po_action_history(

1372: -- Used Pro*C insert statement, as it was more accurate
1373: -- This SQL comes from: pocah.lpc
1374: -- The one in old POXPOACB.pls was incorrect.
1375:
1376: INSERT INTO po_action_history(
1377: object_id
1378: , object_type_code
1379: , object_sub_type_code
1380: , sequence_num

Line 1421: FROM po_action_history poah

1417: , 0
1418: , ''
1419: , 0
1420: , ''
1421: FROM po_action_history poah
1422: WHERE poah.object_id = p_document_id
1423: AND poah.object_type_code = p_document_type
1424: AND poah.object_sub_type_code = p_document_subtype
1425: AND poah.action_code IS NOT NULL

Line 1448: INSERT INTO po_action_history(

1444: IF (PO_LOG.d_stmt) THEN
1445: PO_LOG.stmt(d_module, d_progress, 'l_revision_num', l_revision_num);
1446: END IF;
1447:
1448: INSERT INTO po_action_history(
1449: object_id
1450: , object_type_code
1451: , object_sub_type_code
1452: , sequence_num

Line 2336: l_sequence_num PO_ACTION_HISTORY.sequence_num%TYPE;

2332: , x_return_status OUT NOCOPY VARCHAR2
2333: )
2334: IS
2335:
2336: l_sequence_num PO_ACTION_HISTORY.sequence_num%TYPE;
2337:
2338: d_progress NUMBER;
2339: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.insert_auth_action_history';
2340:

Line 2366: FROM PO_ACTION_HISTORY poah

2362: -- CLM Apprvl
2363: IF p_draft_id IS NOT NULL AND p_draft_id <> -1 THEN
2364: SELECT max(poah.sequence_num) + 1
2365: INTO l_sequence_num
2366: FROM PO_ACTION_HISTORY poah
2367: WHERE poah.object_type_code = p_document_type
2368: AND poah.object_sub_type_code = 'MODIFICATION'
2369: AND poah.object_id = p_draft_id;
2370: ELSE

Line 2373: FROM PO_ACTION_HISTORY poah

2369: AND poah.object_id = p_draft_id;
2370: ELSE
2371: SELECT max(poah.sequence_num) + 1
2372: INTO l_sequence_num
2373: FROM PO_ACTION_HISTORY poah
2374: WHERE poah.object_type_code = p_document_type
2375: AND poah.object_id = p_document_id;
2376: END IF;
2377:

Line 2395: INSERT INTO PO_ACTION_HISTORY

2391: --
2392:
2393: d_progress := 20;
2394:
2395: INSERT INTO PO_ACTION_HISTORY
2396: ( object_id
2397: , object_type_code
2398: , object_sub_type_code
2399: , sequence_num

Line 2499: UPDATE PO_ACTION_HISTORY

2495: d_progress := 10;
2496:
2497: -- CLM Apprvl
2498: IF p_draft_id IS NOT NULL AND p_draft_id <> -1 THEN
2499: UPDATE PO_ACTION_HISTORY
2500: SET action_code = p_action
2501: , action_date = SYSDATE
2502: , note = p_note
2503: , last_updated_by = p_user_id

Line 2511: UPDATE PO_ACTION_HISTORY

2507: WHERE object_id = p_draft_id
2508: AND object_type_code = p_document_type
2509: AND action_code IS NULL;
2510: ELSE
2511: UPDATE PO_ACTION_HISTORY
2512: SET action_code = p_action
2513: , action_date = SYSDATE
2514: , note = p_note
2515: , last_updated_by = p_user_id