APPS.OKS_BILL_MIGRATION dependencies on OKS_LEVEL_ELEMENTS

Line 753: FROM oks_level_elements lvl,oks_stream_levels_b rule

749: CURSOR level_elements_csr (p_id NUMBER) IS
750: SELECT lvl.id id, lvl.sequence_number sequence_number,
751: lvl.date_start date_start, lvl.amount amount,
752: lvl.date_completed date_completed
753: FROM oks_level_elements lvl,oks_stream_levels_b rule
754: WHERE lvl.rul_id = rule.id
755: AND rule.cle_id = p_id
756: ORDER BY lvl.date_start;
757:

Line 1006: UPDATE OKS_LEVEL_ELEMENTS

1002: l_bill_ctr:= 0 ;
1003:
1004: FOR l_bill_ctr in l_lvl_element_tbl.FIRST .. l_lvl_element_tbl.LAST
1005: LOOP
1006: UPDATE OKS_LEVEL_ELEMENTS
1007: SET amount = l_lvl_element_tbl(l_bill_ctr).amount,
1008: date_completed = l_lvl_element_tbl(l_bill_ctr).date_completed
1009: WHERE id = l_lvl_element_tbl(l_bill_ctr).id;
1010: END LOOP;

Line 1089: UPDATE OKS_LEVEL_ELEMENTS

1085: l_bill_ctr:= 0 ;
1086:
1087: FOR l_bill_ctr in l_lvl_element_tbl.FIRST .. l_lvl_element_tbl.LAST
1088: LOOP
1089: UPDATE OKS_LEVEL_ELEMENTS
1090: SET amount = l_lvl_element_tbl(l_bill_ctr).amount,
1091: date_completed = l_lvl_element_tbl(l_bill_ctr).date_completed
1092: WHERE id = l_lvl_element_tbl(l_bill_ctr).id;
1093: END LOOP;

Line 1187: insert into oks_level_elements

1183: open l_price_csr(p_line_id );
1184: fetch l_price_csr into l_top_sll_amount ;
1185: close l_price_csr;
1186:
1187: insert into oks_level_elements
1188: (id , sequence_number , date_start , amount , date_transaction, date_to_interface ,date_completed ,
1189: object_version_number , rul_id ,created_by , creation_date , last_updated_by , last_update_date ,
1190: cle_id, parent_cle_id, dnz_chr_id, date_end)
1191: values (l_top_sll_level_id,1 , p_srv_sdt ,l_top_sll_amount , sysdate ,sysdate ,sysdate ,1 ,l_top_line_sll_id ,

Line 1214: insert into oks_level_elements

1210:
1211:
1212: l_sub_sll_level_id := get_seq_id ;
1213:
1214: insert into oks_level_elements
1215: (id , sequence_number , date_start , amount , date_transaction, date_to_interface ,date_completed ,
1216: object_version_number , rul_id ,created_by , creation_date , last_updated_by , last_update_date ,
1217: cle_id, parent_cle_id, dnz_chr_id, date_end)
1218: values (l_sub_sll_level_id,1 , l_sub_line_rec.sub_line_start_date ,l_sub_line_rec.sub_line_price_negotiated

Line 1459: FROM oks_level_elements lvl, oks_stream_levels_b rule

1455: CURSOR level_elements_csr (p_id NUMBER) IS
1456: SELECT lvl.id id, lvl.sequence_number sequence_number,
1457: lvl.date_start date_start, lvl.amount amount,
1458: lvl.date_completed date_completed
1459: FROM oks_level_elements lvl, oks_stream_levels_b rule
1460: WHERE lvl.rul_id = rule.id
1461: AND rule.cle_id = p_id
1462: ORDER BY lvl.date_start;
1463:

Line 1901: UPDATE OKS_LEVEL_ELEMENTS

1897: -----updating records directly
1898:
1899: FOR l_tbl in l_lvl_element_tbl.FIRST .. l_lvl_element_tbl.LAST
1900: LOOP
1901: UPDATE OKS_LEVEL_ELEMENTS
1902: SET amount = l_lvl_element_tbl(l_tbl).amount,
1903: date_completed = l_lvl_element_tbl(l_tbl).date_completed
1904: WHERE id = l_lvl_element_tbl(l_tbl).id;
1905: END LOOP;

Line 1992: UPDATE OKS_LEVEL_ELEMENTS

1988: -----updating records directly
1989:
1990: FOR l_tbl in l_lvl_element_tbl.FIRST .. l_lvl_element_tbl.LAST
1991: LOOP
1992: UPDATE OKS_LEVEL_ELEMENTS
1993: SET amount = l_lvl_element_tbl(l_tbl).amount,
1994: date_completed = l_lvl_element_tbl(l_tbl).date_completed
1995: WHERE id = l_lvl_element_tbl(l_tbl).id;
1996: END LOOP;

Line 2228: UPDATE_OKS_LEVEL_ELEMENTS( P_DNZ_CHR_ID ,

2224: L_CONTINUE_PROCESSING := TRUE ;
2225: END IF ;
2226:
2227: IF L_CONTINUE_PROCESSING AND L_RETURN_STATUS = OKC_API.G_RET_STS_SUCCESS THEN
2228: UPDATE_OKS_LEVEL_ELEMENTS( P_DNZ_CHR_ID ,
2229: X_RETURN_STATUS );
2230: IF (L_RETURN_STATUS <> 'S') THEN
2231: X_RETURN_STATUS := L_RETURN_STATUS;
2232: Raise G_EXCEPTION_HALT_VALIDATION;

Line 2253: PROCEDURE UPDATE_OKS_LEVEL_ELEMENTS

2249:
2250:
2251:
2252:
2253: PROCEDURE UPDATE_OKS_LEVEL_ELEMENTS
2254: ( p_dnz_chr_id IN number ,
2255: x_return_status OUT NOCOPY varchar2 ) IS
2256:
2257: G_EXCEPTION_HALT_VALIDATION exception ;

Line 2262: update oks_level_elements

2258:
2259:
2260: BEGIN
2261:
2262: update oks_level_elements
2263: set date_completed = sysdate
2264: where dnz_chr_id = p_dnz_chr_id;
2265:
2266: X_RETURN_STATUS := 'S' ;

Line 2274: END UPDATE_OKS_LEVEL_ELEMENTS ;

2270: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2271: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
2272:
2273:
2274: END UPDATE_OKS_LEVEL_ELEMENTS ;
2275:
2276:
2277: END OKS_BILL_MIGRATION;