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_FBO_PKG dependencies on PON_FBO_POSTS

Line 61: record would have already been inserted into pon_fbo_posts.

57: END IF;
58:
59: BEGIN
60: /*If user is posting document upload manually then
61: record would have already been inserted into pon_fbo_posts.
62: For automatic posting during soliciation publishing,
63: we have to insert it now */
64: SELECT 'Y' INTO is_docupload_inserted
65: FROM pon_fbo_posts

Line 65: FROM pon_fbo_posts

61: record would have already been inserted into pon_fbo_posts.
62: For automatic posting during soliciation publishing,
63: we have to insert it now */
64: SELECT 'Y' INTO is_docupload_inserted
65: FROM pon_fbo_posts
66: WHERE cp_request_id = p_request_id;
67: EXCEPTION
68: WHEN No_Data_Found THEN
69: insert_record(p_document_id,

Line 112: SELECT 'Y' INTO is_post_pending FROM pon_fbo_posts

108: * In both cases we have to ensure that user notice is not posted multiple
109: * times before response is received or it errors out.
110: */
111: BEGIN
112: SELECT 'Y' INTO is_post_pending FROM pon_fbo_posts
113: WHERE document_id = p_document_id
114: AND form_id = l_form_id
115: AND Nvl(fbo_post_status,'INPROGRESS') NOT IN ('SUCCESS','FAILED')
116: AND pon_fbo_pkg.get_request_internal_status(cp_request_id) <> 'ERROR'

Line 152: UPDATE pon_fbo_posts

148:
149: BEGIN
150:
151: IF p_status = 'SUCCESS' THEN
152: UPDATE pon_fbo_posts
153: SET FBO_POST_STATUS = 'INPROGRESS'
154: WHERE cp_request_id = p_request_id;
155: END IF;
156:

Line 167: FROM pon_fbo_posts

163: AND form_id = p_form_id;
164: ELSIF p_form_code = 'FED_DOC_UPLOAD' THEN
165:
166: SELECT form_id INTO l_form_id
167: FROM pon_fbo_posts
168: WHERE cp_request_id = p_request_id;
169:
170: UPDATE pon_forms_instances
171: SET status = Decode(p_status,'SUCCESS','FBO_INPROCESS','ERROR','FBO_ERROR')

Line 209: FROM pon_fbo_posts

205:
206: BEGIN
207:
208: SELECT 'S' INTO x_result
209: FROM pon_fbo_posts
210: WHERE document_id = p_auction_header_id
211: AND form_code = 'FED_PRESOL'
212: AND FBO_POST_STATUS = 'SUCCESS'
213: AND ROWNUM < 2;

Line 258: FROM pon_fbo_posts

254: FROM pon_bid_headers
255: WHERE po_header_id = p_po_header_id;
256:
257: SELECT 'S' INTO x_result
258: FROM pon_fbo_posts
259: WHERE document_id = L_auction_header_id
260: AND form_code = 'FED_DOC_UPLOAD'
261: AND FBO_POST_STATUS = 'SUCCESS'
262: AND ROWNUM < 2;

Line 1064: UPDATE pon_fbo_posts

1060: l_auth_data VARCHAR2(1000);
1061:
1062: BEGIN
1063:
1064: UPDATE pon_fbo_posts
1065: SET xml_data = p_xml
1066: WHERE document_id = p_document_id
1067: AND cp_request_id = p_request_id;
1068:

Line 1174: UPDATE pon_fbo_posts

1170: x_result := 'E';
1171: RETURN;
1172: END IF;
1173:
1174: UPDATE pon_fbo_posts
1175: SET fbo_post_status = p_status
1176: WHERE document_id = p_document_id
1177: AND form_id = p_form_Id
1178: AND fbo_post_status IS NULL;

Line 1189: FROM pon_fbo_posts

1185:
1186: IF p_status = 'ERROR' THEN
1187:
1188: SELECT transaction_id INTO l_txn_id
1189: FROM pon_fbo_posts
1190: WHERE document_id = p_document_id
1191: AND form_id = p_form_Id
1192: AND fbo_post_status IS NULL;
1193:

Line 1207: 'PON_FBO_POSTS',

1203: last_update_date,
1204: last_updated_by,
1205: last_update_login)
1206: VALUES('FedBizOpps',
1207: 'PON_FBO_POSTS',
1208: l_txn_id,
1209: p_message,
1210: p_document_id,
1211: 'FORM_ID',

Line 1252: UPDATE pon_fbo_posts

1248: l_form_id := p_event.getValueForParameter('FORM_ID');
1249: l_form_code := p_event.getValueForParameter('FORM_CODE');
1250: l_request_id := p_event.getValueForParameter('REQUEST_ID');
1251:
1252: UPDATE pon_fbo_posts
1253: SET fbo_post_status = Decode(l_result,'true','SUCCESS','FAILED'),
1254: fbo_post_date = SYSDATE
1255: WHERE document_id = To_Number(l_document_id)
1256: AND cp_request_id = To_Number(l_request_id);

Line 1283: 'PON_FBO_POSTS',

1279: LAST_UPDATED_BY,
1280: LAST_UPDATE_DATE,
1281: LAST_UPDATE_LOGIN)
1282: VALUES('FBOUPLOAD',
1283: 'PON_FBO_POSTS',
1284: (select transaction_id from pon_fbo_posts where cp_request_id = To_Number(l_request_id)
1285: AND ROWNUM < 2),
1286: To_Number(l_request_id),
1287: l_res_message,

Line 1284: (select transaction_id from pon_fbo_posts where cp_request_id = To_Number(l_request_id)

1280: LAST_UPDATE_DATE,
1281: LAST_UPDATE_LOGIN)
1282: VALUES('FBOUPLOAD',
1283: 'PON_FBO_POSTS',
1284: (select transaction_id from pon_fbo_posts where cp_request_id = To_Number(l_request_id)
1285: AND ROWNUM < 2),
1286: To_Number(l_request_id),
1287: l_res_message,
1288: 'FORM_ID',

Line 1373: INSERT INTO pon_fbo_posts

1369:
1370: pragma AUTONOMOUS_TRANSACTION;
1371:
1372: BEGIN
1373: INSERT INTO pon_fbo_posts
1374: (transaction_id,
1375: document_id,
1376: form_id,
1377: form_code,

Line 1385: VALUES(PON_FBO_POSTS_S.NEXTVAL,

1381: creation_date,
1382: created_by,
1383: last_update_date,
1384: last_updated_by)
1385: VALUES(PON_FBO_POSTS_S.NEXTVAL,
1386: p_document_id,
1387: p_form_id,
1388: p_form_code,
1389: p_product_code,