592: p_token2 => 'TIME',
593: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
594:
595: pv_dim_rule_obj_def_id := p_dim_rule_obj_def_id;
596: pv_user_id := NVL(FND_GLOBAL.USER_ID,'-1');
597: pv_login_id := NVL(FND_GLOBAL.CONC_LOGIN_ID,
598: FND_GLOBAL.LOGIN_ID);
599: pv_req_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,1);
600: pv_pgm_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,1);
593: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
594:
595: pv_dim_rule_obj_def_id := p_dim_rule_obj_def_id;
596: pv_user_id := NVL(FND_GLOBAL.USER_ID,'-1');
597: pv_login_id := NVL(FND_GLOBAL.CONC_LOGIN_ID,
598: FND_GLOBAL.LOGIN_ID);
599: pv_req_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,1);
600: pv_pgm_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,1);
601: pv_pgm_app_id := NVL(FND_GLOBAL.PROG_APPL_ID,274);
594:
595: pv_dim_rule_obj_def_id := p_dim_rule_obj_def_id;
596: pv_user_id := NVL(FND_GLOBAL.USER_ID,'-1');
597: pv_login_id := NVL(FND_GLOBAL.CONC_LOGIN_ID,
598: FND_GLOBAL.LOGIN_ID);
599: pv_req_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,1);
600: pv_pgm_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,1);
601: pv_pgm_app_id := NVL(FND_GLOBAL.PROG_APPL_ID,274);
602:
595: pv_dim_rule_obj_def_id := p_dim_rule_obj_def_id;
596: pv_user_id := NVL(FND_GLOBAL.USER_ID,'-1');
597: pv_login_id := NVL(FND_GLOBAL.CONC_LOGIN_ID,
598: FND_GLOBAL.LOGIN_ID);
599: pv_req_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,1);
600: pv_pgm_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,1);
601: pv_pgm_app_id := NVL(FND_GLOBAL.PROG_APPL_ID,274);
602:
603: pv_progress := 'Before select of object id and folder id';
596: pv_user_id := NVL(FND_GLOBAL.USER_ID,'-1');
597: pv_login_id := NVL(FND_GLOBAL.CONC_LOGIN_ID,
598: FND_GLOBAL.LOGIN_ID);
599: pv_req_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,1);
600: pv_pgm_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,1);
601: pv_pgm_app_id := NVL(FND_GLOBAL.PROG_APPL_ID,274);
602:
603: pv_progress := 'Before select of object id and folder id';
604:
597: pv_login_id := NVL(FND_GLOBAL.CONC_LOGIN_ID,
598: FND_GLOBAL.LOGIN_ID);
599: pv_req_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,1);
600: pv_pgm_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,1);
601: pv_pgm_app_id := NVL(FND_GLOBAL.PROG_APPL_ID,274);
602:
603: pv_progress := 'Before select of object id and folder id';
604:
605: SELECT O.OBJECT_ID, O.FOLDER_ID