1268:
1269: UPDATE igc_cc_headers
1270: SET cc_apprvl_status = 'IP',
1271: last_update_date = sysdate,
1272: last_updated_by = fnd_global.user_id,
1273: last_update_login = fnd_global.login_id
1274: WHERE CURRENT OF c_update_cc;
1275:
1276: CLOSE c_update_cc;
1269: UPDATE igc_cc_headers
1270: SET cc_apprvl_status = 'IP',
1271: last_update_date = sysdate,
1272: last_updated_by = fnd_global.user_id,
1273: last_update_login = fnd_global.login_id
1274: WHERE CURRENT OF c_update_cc;
1275:
1276: CLOSE c_update_cc;
1277:
2512: p_cc_action_ctrl_status => g_cc_ctrl_status,
2513: p_cc_action_apprvl_status => g_cc_new_appr_status,
2514: p_cc_action_notes => g_action_notes,
2515: p_last_update_date => sysdate,
2516: p_last_updated_by => fnd_global.user_id,
2517: p_last_update_login => fnd_global.login_id,
2518: p_creation_date => sysdate,
2519: p_created_by => fnd_global.user_id
2520: );
2513: p_cc_action_apprvl_status => g_cc_new_appr_status,
2514: p_cc_action_notes => g_action_notes,
2515: p_last_update_date => sysdate,
2516: p_last_updated_by => fnd_global.user_id,
2517: p_last_update_login => fnd_global.login_id,
2518: p_creation_date => sysdate,
2519: p_created_by => fnd_global.user_id
2520: );
2521:
2515: p_last_update_date => sysdate,
2516: p_last_updated_by => fnd_global.user_id,
2517: p_last_update_login => fnd_global.login_id,
2518: p_creation_date => sysdate,
2519: p_created_by => fnd_global.user_id
2520: );
2521:
2522: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2523: IF g_debug_mode = 'Y'
2603: SET cc_state = g_cc_new_state,
2604: cc_encmbrnc_status = g_cc_new_enc_status,
2605: cc_apprvl_status = g_cc_new_appr_status,
2606: last_update_date = sysdate,
2607: last_updated_by = fnd_global.user_id,
2608: last_update_login = fnd_global.login_id
2609: WHERE CURRENT OF c_update_cc;
2610: IF SQL%ROWCOUNT <>1 THEN
2611: message_token ('CC_HEADER_ID', g_cc_header_id);
2604: cc_encmbrnc_status = g_cc_new_enc_status,
2605: cc_apprvl_status = g_cc_new_appr_status,
2606: last_update_date = sysdate,
2607: last_updated_by = fnd_global.user_id,
2608: last_update_login = fnd_global.login_id
2609: WHERE CURRENT OF c_update_cc;
2610: IF SQL%ROWCOUNT <>1 THEN
2611: message_token ('CC_HEADER_ID', g_cc_header_id);
2612: add_message ('IGC', 'IGC_CC_NOT_FOUND');