APPS.OKS_INSERT_ROW_UPG dependencies on FND_PROFILE

Line 5: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: PACKAGE BODY OKS_Insert_Row_Upg AS
2: /* $Header: OKSCOVUB.pls 120.0 2005/05/25 17:40:38 appldev noship $ */
3:
4:
5: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6:
7: PROCEDURE INSERT_ROW_UPG_CTZV_TBL
8: (x_return_status OUT NOCOPY VARCHAR2,
9: P_CTZV_TBL OKS_CTZ_PVT.OksCoverageTimezonesVTblType) IS

Line 277: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

273: P_ACMV_TBL OKS_ACM_PVT.oks_action_times_v_tbl_type) IS
274:
275: l_tabsize NUMBER := P_ACMV_TBL.COUNT;
276: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
277: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
278: In_ID OKC_DATATYPES.NumberTabTyp;
279: In_COV_ACTION_TYPE_ID OKC_DATATYPES.NumberTabTyp;
280: In_CLE_ID OKC_DATATYPES.NumberTabTyp;
281: In_DNZ_CHR_ID OKC_DATATYPES.NumberTabTyp;

Line 419: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

415: P_ACTV_TBL OKS_ACT_PVT.OksActionTimeTypesVTblType) IS
416:
417: l_tabsize NUMBER := P_ACTV_TBL.COUNT;
418: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
419: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
420: In_ID OKC_DATATYPES.NumberTabTyp;
421: In_CLE_ID OKC_DATATYPES.NumberTabTyp;
422: In_DNZ_CHR_ID OKC_DATATYPES.NumberTabTyp;
423: In_ACTION_TYPE_CODE OKC_DATATYPES.VAR30TabTyp;

Line 530: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

526: P_KLNV_TBL OKS_KLN_PVT.klnv_tbl_type) IS
527:
528: l_tabsize NUMBER := P_KLNV_TBL.COUNT;
529: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
530: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
531: --In_ROW_ID OKC_DATATYPES.;
532: In_ID OKC_DATATYPES.NumberTabTyp;
533: In_CLE_ID OKC_DATATYPES.NumberTabTyp;
534: In_DNZ_CHR_ID OKC_DATATYPES.NumberTabTyp;

Line 970: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

966: p_oks_billrate_schedules_v_tbl OKS_BRS_PVT.OksBillrateSchedulesVTblType) IS
967:
968: l_tabsize NUMBER := p_oks_billrate_schedules_v_tbl.COUNT;
969: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
970: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
971: In_ID OKC_DATATYPES.NumberTabTyp;
972: In_CLE_ID OKC_DATATYPES.NumberTabTyp;
973: In_BT_CLE_ID OKC_DATATYPES.NumberTabTyp;
974: In_DNZ_CHR_ID OKC_DATATYPES.NumberTabTyp;

Line 1154: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1150:
1151:
1152: l_tabsize NUMBER := P_KHRV_TBL.COUNT;
1153: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
1154: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
1155: In_ID OKC_DATATYPES.NumberTabTyp;
1156: In_CHR_ID OKC_DATATYPES.NumberTabTyp;
1157: In_ACCT_RULE_ID OKC_DATATYPES.NumberTabTyp;
1158: In_PAYMENT_TYPE OKC_DATATYPES.VAR30TabTyp;

Line 1467: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1463:
1464: PROCEDURE INSERT_ROW_UPG_sllv_tbl (x_return_status OUT NOCOPY VARCHAR2, p_sllv_tbl OKS_SLL_PVT.sllv_tbl_type) IS
1465: l_tabsize NUMBER := p_sllv_tbl.COUNT;
1466: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
1467: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
1468: In_ID OKC_DATATYPES.NumberTabTyp;
1469: In_CHR_ID OKC_DATATYPES.NumberTabTyp;
1470: In_CLE_ID OKC_DATATYPES.NumberTabTyp;
1471: In_DNZ_CHR_ID OKC_DATATYPES.NumberTabTyp;

Line 1611: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1607:
1608: PROCEDURE INSERT_ROW_UPG_letv_tbl (x_return_status OUT NOCOPY VARCHAR2, p_letv_tbl OKS_BILL_LEVEL_ELEMENTS_PVT.letv_tbl_type) IS
1609: l_tabsize NUMBER := p_letv_tbl.COUNT;
1610: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
1611: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
1612: In_ID OKC_DATATYPES.NumberTabTyp;
1613: In_SEQUENCE_NUMBER OKC_DATATYPES.VAR240TabTyp;
1614: In_DATE_START OKC_DATATYPES.DateTabTyp;
1615: In_AMOUNT OKC_DATATYPES.NumberTabTyp;