eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_BILL_UTIL_PUB dependencies on OKS_LEVEL_ELEMENTS

Line 930: ,oks_level_elements le

926: str.uom_code advance_period,
927: str.uom_per_period tuom_per_period,
928: str.start_date tp_start_date
929: FROM oks_stream_levels_b str
930: ,oks_level_elements le
931: WHERE le.cle_id = p_id
932: AND le.rul_id = str.id
933: AND le.date_completed IS NULL
934: AND trunc(nvl(le.date_to_interface,sysdate)) <= trunc(p_date)

Line 947: FROM oks_level_elements lvl

943:
944:
945: Cursor l_next_level_element(p_cle_id in NUMBER,p_date in DATE) IS
946: SELECT lvl.date_start
947: FROM oks_level_elements lvl
948: WHERE lvl.cle_id = p_cle_id
949: AND lvl.date_start > p_date
950: ORDER BY lvl.date_start;
951:

Line 1081: From oks_level_elements

1077: l_total_inv_billed Number;
1078:
1079: Cursor l_csr_total_inv_billed IS
1080: Select count(id)
1081: From oks_level_elements
1082: Where rul_id = p_rule_id
1083: And date_completed IS NOT NULL;
1084:
1085: Begin

Line 1113: DELETE from OKS_LEVEL_ELEMENTS

1109: Begin
1110:
1111: --delete level elements for given sll id
1112:
1113: DELETE from OKS_LEVEL_ELEMENTS
1114: where rul_id = p_rul_id ;
1115:
1116: --DELETE SLL
1117: DELETE FROM oks_stream_levels_b

Line 1349: DELETE FROM OKS_LEVEL_ELEMENTS

1345:
1346: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1347:
1348: IF p_cle_id is NULL THEN /* when input parm is p_chr_id */
1349: DELETE FROM OKS_LEVEL_ELEMENTS
1350: WHERE Date_Completed is NULL
1351: AND TRUNC(date_start) >= TRUNC(p_terminated_date)
1352: AND dnz_chr_id = p_chr_id;
1353:

Line 1357: DELETE FROM OKS_LEVEL_ELEMENTS

1353:
1354:
1355: ELSE
1356:
1357: DELETE FROM OKS_LEVEL_ELEMENTS
1358: WHERE Date_Completed is NULL
1359: AND TRUNC(date_start) >= TRUNC(p_terminated_date)
1360: AND cle_id = p_cle_id;
1361:

Line 1367: DELETE FROM OKS_LEVEL_ELEMENTS

1363:
1364: FOR l_subline_rec IN l_subline_csr(p_cle_id)
1365: LOOP
1366:
1367: DELETE FROM OKS_LEVEL_ELEMENTS
1368: WHERE Date_Completed is NULL
1369: AND TRUNC(date_start) >= nvl(TRUNC(l_subline_rec.cp_term_dt),TRUNC(p_terminated_date))
1370: AND cle_id = l_subline_rec.id;
1371: END LOOP;

Line 3714: PROCEDURE UPDATE_OKS_LEVEL_ELEMENTS

3710:
3711: /* *** --------------------------------------------- *** */
3712:
3713:
3714: PROCEDURE UPDATE_OKS_LEVEL_ELEMENTS
3715: ( p_line_id IN number ,
3716: x_return_status OUT NOCOPY varchar2 ) IS
3717:
3718: CURSOR L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID in NUMBER ) IS

Line 3718: CURSOR L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID in NUMBER ) IS

3714: PROCEDURE UPDATE_OKS_LEVEL_ELEMENTS
3715: ( p_line_id IN number ,
3716: x_return_status OUT NOCOPY varchar2 ) IS
3717:
3718: CURSOR L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID in NUMBER ) IS
3719: SELECT LEVL.ID
3720: FROM OKS_LEVEL_ELEMENTS LEVL ,
3721: OKC_RULES_B RULES ,
3722: OKC_RULE_GROUPS_B RGP

Line 3720: FROM OKS_LEVEL_ELEMENTS LEVL ,

3716: x_return_status OUT NOCOPY varchar2 ) IS
3717:
3718: CURSOR L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID in NUMBER ) IS
3719: SELECT LEVL.ID
3720: FROM OKS_LEVEL_ELEMENTS LEVL ,
3721: OKC_RULES_B RULES ,
3722: OKC_RULE_GROUPS_B RGP
3723: WHERE LEVL.RUL_ID = RULES.ID
3724: AND RULES.RGP_ID = RGP.ID

Line 3735: L_OKS_LEVEL_ELEMENTS_REC L_OKS_LEVEL_ELEMENTS_CSR%ROWTYPE ;

3731: FROM OKC_K_LINES_V LINES
3732: WHERE LINES.CLE_ID = P_TOP_LINE_ID
3733: AND LINES.LSE_ID in (9, 25 );
3734:
3735: L_OKS_LEVEL_ELEMENTS_REC L_OKS_LEVEL_ELEMENTS_CSR%ROWTYPE ;
3736: L_GET_SUB_LINES_REC L_GET_SUB_LINES_CSR%ROWTYPE ;
3737:
3738: SUBTYPE LEVEL_ID_TBL IS OKS_BILL_LEVEL_ELEMENTS_PVT.letv_tbl_type ;
3739: L_LEVEL_ID_TBL_IN LEVEL_ID_TBL ;

Line 3753: FOR L_OKS_LEVEL_ELEMENTS_REC IN L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID )

3749:
3750:
3751: /*************************************************************************************
3752: --THIS WILL POPULATE THE TABLE WITH THE LEVEL ELEMENTS OF TOP LINE..
3753: FOR L_OKS_LEVEL_ELEMENTS_REC IN L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID )
3754: LOOP
3755: L_LEVEL_ID_TBL_IN(COUNTER).ID := L_OKS_LEVEL_ELEMENTS_REC.ID ;
3756: L_LEVEL_ID_TBL_IN(COUNTER).DATE_COMPLETED := SYSDATE;
3757: COUNTER := COUNTER+1 ;

Line 3755: L_LEVEL_ID_TBL_IN(COUNTER).ID := L_OKS_LEVEL_ELEMENTS_REC.ID ;

3751: /*************************************************************************************
3752: --THIS WILL POPULATE THE TABLE WITH THE LEVEL ELEMENTS OF TOP LINE..
3753: FOR L_OKS_LEVEL_ELEMENTS_REC IN L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID )
3754: LOOP
3755: L_LEVEL_ID_TBL_IN(COUNTER).ID := L_OKS_LEVEL_ELEMENTS_REC.ID ;
3756: L_LEVEL_ID_TBL_IN(COUNTER).DATE_COMPLETED := SYSDATE;
3757: COUNTER := COUNTER+1 ;
3758: END LOOP ;
3759:

Line 3762: FOR L_OKS_LEVEL_ELEMENTS_REC IN L_OKS_LEVEL_ELEMENTS_CSR ( L_GET_SUB_LINES_REC.ID )

3758: END LOOP ;
3759:
3760: FOR L_GET_SUB_LINES_REC IN L_GET_SUB_LINES_CSR( P_LINE_ID )
3761: LOOP
3762: FOR L_OKS_LEVEL_ELEMENTS_REC IN L_OKS_LEVEL_ELEMENTS_CSR ( L_GET_SUB_LINES_REC.ID )
3763: LOOP
3764: L_LEVEL_ID_TBL_IN(COUNTER).ID := L_OKS_LEVEL_ELEMENTS_REC.ID ;
3765: L_LEVEL_ID_TBL_IN(COUNTER).DATE_COMPLETED := SYSDATE;
3766: COUNTER := COUNTER+1 ;

Line 3764: L_LEVEL_ID_TBL_IN(COUNTER).ID := L_OKS_LEVEL_ELEMENTS_REC.ID ;

3760: FOR L_GET_SUB_LINES_REC IN L_GET_SUB_LINES_CSR( P_LINE_ID )
3761: LOOP
3762: FOR L_OKS_LEVEL_ELEMENTS_REC IN L_OKS_LEVEL_ELEMENTS_CSR ( L_GET_SUB_LINES_REC.ID )
3763: LOOP
3764: L_LEVEL_ID_TBL_IN(COUNTER).ID := L_OKS_LEVEL_ELEMENTS_REC.ID ;
3765: L_LEVEL_ID_TBL_IN(COUNTER).DATE_COMPLETED := SYSDATE;
3766: COUNTER := COUNTER+1 ;
3767: END LOOP ;
3768: END LOOP ;

Line 3790: Update oks_level_elements

3786: Raise G_EXCEPTION_HALT_VALIDATION;
3787: END IF;
3788: END IF ;
3789: ***************************************************************************************/
3790: Update oks_level_elements
3791: set date_completed = SYSDATE
3792: where parent_cle_id = p_line_id
3793: and date_completed is null;
3794:

Line 3805: END UPDATE_OKS_LEVEL_ELEMENTS ;

3801: WHEN OTHERS THEN
3802: X_RETURN_STATUS := OKC_API.G_RET_STS_UNEXP_ERROR;
3803: OKC_API.SET_MESSAGE(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
3804:
3805: END UPDATE_OKS_LEVEL_ELEMENTS ;
3806:
3807:
3808: PROCEDURE CREATE_BCL_FOR_OM ( P_LINE_ID IN NUMBER ,
3809: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ) IS

Line 3970: UPDATE_OKS_LEVEL_ELEMENTS(L_GET_OKS_LINES_REC.id ,

3966: END IF;
3967: END IF ;
3968:
3969: IF L_RETURN_STATUS = OKC_API.G_RET_STS_SUCCESS THEN
3970: UPDATE_OKS_LEVEL_ELEMENTS(L_GET_OKS_LINES_REC.id ,
3971: X_RETURN_STATUS );
3972: IF (L_RETURN_STATUS <> 'S') THEN
3973: X_RETURN_STATUS := L_RETURN_STATUS;
3974: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 4023: FROM OKS_LEVEL_ELEMENTS LINES

4019: FROM okc_k_lines_b
4020: WHERE id=k_line_id;
4021: CURSOR L_LEVEL_ELEMENTS (L_LINE_ID NUMBER) IS
4022: SELECT LINES.AMOUNT
4023: FROM OKS_LEVEL_ELEMENTS LINES
4024: WHERE LINES.CLE_ID = L_LINE_ID;
4025:
4026: /*Added for ER 16039380*/
4027:

Line 4354: Update oks_level_elements

4350: RAISE G_EXCEPTION_HALT_VALIDATION;
4351: END IF;
4352: END IF;
4353: IF L_RETURN_STATUS = OKC_API.G_RET_STS_SUCCESS THEN
4354: Update oks_level_elements
4355: set date_completed = SYSDATE
4356: where parent_cle_id = p_line_id
4357: and date_completed is NULL
4358: AND date_start =L_BCLV_REC_IN.DATE_BILLED_FROM

Line 4386: FROM OKS_LEVEL_ELEMENTS LINES

4382: WHERE LINES.CLE_ID = P_LINE_ID
4383: AND LINES.LSE_ID in (9, 25) ;
4384: CURSOR L_LEVEL_ELEMENTS (L_LINE_ID NUMBER,L_DATE_FROM DATE ) IS
4385: SELECT LINES.AMOUNT
4386: FROM OKS_LEVEL_ELEMENTS LINES
4387: WHERE LINES.CLE_ID = L_LINE_ID
4388: AND LINES.DATE_START = L_DATE_FROM
4389: AND LINES.DATE_END =P_DATE_TO;
4390: CURSOR l_get_itm_uom_csr(p_cp_id NUMBER) IS

Line 4797: FROM oks_level_elements

4793: IS
4794:
4795: CURSOR l_billed_rec_csr IS
4796: SELECT count(id)
4797: FROM oks_level_elements
4798: WHERE dnz_chr_id = p_header_id
4799: AND date_completed IS NOT NULL;
4800:
4801: l_billed_count NUMBER;

Line 5164: UPDATE oks_level_elements

5160:
5161: END LOOP;
5162:
5163: IF l_max_billed_dt IS NOT NULL THEN
5164: UPDATE oks_level_elements
5165: SET date_completed = SYSDATE
5166: WHERE TRUNC(date_start) <= TRUNC(l_max_billed_dt)
5167: AND cle_id =p_new_cp_id ;
5168: