eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AWARD_APPROVAL_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 116: FROM pon_auction_headers_all

112: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'marking award ' || p_auction_header_id || ' as OAM transaction ' || p_transaction_id);
113:
114: SELECT award_approval_status
115: INTO l_award_approval_status
116: FROM pon_auction_headers_all
117: WHERE auction_header_id = p_auction_header_id;
118:
119: -- check if a transaction already exists and has been submitted for approval
120: IF l_award_approval_status = 'INPROCESS' THEN

Line 127: -- update pon_auction_headers_all

123: END IF;
124:
125: l_last_update_date := SYSDATE;
126:
127: -- update pon_auction_headers_all
128: -- award_appr_ame_trans_id column with transaction id
129: -- award_appr_ame_txn_date column with SYSDATE
130: UPDATE pon_auction_headers_all
131: SET

Line 130: UPDATE pon_auction_headers_all

126:
127: -- update pon_auction_headers_all
128: -- award_appr_ame_trans_id column with transaction id
129: -- award_appr_ame_txn_date column with SYSDATE
130: UPDATE pon_auction_headers_all
131: SET
132: award_appr_ame_trans_id = p_transaction_id,
133: award_appr_ame_txn_date = l_last_update_date,
134: last_updated_by = p_user_id,

Line 163: -- update pon_auction_headers_all

159: PROCEDURE clear_oam_transaction(p_auction_header_id IN NUMBER,
160: p_user_id IN NUMBER) IS
161: BEGIN
162:
163: -- update pon_auction_headers_all
164: -- award_approval_status with 'REQUIRED',
165: -- award_appr_ame_trans_id column with NULL
166: -- award_appr_ame_trans_prev_id with NULL
167: -- award_appr_ame_txn_date column with NULL

Line 169: UPDATE pon_auction_headers_all

165: -- award_appr_ame_trans_id column with NULL
166: -- award_appr_ame_trans_prev_id with NULL
167: -- award_appr_ame_txn_date column with NULL
168: -- wf_award_approval_item_key column with NULL
169: UPDATE pon_auction_headers_all
170: SET
171: award_approval_status = 'REQUIRED',
172: award_appr_ame_trans_id = NULL,
173: award_appr_ame_trans_prev_id = NULL,

Line 210: FROM pon_auction_headers_all

206: -- lock the transaction based on the p_lock_transaction parameter
207: IF p_lock_transaction THEN
208: SELECT last_update_date, award_approval_status
209: INTO l_last_update_date, l_award_approval_status
210: FROM pon_auction_headers_all
211: WHERE auction_header_id = p_auction_header_id
212: FOR UPDATE NOWAIT;
213: ELSE
214: SELECT last_update_date, award_approval_status

Line 216: FROM pon_auction_headers_all

212: FOR UPDATE NOWAIT;
213: ELSE
214: SELECT last_update_date, award_approval_status
215: INTO l_last_update_date, l_award_approval_status
216: FROM pon_auction_headers_all
217: WHERE auction_header_id = p_auction_header_id;
218: END IF;
219:
220: -- check if the transaction has already been modified

Line 371: pon_auction_headers_all auc,

367: l_award_by_date,
368: l_doctype_group_name,
369: l_preview_date
370: FROM
371: pon_auction_headers_all auc,
372: pon_auc_doctypes dt
373: WHERE
374: dt.doctype_id= auc.doctype_id
375: AND auc.auction_header_id = p_auction_header_id;

Line 855: UPDATE pon_auction_headers_all

851: FROM fnd_user
852: WHERE user_name = l_tp_contact_user_name;
853:
854: -- update previous transaction id column with current transaction id
855: UPDATE pon_auction_headers_all
856: SET
857: award_appr_ame_trans_prev_id = l_transaction_id,
858: last_updated_by = l_tp_contact_user_id,
859: last_update_date = SYSDATE

Line 1167: UPDATE pon_auction_headers_all

1163: 0,
1164: NULL);
1165:
1166: -- change the approval status of the transaction to REJECTED
1167: UPDATE pon_auction_headers_all
1168: SET
1169: award_approval_status = 'REJECTED',
1170: last_updated_by = 0,
1171: last_update_date = SYSDATE

Line 1301: UPDATE pon_auction_headers_all

1297: itemkey => itemkey,
1298: aname => 'AME_TRANSACTION_ID');
1299:
1300: -- change the approval status of the transaction to REJECTED
1301: UPDATE pon_auction_headers_all
1302: SET
1303: award_approval_status = 'REJECTED',
1304: last_updated_by = 0,
1305: last_update_date = SYSDATE

Line 1358: UPDATE pon_auction_headers_all

1354: 0,
1355: NULL);
1356:
1357: -- change the approval status of the transaction to APPROVED
1358: UPDATE pon_auction_headers_all
1359: SET
1360: award_approval_status = 'APPROVED',
1361: last_updated_by = 0,
1362: last_update_date = SYSDATE

Line 2325: UPDATE pon_auction_headers_all

2321: -- make the workflow item key of the format '-
2322: l_item_key := TO_CHAR(p_auction_header_id) || '-' || p_transaction_id;
2323:
2324: -- change the award approval status to INPROCESS
2325: UPDATE pon_auction_headers_all
2326: SET
2327: award_approval_status = 'INPROCESS',
2328: wf_award_approval_item_key = l_item_key,
2329: last_updated_by = p_user_id,

Line 2406: FROM pon_auction_headers_all

2402: BEGIN
2403:
2404: SELECT wf_award_approval_item_key
2405: INTO l_item_key
2406: FROM pon_auction_headers_all
2407: WHERE auction_header_id = p_auction_header_id;
2408:
2409: -- try to obtain the id of the notification to which the user is responding to
2410: BEGIN