APPS.PON_AWARD_APPROVAL_PKG dependencies on PON_ACTION_HISTORY

Line 262: FROM pon_action_history

258: -- determine the current action sequence number for the award
259: BEGIN
260: SELECT MAX(sequence_num)
261: INTO l_action_sequence_number
262: FROM pon_action_history
263: WHERE
264: object_id = p_auction_header_id
265: AND object_type_code = AWARD_OBJECT_TYPE;
266: EXCEPTION

Line 278: INSERT INTO pon_action_history(

274: l_action_sequence_number := 0;
275: END IF;
276:
277: -- create the action entry, incrementing the sequence number
278: INSERT INTO pon_action_history(
279: object_id,
280: object_id2,
281: object_type_code,
282: sequence_num,

Line 312: UPDATE pon_action_history

308: p_action_date IN DATE,
309: p_user_id IN NUMBER) IS
310: BEGIN
311:
312: UPDATE pon_action_history
313: SET
314: action_type = p_action_type,
315: action_date = p_action_date,
316: action_note = p_notes

Line 1454: -- record approver response in PON_ACTION_HISTORY table

1450: l_current_log_level,
1451: l_module_name,
1452: 'Done with Parsing the approver string. Successfully framed the approver record.');
1453:
1454: -- record approver response in PON_ACTION_HISTORY table
1455: IF l_approver.orig_system = 'POS' THEN -- Position Hierarchy setup in AME.
1456:
1457: BEGIN
1458: l_person_id := NULL;

Line 2253: -- record submit action in PON_ACTION_HISTORY table

2249: END IF;
2250: END IF;
2251: END IF;
2252:
2253: -- record submit action in PON_ACTION_HISTORY table
2254: add_action_history(p_auction_header_id,
2255: p_transaction_id,
2256: 'AWARD_APPROVAL_SUBMIT',
2257: p_note_to_approvers,