DBA Data[Home] [Help]

APPS.OKS_PM_PROGRAMS_PVT dependencies on OKC_P_UTIL

Line 544: l_pmschvtbl_In(j).id := okc_p_util.raw_to_number(sys_guid()) ;

540: l_pmschvtbl_In.delete;
541: l_pmschvtbl_Out.delete; --CK 09/02
542: --Populate program schedules table of record
543: FOR j in x_pms_tbl.FIRST..x_pms_tbl.LAST LOOP
544: l_pmschvtbl_In(j).id := okc_p_util.raw_to_number(sys_guid()) ;
545: --02/13 l_pmschvtbl_In(j).program_id := l_pmlrulvrec_Out.program_id;
546: l_pmschvtbl_In(j).object_version_number := l_pmlrulvrec_out.object_version_number;
547: l_pmschvtbl_In(j).dnz_chr_id := l_pmlrulvrec_out.dnz_chr_id;
548: l_pmschvtbl_In(j).cle_id := p_cle_id;

Line 854: l_pmschvtbl_In(j).id := okc_p_util.raw_to_number(sys_guid()) ;

850: l_pmschvtbl_In.delete;
851: l_pmschvtbl_Out.delete; --
852:
853: FOR j in x_pms_tbl.FIRST..x_pms_tbl.LAST LOOP
854: l_pmschvtbl_In(j).id := okc_p_util.raw_to_number(sys_guid()) ;
855: --02/12 l_pmschvtbl_In(j).program_id := l_pmlrulvrec_Out.program_id;
856: l_pmschvtbl_In(j).object_version_number := l_pmlrulvrec_out.object_version_number;
857: l_pmschvtbl_In(j).dnz_chr_id := l_pmlrulvrec_out.dnz_chr_id;
858: l_pmschvtbl_In(j).cle_id := p_cle_id;

Line 5437: okc_p_util.raw_to_number(sys_guid()),

5433: ORIG_SYSTEM_ID1,
5434: ORIG_SYSTEM_SOURCE_CODE,
5435: ORIG_SYSTEM_REFERENCE1 )
5436: SELECT
5437: okc_p_util.raw_to_number(sys_guid()),
5438: p_new_cle_id CLE_ID,
5439: DNZ_CHR_ID,
5440: ACTIVITY_ID,
5441: SELECT_YN,

Line 5517: okc_p_util.raw_to_number(sys_guid()),

5513: ORIG_SYSTEM_ID1,
5514: ORIG_SYSTEM_SOURCE_CODE,
5515: ORIG_SYSTEM_REFERENCE1 )
5516: SELECT
5517: okc_p_util.raw_to_number(sys_guid()),
5518: p_new_cle_id CLE_ID,
5519: DNZ_CHR_ID,
5520: DECODE(ACTIVITY_LINE_ID,NULL,NULL,(SELECT id from oks_pm_activities where ORIG_SYSTEM_ID1 =ACTIVITY_LINE_ID and cle_id =p_new_cle_id)),
5521: SEQUENCE_NUMBER,