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_INSERT_ROW_UPG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7


PROCEDURE INSERT_ROW_UPG_CTZV_TBL
						(x_return_status OUT NOCOPY VARCHAR2,
						P_CTZV_TBL  OKS_CTZ_PVT.OksCoverageTimezonesVTblType) IS

		l_tabsize NUMBER := P_CTZV_TBL.COUNT;

Line: 20


		In_LAST_UPDATED_BY           OKC_DATATYPES.NumberTabTyp;

Line: 21


		In_LAST_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 22


		In_LAST_UPDATE_LOGIN           OKC_DATATYPES.NumberTabTyp;

Line: 26


		In_PROGRAM_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 36


			okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

Line: 49


		In_LAST_UPDATED_BY(j)    :=      P_CTZV_TBL(i).LAST_UPDATED_BY;

Line: 50


		In_LAST_UPDATE_DATE(j)    :=      P_CTZV_TBL(i).LAST_UPDATE_DATE;

Line: 51


		In_LAST_UPDATE_LOGIN(j)    :=      P_CTZV_TBL(i).LAST_UPDATE_LOGIN;

Line: 55


		In_PROGRAM_UPDATE_DATE(j)    :=      P_CTZV_TBL(i).PROGRAM_UPDATE_DATE;

Line: 64


INSERT      INTO oks_coverage_timezones (
		ID,
		CLE_ID,
		DEFAULT_YN,
		TIMEZONE_ID,
		DNZ_CHR_ID,
		CREATED_BY,
		CREATION_DATE,
		LAST_UPDATED_BY,
		LAST_UPDATE_DATE,
		LAST_UPDATE_LOGIN,
		SECURITY_GROUP_ID,
		PROGRAM_APPLICATION_ID,
		PROGRAM_ID,
		PROGRAM_UPDATE_DATE,
		REQUEST_ID,
		OBJECT_VERSION_NUMBER)
		VALUES (
		in_ID(i),
		in_CLE_ID(i),
		in_DEFAULT_YN(i),
		in_TIMEZONE_ID(i),
		in_DNZ_CHR_ID(i),
		in_CREATED_BY(i),
		in_CREATION_DATE(i),
		in_LAST_UPDATED_BY(i),
		in_LAST_UPDATE_DATE(i),
		in_LAST_UPDATE_LOGIN(i),
		in_SECURITY_GROUP_ID(i),
		in_PROGRAM_APPLICATION_ID(i),
		in_PROGRAM_ID(i),
		in_PROGRAM_UPDATE_DATE(i),
		in_REQUEST_ID(i),
		in_OBJECT_VERSION_NUMBER(i));

Line: 100


			okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

Line: 107


			okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

Line: 121


END INSERT_ROW_UPG_CTZV_TBL;

Line: 124


PROCEDURE INSERT_ROW_UPG_CVTV_TBL
					(x_return_status OUT NOCOPY VARCHAR2,
					 P_CVTV_TBL  OKS_CVT_PVT.oks_coverage_times_v_tbl_type) IS

		l_tabsize NUMBER := P_CVTV_TBL.COUNT;

Line: 146


		In_LAST_UPDATED_BY           OKC_DATATYPES.NumberTabTyp;

Line: 147


		In_LAST_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 148


		In_LAST_UPDATE_LOGIN           OKC_DATATYPES.NumberTabTyp;

Line: 152


		In_PROGRAM_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 162


		okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

Line: 183


		In_LAST_UPDATED_BY(j)    :=      P_CVTV_TBL(i).LAST_UPDATED_BY;

Line: 184


		In_LAST_UPDATE_DATE(j)    :=      P_CVTV_TBL(i).LAST_UPDATE_DATE;

Line: 185


		In_LAST_UPDATE_LOGIN(j)    :=      P_CVTV_TBL(i).LAST_UPDATE_LOGIN;

Line: 189


		In_PROGRAM_UPDATE_DATE(j)    :=      P_CVTV_TBL(i).PROGRAM_UPDATE_DATE;

Line: 196


INSERT      INTO Oks_Coverage_Times (
		ID,
		COV_TZE_LINE_ID,
		DNZ_CHR_ID,
		START_HOUR,
		START_MINUTE,
		END_HOUR,
		END_MINUTE,
		MONDAY_YN,
		TUESDAY_YN,
		WEDNESDAY_YN,
		THURSDAY_YN,
		FRIDAY_YN,
		SATURDAY_YN,
		SUNDAY_YN,
		CREATED_BY,
		CREATION_DATE,
		LAST_UPDATED_BY,
		LAST_UPDATE_DATE,
		LAST_UPDATE_LOGIN,
		SECURITY_GROUP_ID,
		PROGRAM_APPLICATION_ID,
		PROGRAM_ID,
		PROGRAM_UPDATE_DATE,
		REQUEST_ID,
		OBJECT_VERSION_NUMBER)
		VALUES (
		in_ID(i),
		in_COV_TZE_LINE_ID(i),
		in_DNZ_CHR_ID(i),
		in_START_HOUR(i),
		in_START_MINUTE(i),
		in_END_HOUR(i),
		in_END_MINUTE(i),
		in_MONDAY_YN(i),
		in_TUESDAY_YN(i),
		in_WEDNESDAY_YN(i),
		in_THURSDAY_YN(i),
		in_FRIDAY_YN(i),
		in_SATURDAY_YN(i),
		in_SUNDAY_YN(i),
		in_CREATED_BY(i),
		in_CREATION_DATE(i),
		in_LAST_UPDATED_BY(i),
		in_LAST_UPDATE_DATE(i),
		in_LAST_UPDATE_LOGIN(i),
		in_SECURITY_GROUP_ID(i),
		in_PROGRAM_APPLICATION_ID(i),
		in_PROGRAM_ID(i),
		in_PROGRAM_UPDATE_DATE(i),
		in_REQUEST_ID(i),
		in_Object_Version_Number(i));

Line: 250


				okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

Line: 256


			okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

Line: 269


END INSERT_ROW_UPG_CVTV_TBL;

Line: 271


PROCEDURE INSERT_ROW_UPG_ACMV_TBL
					(x_return_status OUT NOCOPY VARCHAR2,
					 P_ACMV_TBL  OKS_ACM_PVT.oks_action_times_v_tbl_type) IS

		l_tabsize NUMBER := P_ACMV_TBL.COUNT;

Line: 293


		In_PROGRAM_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 298


		In_LAST_UPDATED_BY           OKC_DATATYPES.NumberTabTyp;

Line: 299


		In_LAST_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 300


		In_LAST_UPDATE_LOGIN           OKC_DATATYPES.NumberTabTyp;

Line: 308


				okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

Line: 328


		In_PROGRAM_UPDATE_DATE(j)    :=      P_ACMV_TBL(i).PROGRAM_UPDATE_DATE;

Line: 333


		In_LAST_UPDATED_BY(j)    :=      P_ACMV_TBL(i).LAST_UPDATED_BY;

Line: 334


		In_LAST_UPDATE_DATE(j)    :=      P_ACMV_TBL(i).LAST_UPDATE_DATE;

Line: 335


		In_LAST_UPDATE_LOGIN(j)    :=      P_ACMV_TBL(i).LAST_UPDATE_LOGIN;

Line: 340


INSERT      INTO Oks_Action_Times (
		ID,
		COV_ACTION_TYPE_ID,
		CLE_ID,
		DNZ_CHR_ID,
		UOM_CODE,
		SUN_DURATION,
		MON_DURATION,
		TUE_DURATION,
		WED_DURATION,
		THU_DURATION,
		FRI_DURATION,
		SAT_DURATION,
		SECURITY_GROUP_ID,
		PROGRAM_APPLICATION_ID,
		PROGRAM_ID,
		PROGRAM_UPDATE_DATE,
		REQUEST_ID,
		CREATED_BY,
		OBJECT_VERSION_NUMBER,
		CREATION_DATE,
		LAST_UPDATED_BY,
		LAST_UPDATE_DATE,
		LAST_UPDATE_LOGIN)
		VALUES (
		in_ID(i),
		in_COV_ACTION_TYPE_ID(i),
		in_CLE_ID(i),
		in_DNZ_CHR_ID(i),
		in_UOM_CODE(i),
		in_SUN_DURATION(i),
		in_MON_DURATION(i),
		in_TUE_DURATION(i),
		in_WED_DURATION(i),
		in_THU_DURATION(i),
		in_FRI_DURATION(i),
		in_SAT_DURATION(i),
		in_SECURITY_GROUP_ID(i),
		in_PROGRAM_APPLICATION_ID(i),
		in_PROGRAM_ID(i),
		in_PROGRAM_UPDATE_DATE(i),
		in_REQUEST_ID(i),
		in_CREATED_BY(i),
		in_object_version_number(i),
		in_CREATION_DATE(i),
		in_LAST_UPDATED_BY(i),
		in_LAST_UPDATE_DATE(i),
		in_LAST_UPDATE_LOGIN(i));

Line: 390


				okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

Line: 397


			okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

Line: 410


END INSERT_ROW_UPG_ACMV_TBL;

Line: 413


PROCEDURE INSERT_ROW_UPG_ACTV_TBL
					(x_return_status OUT NOCOPY VARCHAR2,
					 P_ACTV_TBL  OKS_ACT_PVT.OksActionTimeTypesVTblType) IS

		l_tabsize NUMBER := P_ACTV_TBL.COUNT;

Line: 427


		In_PROGRAM_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 431


		In_LAST_UPDATED_BY           OKC_DATATYPES.NumberTabTyp;

Line: 432


		In_LAST_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 433


		In_LAST_UPDATE_LOGIN           OKC_DATATYPES.NumberTabTyp;

Line: 442


				okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

Line: 454


		In_PROGRAM_UPDATE_DATE(j)    :=      P_ACTV_TBL(i).PROGRAM_UPDATE_DATE;

Line: 458


		In_LAST_UPDATED_BY(j)    :=      P_ACTV_TBL(i).LAST_UPDATED_BY;

Line: 459


		In_LAST_UPDATE_DATE(j)    :=      P_ACTV_TBL(i).LAST_UPDATE_DATE;

Line: 460


		In_LAST_UPDATE_LOGIN(j)    :=      P_ACTV_TBL(i).LAST_UPDATE_LOGIN;

Line: 466


INSERT      INTO Oks_Action_Time_Types (
		ID,
		CLE_ID,
		DNZ_CHR_ID,
		ACTION_TYPE_CODE,
		SECURITY_GROUP_ID,
		PROGRAM_APPLICATION_ID,
		PROGRAM_ID,
		PROGRAM_UPDATE_DATE,
		REQUEST_ID,
		CREATED_BY,
		CREATION_DATE,
		LAST_UPDATED_BY,
		LAST_UPDATE_DATE,
		LAST_UPDATE_LOGIN,
		OBJECT_VERSION_NUMBER)
VALUES (
		in_ID(i),
		in_CLE_ID(i),
		in_DNZ_CHR_ID(i),
		in_ACTION_TYPE_CODE(i),
		in_SECURITY_GROUP_ID(i),
		in_PROGRAM_APPLICATION_ID(i),
		in_PROGRAM_ID(i),
		in_PROGRAM_UPDATE_DATE(i),
		in_REQUEST_ID(i),
		in_CREATED_BY(i),
		in_CREATION_DATE(i),
		in_LAST_UPDATED_BY(i),
		in_LAST_UPDATE_DATE(i),
		in_LAST_UPDATE_LOGIN(i),
		in_OBJECT_VERSION_NUMBER(i));

Line: 500


				 okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

Line: 507


			okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

Line: 521


END INSERT_ROW_UPG_ACTV_TBL;

Line: 524


PROCEDURE INSERT_ROW_UPG_KLNV_TBL
						(x_return_status OUT NOCOPY VARCHAR2,
						 P_KLNV_TBL  OKS_KLN_PVT.klnv_tbl_type) IS

		l_tabsize NUMBER := P_KLNV_TBL.COUNT;

Line: 621


		In_LAST_UPDATED_BY           OKC_DATATYPES.NumberTabTyp;

Line: 622


		In_LAST_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 623


		In_LAST_UPDATE_LOGIN           OKC_DATATYPES.NumberTabTyp;

Line: 631


				okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

Line: 725


      In_LAST_UPDATED_BY(j)    :=      P_KLNV_TBL(i).LAST_UPDATED_BY;

Line: 726


      In_LAST_UPDATE_DATE(j)    :=      P_KLNV_TBL(i).LAST_UPDATE_DATE;

Line: 727


      In_LAST_UPDATE_LOGIN(j)    :=      P_KLNV_TBL(i).LAST_UPDATE_LOGIN;

Line: 734


 INSERT    INTO Oks_K_Lines_B(
				ID,
				CLE_ID,
				DNZ_CHR_ID,
				DISCOUNT_LIST,
				ACCT_RULE_ID,
				PAYMENT_TYPE,
				CC_NO,
				CC_EXPIRY_DATE,
				CC_BANK_ACCT_ID,
				CC_AUTH_CODE,
				COMMITMENT_ID,
				LOCKED_PRICE_LIST_ID,
				USAGE_EST_YN,
				USAGE_EST_METHOD,
				USAGE_EST_START_DATE,
				TERMN_METHOD,
				UBT_AMOUNT,
				CREDIT_AMOUNT,
				SUPPRESSED_CREDIT,
				OVERRIDE_AMOUNT,
				CUST_PO_NUMBER_REQ_YN,
				CUST_PO_NUMBER,
				GRACE_DURATION,
				GRACE_PERIOD,
				INV_PRINT_FLAG,
				PRICE_UOM,
				TAX_AMOUNT,
				TAX_INCLUSIVE_YN,
				TAX_STATUS,
				TAX_CODE,
				TAX_EXEMPTION_ID,
				IB_TRANS_TYPE,
				IB_TRANS_DATE,
				PROD_PRICE,
				SERVICE_PRICE,
				CLVL_LIST_PRICE,
				CLVL_QUANTITY,
				CLVL_EXTENDED_AMT,
				CLVL_UOM_CODE,
				TOPLVL_OPERAND_CODE,
				TOPLVL_OPERAND_VAL,
				TOPLVL_QUANTITY,
				TOPLVL_UOM_CODE,
				TOPLVL_ADJ_PRICE,
				TOPLVL_PRICE_QTY,
				AVERAGING_INTERVAL,
				SETTLEMENT_INTERVAL,
				MINIMUM_QUANTITY,
				DEFAULT_QUANTITY,
				AMCV_FLAG,
				FIXED_QUANTITY,
				USAGE_DURATION,
				USAGE_PERIOD,
				LEVEL_YN,
				USAGE_TYPE,
				UOM_QUANTIFIED,
				BASE_READING,
				BILLING_SCHEDULE_TYPE,
				FULL_CREDIT,
				COVERAGE_TYPE,
				EXCEPTION_COV_ID,
				LIMIT_UOM_QUANTIFIED,
				DISCOUNT_AMOUNT,
				DISCOUNT_PERCENT,
				OFFSET_DURATION,
				OFFSET_PERIOD,
				INCIDENT_SEVERITY_ID,
				PDF_ID,
				WORK_THRU_YN,
				REACT_ACTIVE_YN,
				TRANSFER_OPTION,
				PROD_UPGRADE_YN,
				INHERITANCE_TYPE,
				PM_PROGRAM_ID,
				PM_CONF_REQ_YN,
				PM_SCH_EXISTS_YN,
				ALLOW_BT_DISCOUNT,
				APPLY_DEFAULT_TIMEZONE,
				SYNC_DATE_INSTALL,
				OBJECT_VERSION_NUMBER,
				SECURITY_GROUP_ID,
				REQUEST_ID,
				CREATED_BY,
				CREATION_DATE,
				LAST_UPDATED_BY,
				LAST_UPDATE_DATE,
				LAST_UPDATE_LOGIN)
				VALUES (
				in_ID(i),
				in_CLE_ID(i),
				in_DNZ_CHR_ID(i),
				in_DISCOUNT_LIST(i),
				in_ACCT_RULE_ID(i),
				in_PAYMENT_TYPE(i),
				in_CC_NO(i),
				in_CC_EXPIRY_DATE(i),
				in_CC_BANK_ACCT_ID(i),
				in_CC_AUTH_CODE(i),
				in_COMMITMENT_ID(i),
				in_LOCKED_PRICE_LIST_ID(i),
				in_USAGE_EST_YN(i),
				in_USAGE_EST_METHOD(i),
				in_USAGE_EST_START_DATE(i),
				in_TERMN_METHOD(i),
				in_UBT_AMOUNT(i),
				in_CREDIT_AMOUNT(i),
				in_SUPPRESSED_CREDIT(i),
				in_OVERRIDE_AMOUNT(i),
				in_CUST_PO_NUMBER_REQ_YN(i),
				in_CUST_PO_NUMBER(i),
				in_GRACE_DURATION(i),
				in_GRACE_PERIOD(i),
				in_INV_PRINT_FLAG(i),
				in_PRICE_UOM(i),
				in_TAX_AMOUNT(i),
				in_TAX_INCLUSIVE_YN(i),
				in_TAX_STATUS(i),
				in_TAX_CODE(i),
				in_TAX_EXEMPTION_ID(i),
				in_IB_TRANS_TYPE(i),
				in_IB_TRANS_DATE(i),
				in_PROD_PRICE(i),
				in_SERVICE_PRICE(i),
				in_CLVL_LIST_PRICE(i),
				in_CLVL_QUANTITY(i),
				in_CLVL_EXTENDED_AMT(i),
				in_CLVL_UOM_CODE(i),
				in_TOPLVL_OPERAND_CODE(i),
				in_TOPLVL_OPERAND_VAL(i),
				in_TOPLVL_QUANTITY(i),
				in_TOPLVL_UOM_CODE(i),
				in_TOPLVL_ADJ_PRICE(i),
				in_TOPLVL_PRICE_QTY(i),
				in_AVERAGING_INTERVAL(i),
				in_SETTLEMENT_INTERVAL(i),
				in_MINIMUM_QUANTITY(i),
				in_DEFAULT_QUANTITY(i),
				in_AMCV_FLAG(i),
				in_FIXED_QUANTITY(i),
				in_USAGE_DURATION(i),
				in_USAGE_PERIOD(i),
				in_LEVEL_YN(i),
				in_USAGE_TYPE(i),
				in_UOM_QUANTIFIED(i),
				in_BASE_READING(i),
				in_BILLING_SCHEDULE_TYPE(i),
				in_FULL_CREDIT(i),
				in_COVERAGE_TYPE(i),
				in_EXCEPTION_COV_ID(i),
				in_LIMIT_UOM_QUANTIFIED(i),
				in_DISCOUNT_AMOUNT(i),
				in_DISCOUNT_PERCENT(i),
				in_OFFSET_DURATION(i),
				in_OFFSET_PERIOD(i),
				in_INCIDENT_SEVERITY_ID(i),
				in_PDF_ID(i),
				in_WORK_THRU_YN(i),
				in_REACT_ACTIVE_YN(i),
				in_TRANSFER_OPTION(i),
				in_PROD_UPGRADE_YN(i),
				in_INHERITANCE_TYPE(i),
				in_PM_PROGRAM_ID(i),
				in_PM_CONF_REQ_YN(i),
				in_PM_SCH_EXISTS_YN(i),
				in_ALLOW_BT_DISCOUNT(i),
				in_APPLY_DEFAULT_TIMEZONE(i),
				in_SYNC_DATE_INSTALL(i),
				in_OBJECT_VERSION_NUMBER(i),
				in_SECURITY_GROUP_ID(i),
				in_REQUEST_ID(i),
				in_CREATED_BY(i),
				in_CREATION_DATE(i),
				in_LAST_UPDATED_BY(i),
				in_LAST_UPDATE_DATE(i),
				in_LAST_UPDATE_LOGIN(i));

Line: 914


 INSERT      INTO Oks_K_Lines_TL(
				id,
				language,
				source_lang,
				sfwt_flag,
				invoice_text,
				ib_trx_details,
				status_text,
				react_time_name,
				created_by,
				creation_date,
				last_updated_by,
				last_update_date,
				last_update_login)
		VALUES
			(	in_ID(i),
				OKC_UTIL.g_language_code(lang_i),
				l_source_lang,
				in_SFWT_FLAG(i),
				in_INVOICE_TEXT(i),
				in_IB_TRX_DETAILS(i),
				in_STATUS_TEXT(i),
				in_REACT_TIME_NAME(i),
				in_CREATED_BY(i),
				in_CREATION_DATE(i),
				in_LAST_UPDATED_BY(i),
				in_LAST_UPDATE_DATE(i),
				in_LAST_UPDATE_LOGIN(i));

Line: 945


       okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

Line: 951


       okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

Line: 962


END INSERT_ROW_UPG_KLNV_TBL;

Line: 964


PROCEDURE INSERT_ROW_UPG_bill_sch
            (x_return_status OUT NOCOPY VARCHAR2,
            p_oks_billrate_schedules_v_tbl  OKS_BRS_PVT.OksBillrateSchedulesVTblType) IS

l_tabsize NUMBER := p_oks_billrate_schedules_v_tbl.COUNT;

Line: 996


In_PROGRAM_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 1000


In_LAST_UPDATED_BY           OKC_DATATYPES.NumberTabTyp;

Line: 1001


In_LAST_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 1002


In_LAST_UPDATE_LOGIN           OKC_DATATYPES.NumberTabTyp;

Line: 1011


okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

Line: 1041


      In_PROGRAM_UPDATE_DATE(j)    :=      p_oks_billrate_schedules_v_tbl(i).PROGRAM_UPDATE_DATE;

Line: 1045


      In_LAST_UPDATED_BY(j)    :=      p_oks_billrate_schedules_v_tbl(i).LAST_UPDATED_BY;

Line: 1046


      In_LAST_UPDATE_DATE(j)    :=      p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_DATE;

Line: 1047


      In_LAST_UPDATE_LOGIN(j)    :=      p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_LOGIN;

Line: 1056


   INSERT      INTO OKS_BILLRATE_SCHEDULES (
ID,
CLE_ID,
BT_CLE_ID,
DNZ_CHR_ID,
START_HOUR,
START_MINUTE,
END_HOUR,
END_MINUTE,
MONDAY_FLAG,
TUESDAY_FLAG,
WEDNESDAY_FLAG,
THURSDAY_FLAG,
FRIDAY_FLAG,
SATURDAY_FLAG,
SUNDAY_FLAG,
OBJECT1_ID1,
OBJECT1_ID2,
JTOT_OBJECT1_CODE,
BILL_RATE_CODE,
FLAT_RATE,
UOM,
HOLIDAY_YN,
PERCENT_OVER_LIST_PRICE,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
SECURITY_GROUP_ID,
OBJECT_VERSION_NUMBER)
VALUES (
in_ID(i),
in_CLE_ID(i),
in_BT_CLE_ID(i),
in_DNZ_CHR_ID(i),
in_START_HOUR(i),
in_START_MINUTE(i),
in_END_HOUR(i),
in_END_MINUTE(i),
in_MONDAY_FLAG(i),
in_TUESDAY_FLAG(i),
in_WEDNESDAY_FLAG(i),
in_THURSDAY_FLAG(i),
in_FRIDAY_FLAG(i),
in_SATURDAY_FLAG(i),
in_SUNDAY_FLAG(i),
in_OBJECT1_ID1(i),
in_OBJECT1_ID2(i),
in_JTOT_OBJECT1_CODE(i),
in_BILL_RATE_CODE(i),
in_FLAT_RATE(i),
in_UOM(i),
in_HOLIDAY_YN(i),
in_PERCENT_OVER_LIST_PRICE(i),
in_PROGRAM_APPLICATION_ID(i),
in_PROGRAM_ID(i),
in_PROGRAM_UPDATE_DATE(i),
in_REQUEST_ID(i),
in_CREATED_BY(i),
in_CREATION_DATE(i),
in_LAST_UPDATED_BY(i),
in_LAST_UPDATE_DATE(i),
in_LAST_UPDATE_LOGIN(i),
in_SECURITY_GROUP_ID(i),
in_OBJECT_VERSION_NUMBER(i));

Line: 1128


       okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

Line: 1134


       okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

Line: 1145


END INSERT_ROW_UPG_bill_sch;

Line: 1147


PROCEDURE INSERT_ROW_UPG_KHRV_TBL
                        (x_return_status OUT NOCOPY VARCHAR2,
                         P_KHRV_TBL  OKS_KHR_PVT.khrv_tbl_type) IS


l_tabsize NUMBER := P_KHRV_TBL.COUNT;

Line: 1219


In_LAST_UPDATED_BY           OKC_DATATYPES.NumberTabTyp;

Line: 1220


In_LAST_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 1221


In_LAST_UPDATE_LOGIN           OKC_DATATYPES.NumberTabTyp;

Line: 1229


okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

Line: 1298


      In_LAST_UPDATED_BY(j)    :=      P_KHRV_TBL(i).LAST_UPDATED_BY;

Line: 1299


      In_LAST_UPDATE_DATE(j)    :=      P_KHRV_TBL(i).LAST_UPDATE_DATE;

Line: 1300


      In_LAST_UPDATE_LOGIN(j)    :=      P_KHRV_TBL(i).LAST_UPDATE_LOGIN;

Line: 1305


   INSERT      INTO OKS_K_HEADERS_B (
ID,
CHR_ID,
ACCT_RULE_ID,
PAYMENT_TYPE,
CC_NO,
CC_EXPIRY_DATE,
CC_BANK_ACCT_ID,
CC_AUTH_CODE,
GRACE_DURATION,
GRACE_PERIOD,
EST_REV_PERCENT,
EST_REV_DATE,
TAX_AMOUNT,
TAX_STATUS,
TAX_CODE,
TAX_EXEMPTION_ID,
BILLING_PROFILE_ID,
RENEWAL_STATUS,
ELECTRONIC_RENEWAL_FLAG,
QUOTE_TO_CONTACT_ID,
QUOTE_TO_SITE_ID,
QUOTE_TO_EMAIL_ID,
QUOTE_TO_PHONE_ID,
QUOTE_TO_FAX_ID,
RENEWAL_PO_REQUIRED,
RENEWAL_PO_NUMBER,
RENEWAL_PRICE_LIST,
RENEWAL_PRICING_TYPE,
RENEWAL_MARKUP_PERCENT,
RENEWAL_GRACE_DURATION,
RENEWAL_GRACE_PERIOD,
RENEWAL_EST_REV_PERCENT,
RENEWAL_EST_REV_DURATION,
RENEWAL_EST_REV_PERIOD,
RENEWAL_PRICE_LIST_USED,
RENEWAL_TYPE_USED,
RENEWAL_NOTIFICATION_TO,
RENEWAL_PO_USED,
RENEWAL_PRICING_TYPE_USED,
RENEWAL_MARKUP_PERCENT_USED,
REV_EST_PERCENT_USED,
REV_EST_DURATION_USED,
REV_EST_PERIOD_USED,
BILLING_PROFILE_USED,
ERN_FLAG_USED_YN,
EVN_THRESHOLD_AMT,
EVN_THRESHOLD_CUR,
ERN_THRESHOLD_AMT,
ERN_THRESHOLD_CUR,
RENEWAL_GRACE_DURATION_USED,
RENEWAL_GRACE_PERIOD_USED,
INV_TRX_TYPE,
INV_PRINT_PROFILE,
AR_INTERFACE_YN,
HOLD_BILLING,
SUMMARY_TRX_YN,
SERVICE_PO_NUMBER,
SERVICE_PO_REQUIRED,
BILLING_SCHEDULE_TYPE,
OBJECT_VERSION_NUMBER,
SECURITY_GROUP_ID,
REQUEST_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
COMMITMENT_ID)
VALUES (
in_ID(i),
in_CHR_ID(i),
in_ACCT_RULE_ID(i),
in_PAYMENT_TYPE(i),
in_CC_NO(i),
in_CC_EXPIRY_DATE(i),
in_CC_BANK_ACCT_ID(i),
in_CC_AUTH_CODE(i),
in_GRACE_DURATION(i),
in_GRACE_PERIOD(i),
in_EST_REV_PERCENT(i),
in_EST_REV_DATE(i),
in_TAX_AMOUNT(i),
in_TAX_STATUS(i),
in_TAX_CODE(i),
in_TAX_EXEMPTION_ID(i),
in_BILLING_PROFILE_ID(i),
in_RENEWAL_STATUS(i),
in_ELECTRONIC_RENEWAL_FLAG(i),
in_QUOTE_TO_CONTACT_ID(i),
in_QUOTE_TO_SITE_ID(i),
in_QUOTE_TO_EMAIL_ID(i),
in_QUOTE_TO_PHONE_ID(i),
in_QUOTE_TO_FAX_ID(i),
in_RENEWAL_PO_REQUIRED(i),
in_RENEWAL_PO_NUMBER(i),
in_RENEWAL_PRICE_LIST(i),
in_RENEWAL_PRICING_TYPE(i),
in_RENEWAL_MARKUP_PERCENT(i),
in_RENEWAL_GRACE_DURATION(i),
in_RENEWAL_GRACE_PERIOD(i),
in_RENEWAL_EST_REV_PERCENT(i),
in_RENEWAL_EST_REV_DURATION(i),
in_RENEWAL_EST_REV_PERIOD(i),
in_RENEWAL_PRICE_LIST_USED(i),
in_RENEWAL_TYPE_USED(i),
in_RENEWAL_NOTIFICATION_TO(i),
in_RENEWAL_PO_USED(i),
in_RENEWAL_PRICING_TYPE_USED(i),
in_RENEWAL_MARKUP_PERCENT_USED(i),
in_REV_EST_PERCENT_USED(i),
in_REV_EST_DURATION_USED(i),
in_REV_EST_PERIOD_USED(i),
in_BILLING_PROFILE_USED(i),
in_ERN_FLAG_USED_YN(i),
in_EVN_THRESHOLD_AMT(i),
in_EVN_THRESHOLD_CUR(i),
in_ERN_THRESHOLD_AMT(i),
in_ERN_THRESHOLD_CUR(i),
in_RENEWAL_GRACE_DURATION_USED(i),
in_RENEWAL_GRACE_PERIOD_USED(i),
in_INV_TRX_TYPE(i),
in_INV_PRINT_PROFILE(i),
in_AR_INTERFACE_YN(i),
in_HOLD_BILLING(i),
in_SUMMARY_TRX_YN(i),
in_SERVICE_PO_NUMBER(i),
in_SERVICE_PO_REQUIRED(i),
in_BILLING_SCHEDULE_TYPE(i),
in_OBJECT_VERSION_NUMBER(i),
in_SECURITY_GROUP_ID(i),
in_REQUEST_ID(i),
in_CREATED_BY(i),
in_CREATION_DATE(i),
in_LAST_UPDATED_BY(i),
in_LAST_UPDATE_DATE(i),
in_LAST_UPDATE_LOGIN(i),
in_COMMITMENT_ID(i));

Line: 1444


       okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

Line: 1450


       okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

Line: 1461


END INSERT_ROW_UPG_KHRV_TBL;

Line: 1464


PROCEDURE INSERT_ROW_UPG_sllv_tbl (x_return_status OUT NOCOPY VARCHAR2, p_sllv_tbl  OKS_SLL_PVT.sllv_tbl_type) IS
l_tabsize NUMBER := p_sllv_tbl.COUNT;

Line: 1490


In_LAST_UPDATED_BY           OKC_DATATYPES.NumberTabTyp;

Line: 1491


In_LAST_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 1492


In_LAST_UPDATE_LOGIN           OKC_DATATYPES.NumberTabTyp;

Line: 1500


okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

Line: 1527


      In_LAST_UPDATED_BY(j)    :=      p_sllv_tbl(i).LAST_UPDATED_BY;

Line: 1528


      In_LAST_UPDATE_DATE(j)    :=      p_sllv_tbl(i).LAST_UPDATE_DATE;

Line: 1529


      In_LAST_UPDATE_LOGIN(j)    :=      p_sllv_tbl(i).LAST_UPDATE_LOGIN;

Line: 1533


   INSERT      INTO OKS_STREAM_LEVELS_B (
ID,
CHR_ID,
CLE_ID,
DNZ_CHR_ID,
SEQUENCE_NO,
UOM_CODE,
START_DATE,
END_DATE,
LEVEL_PERIODS,
UOM_PER_PERIOD,
ADVANCE_PERIODS,
LEVEL_AMOUNT,
INVOICE_OFFSET_DAYS,
INTERFACE_OFFSET_DAYS,
COMMENTS,
DUE_ARR_YN,
AMOUNT,
LINES_DETAILED_YN,
OBJECT_VERSION_NUMBER,
SECURITY_GROUP_ID,
REQUEST_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN)
VALUES (
in_ID(i),
in_CHR_ID(i),
in_CLE_ID(i),
in_DNZ_CHR_ID(i),
in_SEQUENCE_NO(i),
in_UOM_CODE(i),
in_START_DATE(i),
in_END_DATE(i),
in_LEVEL_PERIODS(i),
in_UOM_PER_PERIOD(i),
in_ADVANCE_PERIODS(i),
in_LEVEL_AMOUNT(i),
in_INVOICE_OFFSET_DAYS(i),
in_INTERFACE_OFFSET_DAYS(i),
in_COMMENTS(i),
in_DUE_ARR_YN(i),
in_AMOUNT(i),
in_LINES_DETAILED_YN(i),
in_OBJECT_VERSION_NUMBER(i),
NULL,
in_REQUEST_ID(i),
in_CREATED_BY(i),
in_CREATION_DATE(i),
in_LAST_UPDATED_BY(i),
in_LAST_UPDATE_DATE(i),
in_LAST_UPDATE_LOGIN(i));

Line: 1588


       okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

Line: 1594


       okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

Line: 1605


END INSERT_ROW_UPG_sllv_tbl;

Line: 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
l_tabsize NUMBER := p_letv_tbl.COUNT;

Line: 1627


In_LAST_UPDATED_BY           OKC_DATATYPES.NumberTabTyp;

Line: 1628


In_LAST_UPDATE_DATE           OKC_DATATYPES.DateTabTyp;

Line: 1641


okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

Line: 1661


      In_LAST_UPDATED_BY(j)    :=      p_letv_tbl(i).LAST_UPDATED_BY;

Line: 1662


      In_LAST_UPDATE_DATE(j)    :=      p_letv_tbl(i).LAST_UPDATE_DATE;

Line: 1671


   INSERT      INTO OKS_LEVEL_ELEMENTS (
ID,
SEQUENCE_NUMBER,
DATE_START,
AMOUNT,
DATE_RECEIVABLE_GL,
DATE_REVENUE_RULE_START,
DATE_TRANSACTION,
DATE_DUE,
DATE_PRINT,
DATE_TO_INTERFACE,
DATE_COMPLETED,
OBJECT_VERSION_NUMBER,
RUL_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
SECURITY_GROUP_ID,
CLE_ID,
DNZ_CHR_ID,
DATE_END,
PARENT_CLE_ID)
VALUES (
in_ID(i),
in_SEQUENCE_NUMBER(i),
in_DATE_START(i),
in_AMOUNT(i),
in_DATE_RECEIVABLE_GL(i),
in_DATE_REVENUE_RULE_START(i),
in_DATE_TRANSACTION(i),
in_DATE_DUE(i),
in_DATE_PRINT(i),
in_DATE_TO_INTERFACE(i),
in_DATE_COMPLETED(i),
in_OBJECT_VERSION_NUMBER(i),
in_RUL_ID(i),
in_CREATED_BY(i),
in_CREATION_DATE(i),
in_LAST_UPDATED_BY(i),
in_LAST_UPDATE_DATE(i),
NULL,
in_CLE_ID(i),
in_DNZ_CHR_ID(i),
in_DATE_END(i),
in_PARENT_CLE_ID(i));

Line: 1718


       okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

Line: 1724


       okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

Line: 1736


END INSERT_ROW_UPG_letv_tbl;

Line: 1747


  PROCEDURE INSERT_BY_TBL_SUBHDR(
               x_return_status OUT NOCOPY VARCHAR2
              ,P_SUBHDR_TBL  OKS_SUBSCR_HDR_PVT.schv_tbl_type) IS

     l_in_id                             OKC_DATATYPES.NumberTabTyp;

Line: 1769


     l_in_last_updated_by                OKC_DATATYPES.NumberTabTyp;

Line: 1770


     l_in_last_update_date               OKC_DATATYPES.DateTabTyp;

Line: 1771


     l_in_last_update_login              OKC_DATATYPES.NumberTabTyp;

Line: 1786


       okc_debug.log('23400: Entered INSERT_ROW_SUBHDR_UPG', 2);

Line: 1810


      l_in_last_updated_by(j)                := P_SUBHDR_TBL(tbl_idx).last_updated_by;

Line: 1811


      l_in_last_update_date(j)               := P_SUBHDR_TBL(tbl_idx).last_update_date;

Line: 1812


      l_in_last_update_login(j)              := P_SUBHDR_TBL(tbl_idx).last_update_login;

Line: 1819


      INSERT INTO OKS_SUBSCR_HEADER_B(
        id,
        cle_id,
        dnz_chr_id,
        instance_id,
        subscription_type,
        item_type,
        media_type,
        status,
        frequency,
        fulfillment_channel,
        offset,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
        ,UPG_ORIG_SYSTEM_REF
        ,UPG_ORIG_SYSTEM_REF_ID)
      VALUES (
         l_in_id(x)
        ,l_in_cle_id(x)
        ,l_in_dnz_chr_id(x)
        ,l_in_instance_id(x)
        ,l_in_subscription_type(x)
        ,l_in_item_type(x)
        ,l_in_media_type(x)
        ,l_in_status(x)
        ,l_in_frequency(x)
        ,l_in_fulfillment_channel(x)
        ,l_in_offset(x)
        ,l_in_object_version_number(x)
        ,l_in_created_by(x)
        ,l_in_creation_date(x)
        ,l_in_last_updated_by(x)
        ,l_in_last_update_date(x)
        ,l_in_last_update_login(x)
        ,l_in_UPG_ORIG_SYSTEM_REF(x)
        ,l_in_UPG_ORIG_SYSTEM_REF_ID(x)        );

Line: 1863


        INSERT INTO OKS_SUBSCR_HEADER_TL(
          id,
          name,
          description,
          language,
          source_lang,
          sfwt_flag,
          comments,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login,
          SECURITY_GROUP_ID )
        VALUES (
          l_in_id(x)
          ,l_in_name(x)
          ,l_in_description(x)
          ,OKC_UTIL.g_language_code(lang_i)
          ,l_source_lang
          ,l_in_sfwt_flag(x)
          ,l_in_comments(x)
          ,l_in_created_by(x)
          ,l_in_creation_date(x)
          ,l_in_last_updated_by(x)
          ,l_in_last_update_date(x)
          ,l_in_last_update_login(x)
          ,null  );

Line: 1895


      okc_debug.log('23500: Exiting INSERT_ROW_SUBHDR_UPG', 2);

Line: 1902


        okc_debug.log('23600: Exiting INSERT_ROW_SUBHDR_UPG:OTHERS Exception', 2);

Line: 1916


  END INSERT_BY_TBL_SUBHDR;

Line: 1923


  PROCEDURE INSERT_BY_TBL_SUBPTNS(
               x_return_status OUT NOCOPY VARCHAR2
              ,P_SUBPTN_TBL  OKS_SUBSCR_PTRNS_PVT.scpv_tbl_type) IS

    l_in_id                             OKC_DATATYPES.NumberTabTyp;

Line: 1940


    l_in_last_updated_by                OKC_DATATYPES.NumberTabTyp;

Line: 1941


    l_in_last_update_date               OKC_DATATYPES.DateTabTyp;

Line: 1942


    l_in_last_update_login              OKC_DATATYPES.NumberTabTyp;

Line: 1955


       okc_debug.log('23400: Entered INSERT_BY_TBL_SUBPTNS', 2);

Line: 1973


      l_in_last_updated_by(j)         := P_SUBPTN_TBL(tbl_idx).last_updated_by;

Line: 1974


      l_in_last_update_date(j)        := P_SUBPTN_TBL(tbl_idx).last_update_date;

Line: 1975


      l_in_last_update_login(j)       := P_SUBPTN_TBL(tbl_idx).last_update_login;

Line: 1983


      INSERT INTO OKS_SUBSCR_PATTERNS(
        id,
        osh_id,
        dnz_chr_id,
        dnz_cle_id,
        seq_no,
        year,
        month,
        week,
        week_day,
        day,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_in_id(x)
       ,l_in_osh_id(x)
       ,l_in_dnz_chr_id(x)
       ,l_in_dnz_cle_id(x)
       ,l_in_seq_no(x)
       ,l_in_year(x)
       ,l_in_month(x)
       ,l_in_week(x)
       ,l_in_week_day(x)
       ,l_in_day(x)
       ,l_in_object_version_number(x)
       ,l_in_created_by(x)
       ,l_in_creation_date(x)
       ,l_in_last_updated_by(x)
       ,l_in_last_update_date(x)
       ,l_in_last_update_login(x)    );

Line: 2020


      okc_debug.log('23500: Exiting INSERT_BY_TBL_SUBPTNS', 2);

Line: 2027


        okc_debug.log('23600: Exiting INSERT_BY_TBL_SUBPTNS:OTHERS Exception', 2);

Line: 2041


  END INSERT_BY_TBL_SUBPTNS;

Line: 2052


  PROCEDURE INSERT_BY_TBL_SUBELMNTS(
               x_return_status OUT NOCOPY VARCHAR2
              ,P_SUBELMNTS_TBL  OKS_SUBSCR_ELEMS_PVT.scev_tbl_type) IS


    l_in_tabsize                 NUMBER := P_SUBELMNTS_TBL.COUNT;

Line: 2078


    l_in_last_updated_by                OKC_DATATYPES.NumberTabTyp;

Line: 2079


    l_in_last_update_date               OKC_DATATYPES.DateTabTyp;

Line: 2080


    l_in_last_update_login              OKC_DATATYPES.NumberTabTyp;

Line: 2091


      okc_debug.log('23400: Entered INSERT_BY_TBL_SUBELMNTS', 2);

Line: 2114


      l_in_last_updated_by(j)                :=  P_SUBELMNTS_TBL(tbl_idx).last_updated_by;

Line: 2115


      l_in_last_update_date(j)               :=  P_SUBELMNTS_TBL(tbl_idx).last_update_date;

Line: 2116


      l_in_last_update_login(j)              :=  P_SUBELMNTS_TBL(tbl_idx).last_update_login;

Line: 2123


      INSERT INTO OKS_SUBSCR_ELEMENTS(
        id,
        osh_id,
        dnz_chr_id,
        dnz_cle_id,
        linked_flag,
        seq_no,
        om_interface_date,
        amount,
        start_date,
        end_date,
        quantity,
        uom_code,
        order_header_id,
        order_line_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
    VALUES (
        l_in_id(x)
       ,l_in_osh_id(x)
       ,l_in_dnz_chr_id(x)
       ,l_in_dnz_cle_id(x)
       ,l_in_linked_flag(x)
       ,l_in_seq_no(x)
       ,l_in_om_interface_date(x)
       ,l_in_amount(x)
       ,l_in_start_date(x)
       ,l_in_end_date(x)
       ,l_in_quantity(x)
       ,l_in_uom_code(x)
       ,l_in_order_header_id(x)
       ,l_in_order_line_id(x)
       ,l_in_object_version_number(x)
       ,l_in_created_by(x)
       ,l_in_creation_date(x)
       ,l_in_last_updated_by(x)
       ,l_in_last_update_date(x)
       ,l_in_last_update_login(x));

Line: 2167


      okc_debug.log('23500: Exiting INSERT_BY_TBL_SUBELMNTS', 2);

Line: 2174


        okc_debug.log('23600: Exiting INSERT_BY_TBL_SUBELMNTS:OTHERS Exception', 2);

Line: 2189


  END INSERT_BY_TBL_SUBELMNTS;

Line: 2214


END OKS_Insert_Row_Upg;