APPS.PON_FORMS_UTIL_PVT dependencies on PON_FORMS_INSTANCES

Line 3307: -- pon_forms_instances.status

3303:
3304: -- if the user hasn't pressed the publish abstract button
3305: -- we dont need to update the status in either
3306: -- pon_auction_headers_all.abstract_status OR
3307: -- pon_forms_instances.status
3308:
3309: -- as we do invoke this method when the user presses the apply button as well
3310:
3311: update pon_auction_headers_all

Line 3322: update pon_forms_instances

3318: from pon_forms_sections
3319: where form_code = 'ABSTRACT'
3320: and type = 'ABSTRACT';
3321:
3322: update pon_forms_instances
3323: set status = decode(nvl(p_publish_action, 'X'), 'Y', 'PUBLISHED', 'NOT_PUBLISHED'),
3324: last_update_date = sysdate
3325: where entity_code = 'PON_AUCTION_HEADERS_ALL'
3326: and entity_pk1 = to_char(p_auction_header_id)

Line 3363: l_old_status PON_FORMS_INSTANCES.STATUS%TYPE;

3359: x_error_message OUT NOCOPY VARCHAR2) IS
3360:
3361: l_api_name CONSTANT VARCHAR2(30) := 'PERFORMPOSTSAVECHANGES';
3362: l_form_type PON_FORMS_SECTIONS.FORM_CODE%TYPE;
3363: l_old_status PON_FORMS_INSTANCES.STATUS%TYPE;
3364:
3365: BEGIN
3366:
3367: print_debug_log(l_api_name, 'BEGIN- p_form_id = '||p_form_id||'

Line 3378: update pon_forms_instances

3374: where form_id = p_form_id;
3375:
3376: if(l_form_type = 'FORM') then
3377:
3378: update pon_forms_instances
3379: set status = 'DATA_ENTERED',
3380: last_update_date = sysdate
3381: where entity_code = p_entity_code
3382: and entity_pk1 = p_entity_pk1

Line 3389: from pon_forms_instances

3385: elsif(l_form_type = 'ABSTRACT') then
3386:
3387: select status
3388: into l_old_status
3389: from pon_forms_instances
3390: where entity_code = p_entity_code
3391: and entity_pk1 = p_entity_pk1
3392: and form_id = p_form_id;
3393:

Line 3400: update pon_forms_instances

3396: -- status hasnt been set
3397:
3398: if(NVL(l_old_status , 'x@Y#z') = 'x@Y#z') then
3399:
3400: update pon_forms_instances
3401: set status = 'NOT_PUBLISHED',
3402: last_update_date = sysdate
3403: where entity_code = p_entity_code
3404: and entity_pk1 = p_entity_pk1