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 896: ,oks_level_elements le

892: str.uom_code advance_period,
893: str.uom_per_period tuom_per_period,
894: str.start_date tp_start_date
895: FROM oks_stream_levels_b str
896: ,oks_level_elements le
897: WHERE le.cle_id = p_id
898: AND le.rul_id = str.id
899: AND le.date_completed IS NULL
900: AND trunc(nvl(le.date_to_interface,sysdate)) <= trunc(p_date)

Line 913: FROM oks_level_elements lvl

909:
910:
911: Cursor l_next_level_element(p_cle_id in NUMBER,p_date in DATE) IS
912: SELECT lvl.date_start
913: FROM oks_level_elements lvl
914: WHERE lvl.cle_id = p_cle_id
915: AND lvl.date_start > p_date
916: ORDER BY lvl.date_start;
917:

Line 1047: From oks_level_elements

1043: l_total_inv_billed Number;
1044:
1045: Cursor l_csr_total_inv_billed IS
1046: Select count(id)
1047: From oks_level_elements
1048: Where rul_id = p_rule_id
1049: And date_completed IS NOT NULL;
1050:
1051: Begin

Line 1079: DELETE from OKS_LEVEL_ELEMENTS

1075: Begin
1076:
1077: --delete level elements for given sll id
1078:
1079: DELETE from OKS_LEVEL_ELEMENTS
1080: where rul_id = p_rul_id ;
1081:
1082: --DELETE SLL
1083: DELETE FROM oks_stream_levels_b

Line 1315: DELETE FROM OKS_LEVEL_ELEMENTS

1311:
1312: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1313:
1314: IF p_cle_id is NULL THEN /* when input parm is p_chr_id */
1315: DELETE FROM OKS_LEVEL_ELEMENTS
1316: WHERE Date_Completed is NULL
1317: AND TRUNC(date_start) >= TRUNC(p_terminated_date)
1318: AND dnz_chr_id = p_chr_id;
1319:

Line 1323: DELETE FROM OKS_LEVEL_ELEMENTS

1319:
1320:
1321: ELSE
1322:
1323: DELETE FROM OKS_LEVEL_ELEMENTS
1324: WHERE Date_Completed is NULL
1325: AND TRUNC(date_start) >= TRUNC(p_terminated_date)
1326: AND cle_id = p_cle_id;
1327:

Line 1333: DELETE FROM OKS_LEVEL_ELEMENTS

1329:
1330: FOR l_subline_rec IN l_subline_csr(p_cle_id)
1331: LOOP
1332:
1333: DELETE FROM OKS_LEVEL_ELEMENTS
1334: WHERE Date_Completed is NULL
1335: AND TRUNC(date_start) >= nvl(TRUNC(l_subline_rec.cp_term_dt),TRUNC(p_terminated_date))
1336: AND cle_id = l_subline_rec.id;
1337: END LOOP;

Line 3679: PROCEDURE UPDATE_OKS_LEVEL_ELEMENTS

3675:
3676: /* *** --------------------------------------------- *** */
3677:
3678:
3679: PROCEDURE UPDATE_OKS_LEVEL_ELEMENTS
3680: ( p_line_id IN number ,
3681: x_return_status OUT NOCOPY varchar2 ) IS
3682:
3683: CURSOR L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID in NUMBER ) IS

Line 3683: CURSOR L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID in NUMBER ) IS

3679: PROCEDURE UPDATE_OKS_LEVEL_ELEMENTS
3680: ( p_line_id IN number ,
3681: x_return_status OUT NOCOPY varchar2 ) IS
3682:
3683: CURSOR L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID in NUMBER ) IS
3684: SELECT LEVL.ID
3685: FROM OKS_LEVEL_ELEMENTS LEVL ,
3686: OKC_RULES_B RULES ,
3687: OKC_RULE_GROUPS_B RGP

Line 3685: FROM OKS_LEVEL_ELEMENTS LEVL ,

3681: x_return_status OUT NOCOPY varchar2 ) IS
3682:
3683: CURSOR L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID in NUMBER ) IS
3684: SELECT LEVL.ID
3685: FROM OKS_LEVEL_ELEMENTS LEVL ,
3686: OKC_RULES_B RULES ,
3687: OKC_RULE_GROUPS_B RGP
3688: WHERE LEVL.RUL_ID = RULES.ID
3689: AND RULES.RGP_ID = RGP.ID

Line 3700: L_OKS_LEVEL_ELEMENTS_REC L_OKS_LEVEL_ELEMENTS_CSR%ROWTYPE ;

3696: FROM OKC_K_LINES_V LINES
3697: WHERE LINES.CLE_ID = P_TOP_LINE_ID
3698: AND LINES.LSE_ID in (9, 25 );
3699:
3700: L_OKS_LEVEL_ELEMENTS_REC L_OKS_LEVEL_ELEMENTS_CSR%ROWTYPE ;
3701: L_GET_SUB_LINES_REC L_GET_SUB_LINES_CSR%ROWTYPE ;
3702:
3703: SUBTYPE LEVEL_ID_TBL IS OKS_BILL_LEVEL_ELEMENTS_PVT.letv_tbl_type ;
3704: L_LEVEL_ID_TBL_IN LEVEL_ID_TBL ;

Line 3718: FOR L_OKS_LEVEL_ELEMENTS_REC IN L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID )

3714:
3715:
3716: /*************************************************************************************
3717: --THIS WILL POPULATE THE TABLE WITH THE LEVEL ELEMENTS OF TOP LINE..
3718: FOR L_OKS_LEVEL_ELEMENTS_REC IN L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID )
3719: LOOP
3720: L_LEVEL_ID_TBL_IN(COUNTER).ID := L_OKS_LEVEL_ELEMENTS_REC.ID ;
3721: L_LEVEL_ID_TBL_IN(COUNTER).DATE_COMPLETED := SYSDATE;
3722: COUNTER := COUNTER+1 ;

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

3716: /*************************************************************************************
3717: --THIS WILL POPULATE THE TABLE WITH THE LEVEL ELEMENTS OF TOP LINE..
3718: FOR L_OKS_LEVEL_ELEMENTS_REC IN L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID )
3719: LOOP
3720: L_LEVEL_ID_TBL_IN(COUNTER).ID := L_OKS_LEVEL_ELEMENTS_REC.ID ;
3721: L_LEVEL_ID_TBL_IN(COUNTER).DATE_COMPLETED := SYSDATE;
3722: COUNTER := COUNTER+1 ;
3723: END LOOP ;
3724:

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

3723: END LOOP ;
3724:
3725: FOR L_GET_SUB_LINES_REC IN L_GET_SUB_LINES_CSR( P_LINE_ID )
3726: LOOP
3727: FOR L_OKS_LEVEL_ELEMENTS_REC IN L_OKS_LEVEL_ELEMENTS_CSR ( L_GET_SUB_LINES_REC.ID )
3728: LOOP
3729: L_LEVEL_ID_TBL_IN(COUNTER).ID := L_OKS_LEVEL_ELEMENTS_REC.ID ;
3730: L_LEVEL_ID_TBL_IN(COUNTER).DATE_COMPLETED := SYSDATE;
3731: COUNTER := COUNTER+1 ;

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

3725: FOR L_GET_SUB_LINES_REC IN L_GET_SUB_LINES_CSR( P_LINE_ID )
3726: LOOP
3727: FOR L_OKS_LEVEL_ELEMENTS_REC IN L_OKS_LEVEL_ELEMENTS_CSR ( L_GET_SUB_LINES_REC.ID )
3728: LOOP
3729: L_LEVEL_ID_TBL_IN(COUNTER).ID := L_OKS_LEVEL_ELEMENTS_REC.ID ;
3730: L_LEVEL_ID_TBL_IN(COUNTER).DATE_COMPLETED := SYSDATE;
3731: COUNTER := COUNTER+1 ;
3732: END LOOP ;
3733: END LOOP ;

Line 3755: Update oks_level_elements

3751: Raise G_EXCEPTION_HALT_VALIDATION;
3752: END IF;
3753: END IF ;
3754: ***************************************************************************************/
3755: Update oks_level_elements
3756: set date_completed = SYSDATE
3757: where parent_cle_id = p_line_id
3758: and date_completed is null;
3759:

Line 3770: END UPDATE_OKS_LEVEL_ELEMENTS ;

3766: WHEN OTHERS THEN
3767: X_RETURN_STATUS := OKC_API.G_RET_STS_UNEXP_ERROR;
3768: OKC_API.SET_MESSAGE(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
3769:
3770: END UPDATE_OKS_LEVEL_ELEMENTS ;
3771:
3772:
3773: PROCEDURE CREATE_BCL_FOR_OM ( P_LINE_ID IN NUMBER ,
3774: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ) IS

Line 3935: UPDATE_OKS_LEVEL_ELEMENTS(L_GET_OKS_LINES_REC.id ,

3931: END IF;
3932: END IF ;
3933:
3934: IF L_RETURN_STATUS = OKC_API.G_RET_STS_SUCCESS THEN
3935: UPDATE_OKS_LEVEL_ELEMENTS(L_GET_OKS_LINES_REC.id ,
3936: X_RETURN_STATUS );
3937: IF (L_RETURN_STATUS <> 'S') THEN
3938: X_RETURN_STATUS := L_RETURN_STATUS;
3939: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 4303: FROM oks_level_elements

4299: IS
4300:
4301: CURSOR l_billed_rec_csr IS
4302: SELECT count(id)
4303: FROM oks_level_elements
4304: WHERE dnz_chr_id = p_header_id
4305: AND date_completed IS NOT NULL;
4306:
4307: l_billed_count NUMBER;

Line 4670: UPDATE oks_level_elements

4666:
4667: END LOOP;
4668:
4669: IF l_max_billed_dt IS NOT NULL THEN
4670: UPDATE oks_level_elements
4671: SET date_completed = SYSDATE
4672: WHERE TRUNC(date_start) <= TRUNC(l_max_billed_dt)
4673: AND cle_id =p_new_cp_id ;
4674: