APPS.PON_AUCTION_APPROVAL_PKG dependencies on PON_ACTION_HISTORY

Line 1203: l_approve_date PON_ACTION_HISTORY.ACTION_DATE%TYPE;

1199:
1200: l_auction_header_id Number;
1201: l_status Varchar2(30) := 'APPROVED';
1202: l_user_id Number;
1203: l_approve_date PON_ACTION_HISTORY.ACTION_DATE%TYPE;
1204: l_approve_date_in_tz DATE;
1205: l_language_code varchar2(100);
1206: l_timezone varchar2(100);
1207: l_timezone_disp varchar2(100);

Line 1240: FROM pon_action_history

1236: itemkey => itemKey,
1237: aname => 'PREVIEW_DATE_NOTSPECIFIED');
1238: SELECT max(action_date)
1239: INTO l_approve_date
1240: FROM pon_action_history
1241: WHERE object_id = l_auction_header_id
1242: and object_type_code = 'NEGOTIATION'
1243: and action_type = 'APPROVE';
1244:

Line 1295: l_reject_date PON_ACTION_HISTORY.ACTION_DATE%TYPE;

1291: l_auction_header_id Number;
1292: l_status Varchar2(30) := 'REJECTED';
1293: l_user_id Number;
1294: l_rejection_note Varchar2(2000);
1295: l_reject_date PON_ACTION_HISTORY.ACTION_DATE%TYPE;
1296: l_reject_date_in_tz DATE;
1297: l_language_code varchar2(100);
1298: l_timezone varchar2(100);
1299: l_timezone_disp varchar2(100);

Line 1339: FROM pon_action_history

1335: aname => 'PREVIEW_DATE_NOTSPECIFIED');
1336:
1337: SELECT max(action_date)
1338: INTO l_reject_date
1339: FROM pon_action_history
1340: WHERE object_id = l_auction_header_id
1341: and object_type_code = 'NEGOTIATION'
1342: and action_type = 'REJECT';
1343:

Line 1432: insert into pon_action_history

1428: set approval_status = decode(p_status,'APPROVE','APPROVED','REJECT','REJECTED',p_status)
1429: where auction_header_id = p_auction_header_id
1430: and user_id = p_user_id;
1431: end if;
1432: insert into pon_action_history
1433: (object_id,
1434: object_id2,
1435: object_type_code,
1436: sequence_num,