APPS.OKS_COVERAGES_PVT dependencies on OKC_P_UTIL

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

11006: SALES_GROUP_ID,
11007: DNZ_STE_CODE)
11008: --ORIG_SYSTEM_ID)
11009: SELECT
11010: okc_p_util.raw_to_number(sys_guid()),
11011: p_new_cpl_id CPL_ID, -- new party id (CPL_ID)
11012: CRO_CODE,
11013: DNZ_CHR_ID,
11014: OBJECT1_ID1,

Line 11079: l_new_coverage_id :=okc_p_util.raw_to_number(sys_guid());

11075: okc_debug.log('BEGIN COPY_STANDARD_COVERAGE'||l_return_status, 2);
11076: END IF;
11077:
11078: -- Create Coverage line
11079: l_new_coverage_id :=okc_p_util.raw_to_number(sys_guid());
11080: l_cov_flag :=1;
11081: l_return_status := CREATE_OKC_LINE(l_new_coverage_id,l_old_coverage_id,l_cov_flag);
11082: IF (G_DEBUG_ENABLED = 'Y') THEN
11083: okc_debug.log('AFTER CREATE_OKC_LINE FOR COVERAGE'||l_return_status, 2);

Line 11095: l_new_bp_id := okc_p_util.raw_to_number(sys_guid());

11091: -- Create business process line
11092: FOR Childline_Rec1 IN Cur_Childline(l_old_coverage_id) --Loop1
11093: LOOP
11094: l_old_bp_id := ChildLine_rec1.Id;
11095: l_new_bp_id := okc_p_util.raw_to_number(sys_guid());
11096: l_cov_flag := 2;
11097: l_return_status := CREATE_OKC_LINE(l_new_bp_id,l_old_bp_id,l_cov_flag,l_new_coverage_id);
11098: IF (G_DEBUG_ENABLED = 'Y') THEN
11099: okc_debug.log('AFTER CREATE_OKC_LINE FOR BP'||l_return_status, 2);

Line 11111: l_new_bp_item_id :=okc_p_util.raw_to_number(sys_guid());

11107: -- Create a Contract ITEM FOR BUSINESS PROCESS
11108: open CUR_ItemDet(l_old_bp_id);
11109: fetch CUR_ItemDet into l_old_bp_item_id;
11110: close CUR_ItemDet;
11111: l_new_bp_item_id :=okc_p_util.raw_to_number(sys_guid());
11112: l_return_status := CREATE_OKC_ITEM(l_new_bp_item_id,l_old_bp_item_id,l_new_bp_id);
11113: IF (G_DEBUG_ENABLED = 'Y') THEN
11114: okc_debug.log('AFTER CREATE_OKC_ITEM'||l_return_status, 2);
11115: END IF;

Line 11127: l_new_rt_id := okc_p_util.raw_to_number(sys_guid());

11123: -- Create Reaction times line Billtypes
11124: FOR tmp_crt_rec IN Cur_ChildLine1(l_old_bp_id)
11125: LOOP
11126: l_old_rt_id := tmp_crt_rec.ID;
11127: l_new_rt_id := okc_p_util.raw_to_number(sys_guid());
11128: l_cov_flag := 3;
11129: l_return_status := CREATE_OKC_LINE(l_new_rt_id,l_old_rt_id,l_cov_flag,l_new_bp_id);
11130: IF (G_DEBUG_ENABLED = 'Y') THEN
11131: okc_debug.log('AFTER CREATE_OKC_LINE FOR RT'||l_return_status, 2);

Line 11144: l_new_rt_item_id :=okc_p_util.raw_to_number(sys_guid());

11140: --Create entry in okc_k_items
11141: open CUR_ItemDet(l_old_rt_id);
11142: fetch CUR_ItemDet into l_old_rt_item_id;
11143: close CUR_ItemDet;
11144: l_new_rt_item_id :=okc_p_util.raw_to_number(sys_guid());
11145: l_return_status := CREATE_OKC_ITEM(l_new_rt_item_id,l_old_rt_item_id,l_new_rt_id);
11146: IF (G_DEBUG_ENABLED = 'Y') THEN
11147: okc_debug.log('AFTER CREATE_OKC_ITEM FOR RT'||l_return_status, 2);
11148: END IF;

Line 11160: l_new_br_id := okc_p_util.raw_to_number(sys_guid());

11156: LOOP
11157: l_old_br_id := tmp_br_Rec.ID;
11158: IF NOT l_old_br_id IS NULL
11159: THEN
11160: l_new_br_id := okc_p_util.raw_to_number(sys_guid());
11161: l_cov_flag := 4;
11162: l_return_status := CREATE_OKC_LINE(l_new_br_id,l_old_br_id,l_cov_flag,l_new_rt_id);
11163: IF (G_DEBUG_ENABLED = 'Y') THEN
11164: okc_debug.log('AFTER CREATE_OKC_LINE FOR BR'||l_return_status, 2);

Line 11183: l_new_party_id :=okc_p_util.raw_to_number(sys_guid());

11179: FETCH Cur_PTRLDet INTO cr_ptrl_det;
11180: IF Cur_PTRLDet % FOUND
11181: THEN
11182: l_old_party_id := cr_ptrl_det.id;
11183: l_new_party_id :=okc_p_util.raw_to_number(sys_guid());
11184: l_return_status := CREATE_OKC_PARTY(l_new_party_id,l_old_party_id,l_new_bp_id);
11185: IF (G_DEBUG_ENABLED = 'Y') THEN
11186: okc_debug.log('AFTER CREATE_OKC_PARTY'||l_return_status, 2);
11187: END IF;