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 1489: -- record approver response in PON_ACTION_HISTORY table

1485: l_current_log_level,
1486: l_module_name,
1487: 'Done with Parsing the approver string. Successfully framed the approver record.');
1488:
1489: -- record approver response in PON_ACTION_HISTORY table
1490: IF l_approver.orig_system = 'POS' THEN -- Position Hierarchy setup in AME.
1491:
1492: BEGIN
1493: l_person_id := NULL;

Line 2311: -- record submit action in PON_ACTION_HISTORY table

2307: END IF;
2308: END IF;
2309: END IF;
2310:
2311: -- record submit action in PON_ACTION_HISTORY table
2312: add_action_history(p_auction_header_id,
2313: p_transaction_id,
2314: 'AWARD_APPROVAL_SUBMIT',
2315: p_note_to_approvers,