APPS.PON_FORMS_UTIL_PVT dependencies on PON_FORMS_INSTANCES

Line 3383: -- pon_forms_instances.status

3379:
3380: -- if the user hasn't pressed the publish abstract button
3381: -- we dont need to update the status in either
3382: -- pon_auction_headers_all.abstract_status OR
3383: -- pon_forms_instances.status
3384:
3385: -- as we do invoke this method when the user presses the apply button as well
3386:
3387: update pon_auction_headers_all

Line 3398: update pon_forms_instances

3394: from pon_forms_sections
3395: where form_code = 'ABSTRACT'
3396: and type = 'ABSTRACT';
3397:
3398: update pon_forms_instances
3399: set status = decode(nvl(p_publish_action, 'X'), 'Y', 'PUBLISHED', 'NOT_PUBLISHED'),
3400: last_update_date = sysdate
3401: where entity_code = 'PON_AUCTION_HEADERS_ALL'
3402: and entity_pk1 = to_char(p_auction_header_id)

Line 3439: l_old_status PON_FORMS_INSTANCES.STATUS%TYPE;

3435: x_error_message OUT NOCOPY VARCHAR2) IS
3436:
3437: l_api_name CONSTANT VARCHAR2(30) := 'PERFORMPOSTSAVECHANGES';
3438: l_form_type PON_FORMS_SECTIONS.FORM_CODE%TYPE;
3439: l_old_status PON_FORMS_INSTANCES.STATUS%TYPE;
3440:
3441: BEGIN
3442:
3443: print_debug_log(l_api_name, 'BEGIN- p_form_id = '||p_form_id||'

Line 3459: from pon_forms_instances

3455: and press apply button, status should remain "POSTED"
3456: */
3457: select status
3458: into l_old_status
3459: from pon_forms_instances
3460: where entity_code = p_entity_code
3461: and entity_pk1 = p_entity_pk1
3462: and form_id = p_form_id;
3463:

Line 3465: update pon_forms_instances

3461: and entity_pk1 = p_entity_pk1
3462: and form_id = p_form_id;
3463:
3464: if(NVL(l_old_status , 'x@Y#z') <> 'POSTED') then
3465: update pon_forms_instances
3466: set status = 'DATA_ENTERED',
3467: last_update_date = sysdate
3468: where entity_code = p_entity_code
3469: and entity_pk1 = p_entity_pk1

Line 3477: from pon_forms_instances

3473: elsif(l_form_type = 'ABSTRACT') then
3474:
3475: select status
3476: into l_old_status
3477: from pon_forms_instances
3478: where entity_code = p_entity_code
3479: and entity_pk1 = p_entity_pk1
3480: and form_id = p_form_id;
3481:

Line 3488: update pon_forms_instances

3484: -- status hasnt been set
3485:
3486: if(NVL(l_old_status , 'x@Y#z') = 'x@Y#z') then
3487:
3488: update pon_forms_instances
3489: set status = 'NOT_PUBLISHED',
3490: last_update_date = sysdate
3491: where entity_code = p_entity_code
3492: and entity_pk1 = p_entity_pk1