APPS.OKS_COVERAGES_PVT dependencies on OKC_P_UTIL

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

10993: RESOURCE_CLASS,
10994: SALES_GROUP_ID)
10995: --ORIG_SYSTEM_ID)
10996: SELECT
10997: okc_p_util.raw_to_number(sys_guid()),
10998: p_new_cpl_id CPL_ID, -- new party id (CPL_ID)
10999: CRO_CODE,
11000: DNZ_CHR_ID,
11001: OBJECT1_ID1,

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

11061: okc_debug.log('BEGIN COPY_STANDARD_COVERAGE'||l_return_status, 2);
11062: END IF;
11063:
11064: -- Create Coverage line
11065: l_new_coverage_id :=okc_p_util.raw_to_number(sys_guid());
11066: l_cov_flag :=1;
11067: l_return_status := CREATE_OKC_LINE(l_new_coverage_id,l_old_coverage_id,l_cov_flag);
11068: IF (G_DEBUG_ENABLED = 'Y') THEN
11069: okc_debug.log('AFTER CREATE_OKC_LINE FOR COVERAGE'||l_return_status, 2);

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

11077: -- Create business process line
11078: FOR Childline_Rec1 IN Cur_Childline(l_old_coverage_id) --Loop1
11079: LOOP
11080: l_old_bp_id := ChildLine_rec1.Id;
11081: l_new_bp_id := okc_p_util.raw_to_number(sys_guid());
11082: l_cov_flag := 2;
11083: l_return_status := CREATE_OKC_LINE(l_new_bp_id,l_old_bp_id,l_cov_flag,l_new_coverage_id);
11084: IF (G_DEBUG_ENABLED = 'Y') THEN
11085: okc_debug.log('AFTER CREATE_OKC_LINE FOR BP'||l_return_status, 2);

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

11093: -- Create a Contract ITEM FOR BUSINESS PROCESS
11094: open CUR_ItemDet(l_old_bp_id);
11095: fetch CUR_ItemDet into l_old_bp_item_id;
11096: close CUR_ItemDet;
11097: l_new_bp_item_id :=okc_p_util.raw_to_number(sys_guid());
11098: l_return_status := CREATE_OKC_ITEM(l_new_bp_item_id,l_old_bp_item_id,l_new_bp_id);
11099: IF (G_DEBUG_ENABLED = 'Y') THEN
11100: okc_debug.log('AFTER CREATE_OKC_ITEM'||l_return_status, 2);
11101: END IF;

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

11109: -- Create Reaction times line Billtypes
11110: FOR tmp_crt_rec IN Cur_ChildLine1(l_old_bp_id)
11111: LOOP
11112: l_old_rt_id := tmp_crt_rec.ID;
11113: l_new_rt_id := okc_p_util.raw_to_number(sys_guid());
11114: l_cov_flag := 3;
11115: l_return_status := CREATE_OKC_LINE(l_new_rt_id,l_old_rt_id,l_cov_flag,l_new_bp_id);
11116: IF (G_DEBUG_ENABLED = 'Y') THEN
11117: okc_debug.log('AFTER CREATE_OKC_LINE FOR RT'||l_return_status, 2);

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

11126: --Create entry in okc_k_items
11127: open CUR_ItemDet(l_old_rt_id);
11128: fetch CUR_ItemDet into l_old_rt_item_id;
11129: close CUR_ItemDet;
11130: l_new_rt_item_id :=okc_p_util.raw_to_number(sys_guid());
11131: l_return_status := CREATE_OKC_ITEM(l_new_rt_item_id,l_old_rt_item_id,l_new_rt_id);
11132: IF (G_DEBUG_ENABLED = 'Y') THEN
11133: okc_debug.log('AFTER CREATE_OKC_ITEM FOR RT'||l_return_status, 2);
11134: END IF;

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

11142: LOOP
11143: l_old_br_id := tmp_br_Rec.ID;
11144: IF NOT l_old_br_id IS NULL
11145: THEN
11146: l_new_br_id := okc_p_util.raw_to_number(sys_guid());
11147: l_cov_flag := 4;
11148: l_return_status := CREATE_OKC_LINE(l_new_br_id,l_old_br_id,l_cov_flag,l_new_rt_id);
11149: IF (G_DEBUG_ENABLED = 'Y') THEN
11150: okc_debug.log('AFTER CREATE_OKC_LINE FOR BR'||l_return_status, 2);

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

11165: FETCH Cur_PTRLDet INTO cr_ptrl_det;
11166: IF Cur_PTRLDet % FOUND
11167: THEN
11168: l_old_party_id := cr_ptrl_det.id;
11169: l_new_party_id :=okc_p_util.raw_to_number(sys_guid());
11170: l_return_status := CREATE_OKC_PARTY(l_new_party_id,l_old_party_id,l_new_bp_id);
11171: IF (G_DEBUG_ENABLED = 'Y') THEN
11172: okc_debug.log('AFTER CREATE_OKC_PARTY'||l_return_status, 2);
11173: END IF;