APPS.PON_FBO_PKG dependencies on PON_FORMS_INSTANCES

Line 76: || 'pon_forms_instances and pon_form_field_values tables');

72: p_request_id,
73: 'PON');
74: INSERT_DOC_UPLOAD_RECORD(p_document_id,l_form_id,NULL,NULL,NULL);
75: LOG_MESSAGE(l_module,'Document Upload record inserted into '
76: || 'pon_forms_instances and pon_form_field_values tables');
77: END;
78:
79: EXCEPTION
80: WHEN OTHERS THEN

Line 160: UPDATE pon_forms_instances

156:
157: IF p_product_code = 'PON' THEN
158: IF Nvl(p_form_id,0) <> 0 THEN
159:
160: UPDATE pon_forms_instances
161: SET status = Decode(p_status,'SUCCESS','FBO_INPROCESS','ERROR','FBO_ERROR')
162: WHERE entity_pk1 = p_document_Id
163: AND form_id = p_form_id;
164: ELSIF p_form_code = 'FED_DOC_UPLOAD' THEN

Line 170: UPDATE pon_forms_instances

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')
172: WHERE entity_pk1 = p_document_Id
173: AND form_id = l_form_id;
174:

Line 1180: UPDATE pon_forms_instances

1176: WHERE document_id = p_document_id
1177: AND form_id = p_form_Id
1178: AND fbo_post_status IS NULL;
1179:
1180: UPDATE pon_forms_instances
1181: SET status = Decode(p_status,'SUCCESS','POSTED','FAILED_POSTED'),
1182: fbo_date_sent = SYSDATE
1183: WHERE entity_pk1 = p_document_Id
1184: AND form_id = p_form_id;

Line 1258: UPDATE pon_forms_instances

1254: fbo_post_date = SYSDATE
1255: WHERE document_id = To_Number(l_document_id)
1256: AND cp_request_id = To_Number(l_request_id);
1257:
1258: UPDATE pon_forms_instances
1259: SET status = Decode(l_result,'true','POSTED','FAILED_POSTED'),
1260: fbo_date_sent = SYSDATE
1261: WHERE entity_pk1 = To_Number(l_document_Id)
1262: AND form_id = To_Number(l_form_id);

Line 1307: l_date_sent pon_forms_instances.fbo_date_sent%TYPE;

1303: PROCEDURE NOTIFY_REQUESTORS(p_auction_header_id IN NUMBER,
1304: p_form_id IN NUMBER )
1305: AS
1306: l_sol_number pon_auctioN_headers_all.document_Number%TYPE;
1307: l_date_sent pon_forms_instances.fbo_date_sent%TYPE;
1308: l_username wf_users.name%type;
1309: l_user_display_name wf_users.display_name%TYPE;
1310: l_itemtype VARCHAR2(10) := 'PONFEDPS';
1311: l_itemkey VARCHAR2(300);

Line 1320: FROM pon_forms_instances

1316: FROM pon_auctioN_Headers_all
1317: WHERE auctioN_header_id = p_auction_header_id;
1318:
1319: SELECT fbo_date_sent INTO l_date_sent
1320: FROM pon_forms_instances
1321: WHERE entity_pk1 = To_Number(p_auction_header_id)
1322: AND form_id = To_Number(p_form_id);
1323:
1324: l_itemkey := 'PRESOL' || l_sol_number;

Line 1414: INSERT INTO pon_forms_instances(ENTITY_CODE,

1410: AS
1411:
1412: BEGIN
1413:
1414: INSERT INTO pon_forms_instances(ENTITY_CODE,
1415: ENTITY_PK1,
1416: FORM_ID,
1417: STATUS,
1418: CREATION_DATE,