4144: l_tapv_rec.object_version_number := 1;
4145: --20-NOV-2006 ANSETHUR R12B - LEGAL ENTITY UPTAKE PROJECT
4146: l_tapv_rec.legal_entity_id :=OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_term_rec.p_contract_id);
4147:
4148: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4149: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4150: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4151: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4152: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4145: --20-NOV-2006 ANSETHUR R12B - LEGAL ENTITY UPTAKE PROJECT
4146: l_tapv_rec.legal_entity_id :=OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_term_rec.p_contract_id);
4147:
4148: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4149: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4150: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4151: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4152: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4153: l_tapv_rec.PROGRAM_APPLICATION_ID,
4146: l_tapv_rec.legal_entity_id :=OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_term_rec.p_contract_id);
4147:
4148: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4149: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4150: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4151: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4152: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4153: l_tapv_rec.PROGRAM_APPLICATION_ID,
4154: l_tapv_rec.PROGRAM_ID,
4147:
4148: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4149: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4150: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4151: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4152: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4153: l_tapv_rec.PROGRAM_APPLICATION_ID,
4154: l_tapv_rec.PROGRAM_ID,
4155: l_tapv_rec.PROGRAM_UPDATE_DATE,
4661: -- END SMODUGA
4662:
4663: l_tapv_rec.object_version_number := 1;
4664:
4665: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4666: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4667: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4668: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4669: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4662:
4663: l_tapv_rec.object_version_number := 1;
4664:
4665: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4666: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4667: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4668: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4669: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4670: l_tapv_rec.PROGRAM_APPLICATION_ID,
4663: l_tapv_rec.object_version_number := 1;
4664:
4665: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4666: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4667: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4668: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4669: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4670: l_tapv_rec.PROGRAM_APPLICATION_ID,
4671: l_tapv_rec.PROGRAM_ID,
4664:
4665: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4666: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4667: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4668: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4669: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4670: l_tapv_rec.PROGRAM_APPLICATION_ID,
4671: l_tapv_rec.PROGRAM_ID,
4672: l_tapv_rec.PROGRAM_UPDATE_DATE,