394: 'N',
395: 'PERIOD',
396: NVL(get_value(respids(i), 'PN_MULT_TNC_FOR_SAME_LEASE'),'N'),
397: 'Y',
398: NVL(fnd_global.user_id, -1),
399: NVL(fnd_global.user_id, -1),
400: NVL(fnd_global.user_id, -1),
401: SYSDATE,
402: SYSDATE);
395: 'PERIOD',
396: NVL(get_value(respids(i), 'PN_MULT_TNC_FOR_SAME_LEASE'),'N'),
397: 'Y',
398: NVL(fnd_global.user_id, -1),
399: NVL(fnd_global.user_id, -1),
400: NVL(fnd_global.user_id, -1),
401: SYSDATE,
402: SYSDATE);
403:
396: NVL(get_value(respids(i), 'PN_MULT_TNC_FOR_SAME_LEASE'),'N'),
397: 'Y',
398: NVL(fnd_global.user_id, -1),
399: NVL(fnd_global.user_id, -1),
400: NVL(fnd_global.user_id, -1),
401: SYSDATE,
402: SYSDATE);
403:
404: END IF;
585: FORALL i IN 1..orgids.COUNT
586: UPDATE PN_SYSTEM_SETUP_OPTIONS
587: SET gl_transfer_mode = get_value(respids(i),'PN_GL_TRANSFER_MODE'),
588: submit_journal_import_flag = get_value(respids(i),'PN_SUBMIT_JOURNAL_IMPORT'),
589: last_update_login = NVL(fnd_global.user_id, -1),
590: last_updated_by = NVL(fnd_global.user_id, -1),
591: last_update_date = SYSDATE
592: WHERE org_id = orgids(i);
593: EXIT WHEN active_pn_resp_cur%NOTFOUND;
586: UPDATE PN_SYSTEM_SETUP_OPTIONS
587: SET gl_transfer_mode = get_value(respids(i),'PN_GL_TRANSFER_MODE'),
588: submit_journal_import_flag = get_value(respids(i),'PN_SUBMIT_JOURNAL_IMPORT'),
589: last_update_login = NVL(fnd_global.user_id, -1),
590: last_updated_by = NVL(fnd_global.user_id, -1),
591: last_update_date = SYSDATE
592: WHERE org_id = orgids(i);
593: EXIT WHEN active_pn_resp_cur%NOTFOUND;
594: