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 dependencies on OKS_BILLRATE_SCHEDULES

Line 966: p_oks_billrate_schedules_v_tbl OKS_BRS_PVT.OksBillrateSchedulesVTblType) IS

962: END INSERT_ROW_UPG_KLNV_TBL;
963:
964: PROCEDURE INSERT_ROW_UPG_bill_sch
965: (x_return_status OUT NOCOPY VARCHAR2,
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');

Line 968: l_tabsize NUMBER := p_oks_billrate_schedules_v_tbl.COUNT;

964: PROCEDURE INSERT_ROW_UPG_bill_sch
965: (x_return_status OUT NOCOPY VARCHAR2,
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;

Line 1005: i NUMBER := p_oks_billrate_schedules_v_tbl.FIRST;

1001: In_LAST_UPDATE_DATE OKC_DATATYPES.DateTabTyp;
1002: In_LAST_UPDATE_LOGIN OKC_DATATYPES.NumberTabTyp;
1003: In_SECURITY_GROUP_ID OKC_DATATYPES.NumberTabTyp;
1004: In_OBJECT_VERSION_NUMBER OKC_DATATYPES.NumberTabTyp;
1005: i NUMBER := p_oks_billrate_schedules_v_tbl.FIRST;
1006: j NUMBER := 0;
1007: BEGIN
1008: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1009: IF (l_debug = 'Y') THEN

Line 1016: In_ID(j) := p_oks_billrate_schedules_v_tbl(i).ID;

1012: END IF;
1013: WHILE i IS NOT NULL
1014: LOOP
1015: j := j +1;
1016: In_ID(j) := p_oks_billrate_schedules_v_tbl(i).ID;
1017: In_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).CLE_ID;
1018: In_BT_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).BT_CLE_ID;
1019: In_DNZ_CHR_ID(j) := p_oks_billrate_schedules_v_tbl(i).DNZ_CHR_ID;
1020: In_START_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).START_HOUR;

Line 1017: In_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).CLE_ID;

1013: WHILE i IS NOT NULL
1014: LOOP
1015: j := j +1;
1016: In_ID(j) := p_oks_billrate_schedules_v_tbl(i).ID;
1017: In_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).CLE_ID;
1018: In_BT_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).BT_CLE_ID;
1019: In_DNZ_CHR_ID(j) := p_oks_billrate_schedules_v_tbl(i).DNZ_CHR_ID;
1020: In_START_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).START_HOUR;
1021: In_START_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).START_MINUTE;

Line 1018: In_BT_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).BT_CLE_ID;

1014: LOOP
1015: j := j +1;
1016: In_ID(j) := p_oks_billrate_schedules_v_tbl(i).ID;
1017: In_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).CLE_ID;
1018: In_BT_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).BT_CLE_ID;
1019: In_DNZ_CHR_ID(j) := p_oks_billrate_schedules_v_tbl(i).DNZ_CHR_ID;
1020: In_START_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).START_HOUR;
1021: In_START_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).START_MINUTE;
1022: In_END_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).END_HOUR;

Line 1019: In_DNZ_CHR_ID(j) := p_oks_billrate_schedules_v_tbl(i).DNZ_CHR_ID;

1015: j := j +1;
1016: In_ID(j) := p_oks_billrate_schedules_v_tbl(i).ID;
1017: In_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).CLE_ID;
1018: In_BT_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).BT_CLE_ID;
1019: In_DNZ_CHR_ID(j) := p_oks_billrate_schedules_v_tbl(i).DNZ_CHR_ID;
1020: In_START_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).START_HOUR;
1021: In_START_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).START_MINUTE;
1022: In_END_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).END_HOUR;
1023: In_END_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).END_MINUTE;

Line 1020: In_START_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).START_HOUR;

1016: In_ID(j) := p_oks_billrate_schedules_v_tbl(i).ID;
1017: In_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).CLE_ID;
1018: In_BT_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).BT_CLE_ID;
1019: In_DNZ_CHR_ID(j) := p_oks_billrate_schedules_v_tbl(i).DNZ_CHR_ID;
1020: In_START_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).START_HOUR;
1021: In_START_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).START_MINUTE;
1022: In_END_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).END_HOUR;
1023: In_END_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).END_MINUTE;
1024: In_MONDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).MONDAY_FLAG;

Line 1021: In_START_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).START_MINUTE;

1017: In_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).CLE_ID;
1018: In_BT_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).BT_CLE_ID;
1019: In_DNZ_CHR_ID(j) := p_oks_billrate_schedules_v_tbl(i).DNZ_CHR_ID;
1020: In_START_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).START_HOUR;
1021: In_START_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).START_MINUTE;
1022: In_END_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).END_HOUR;
1023: In_END_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).END_MINUTE;
1024: In_MONDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).MONDAY_FLAG;
1025: In_TUESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).TUESDAY_FLAG;

Line 1022: In_END_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).END_HOUR;

1018: In_BT_CLE_ID(j) := p_oks_billrate_schedules_v_tbl(i).BT_CLE_ID;
1019: In_DNZ_CHR_ID(j) := p_oks_billrate_schedules_v_tbl(i).DNZ_CHR_ID;
1020: In_START_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).START_HOUR;
1021: In_START_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).START_MINUTE;
1022: In_END_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).END_HOUR;
1023: In_END_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).END_MINUTE;
1024: In_MONDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).MONDAY_FLAG;
1025: In_TUESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).TUESDAY_FLAG;
1026: In_WEDNESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).WEDNESDAY_FLAG;

Line 1023: In_END_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).END_MINUTE;

1019: In_DNZ_CHR_ID(j) := p_oks_billrate_schedules_v_tbl(i).DNZ_CHR_ID;
1020: In_START_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).START_HOUR;
1021: In_START_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).START_MINUTE;
1022: In_END_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).END_HOUR;
1023: In_END_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).END_MINUTE;
1024: In_MONDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).MONDAY_FLAG;
1025: In_TUESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).TUESDAY_FLAG;
1026: In_WEDNESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).WEDNESDAY_FLAG;
1027: In_THURSDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).THURSDAY_FLAG;

Line 1024: In_MONDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).MONDAY_FLAG;

1020: In_START_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).START_HOUR;
1021: In_START_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).START_MINUTE;
1022: In_END_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).END_HOUR;
1023: In_END_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).END_MINUTE;
1024: In_MONDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).MONDAY_FLAG;
1025: In_TUESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).TUESDAY_FLAG;
1026: In_WEDNESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).WEDNESDAY_FLAG;
1027: In_THURSDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).THURSDAY_FLAG;
1028: In_FRIDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).FRIDAY_FLAG;

Line 1025: In_TUESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).TUESDAY_FLAG;

1021: In_START_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).START_MINUTE;
1022: In_END_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).END_HOUR;
1023: In_END_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).END_MINUTE;
1024: In_MONDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).MONDAY_FLAG;
1025: In_TUESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).TUESDAY_FLAG;
1026: In_WEDNESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).WEDNESDAY_FLAG;
1027: In_THURSDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).THURSDAY_FLAG;
1028: In_FRIDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).FRIDAY_FLAG;
1029: In_SATURDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SATURDAY_FLAG;

Line 1026: In_WEDNESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).WEDNESDAY_FLAG;

1022: In_END_HOUR(j) := p_oks_billrate_schedules_v_tbl(i).END_HOUR;
1023: In_END_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).END_MINUTE;
1024: In_MONDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).MONDAY_FLAG;
1025: In_TUESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).TUESDAY_FLAG;
1026: In_WEDNESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).WEDNESDAY_FLAG;
1027: In_THURSDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).THURSDAY_FLAG;
1028: In_FRIDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).FRIDAY_FLAG;
1029: In_SATURDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SATURDAY_FLAG;
1030: In_SUNDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SUNDAY_FLAG;

Line 1027: In_THURSDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).THURSDAY_FLAG;

1023: In_END_MINUTE(j) := p_oks_billrate_schedules_v_tbl(i).END_MINUTE;
1024: In_MONDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).MONDAY_FLAG;
1025: In_TUESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).TUESDAY_FLAG;
1026: In_WEDNESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).WEDNESDAY_FLAG;
1027: In_THURSDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).THURSDAY_FLAG;
1028: In_FRIDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).FRIDAY_FLAG;
1029: In_SATURDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SATURDAY_FLAG;
1030: In_SUNDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SUNDAY_FLAG;
1031: In_OBJECT1_ID1(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID1;

Line 1028: In_FRIDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).FRIDAY_FLAG;

1024: In_MONDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).MONDAY_FLAG;
1025: In_TUESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).TUESDAY_FLAG;
1026: In_WEDNESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).WEDNESDAY_FLAG;
1027: In_THURSDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).THURSDAY_FLAG;
1028: In_FRIDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).FRIDAY_FLAG;
1029: In_SATURDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SATURDAY_FLAG;
1030: In_SUNDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SUNDAY_FLAG;
1031: In_OBJECT1_ID1(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID1;
1032: In_OBJECT1_ID2(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID2;

Line 1029: In_SATURDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SATURDAY_FLAG;

1025: In_TUESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).TUESDAY_FLAG;
1026: In_WEDNESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).WEDNESDAY_FLAG;
1027: In_THURSDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).THURSDAY_FLAG;
1028: In_FRIDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).FRIDAY_FLAG;
1029: In_SATURDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SATURDAY_FLAG;
1030: In_SUNDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SUNDAY_FLAG;
1031: In_OBJECT1_ID1(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID1;
1032: In_OBJECT1_ID2(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID2;
1033: In_JTOT_OBJECT1_CODE(j) := p_oks_billrate_schedules_v_tbl(i).JTOT_OBJECT1_CODE;

Line 1030: In_SUNDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SUNDAY_FLAG;

1026: In_WEDNESDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).WEDNESDAY_FLAG;
1027: In_THURSDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).THURSDAY_FLAG;
1028: In_FRIDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).FRIDAY_FLAG;
1029: In_SATURDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SATURDAY_FLAG;
1030: In_SUNDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SUNDAY_FLAG;
1031: In_OBJECT1_ID1(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID1;
1032: In_OBJECT1_ID2(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID2;
1033: In_JTOT_OBJECT1_CODE(j) := p_oks_billrate_schedules_v_tbl(i).JTOT_OBJECT1_CODE;
1034: In_BILL_RATE_CODE(j) := p_oks_billrate_schedules_v_tbl(i).BILL_RATE_CODE;

Line 1031: In_OBJECT1_ID1(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID1;

1027: In_THURSDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).THURSDAY_FLAG;
1028: In_FRIDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).FRIDAY_FLAG;
1029: In_SATURDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SATURDAY_FLAG;
1030: In_SUNDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SUNDAY_FLAG;
1031: In_OBJECT1_ID1(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID1;
1032: In_OBJECT1_ID2(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID2;
1033: In_JTOT_OBJECT1_CODE(j) := p_oks_billrate_schedules_v_tbl(i).JTOT_OBJECT1_CODE;
1034: In_BILL_RATE_CODE(j) := p_oks_billrate_schedules_v_tbl(i).BILL_RATE_CODE;
1035: In_FLAT_RATE(j) := p_oks_billrate_schedules_v_tbl(i).FLAT_RATE;

Line 1032: In_OBJECT1_ID2(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID2;

1028: In_FRIDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).FRIDAY_FLAG;
1029: In_SATURDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SATURDAY_FLAG;
1030: In_SUNDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SUNDAY_FLAG;
1031: In_OBJECT1_ID1(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID1;
1032: In_OBJECT1_ID2(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID2;
1033: In_JTOT_OBJECT1_CODE(j) := p_oks_billrate_schedules_v_tbl(i).JTOT_OBJECT1_CODE;
1034: In_BILL_RATE_CODE(j) := p_oks_billrate_schedules_v_tbl(i).BILL_RATE_CODE;
1035: In_FLAT_RATE(j) := p_oks_billrate_schedules_v_tbl(i).FLAT_RATE;
1036: In_UOM(j) := p_oks_billrate_schedules_v_tbl(i).UOM;

Line 1033: In_JTOT_OBJECT1_CODE(j) := p_oks_billrate_schedules_v_tbl(i).JTOT_OBJECT1_CODE;

1029: In_SATURDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SATURDAY_FLAG;
1030: In_SUNDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SUNDAY_FLAG;
1031: In_OBJECT1_ID1(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID1;
1032: In_OBJECT1_ID2(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID2;
1033: In_JTOT_OBJECT1_CODE(j) := p_oks_billrate_schedules_v_tbl(i).JTOT_OBJECT1_CODE;
1034: In_BILL_RATE_CODE(j) := p_oks_billrate_schedules_v_tbl(i).BILL_RATE_CODE;
1035: In_FLAT_RATE(j) := p_oks_billrate_schedules_v_tbl(i).FLAT_RATE;
1036: In_UOM(j) := p_oks_billrate_schedules_v_tbl(i).UOM;
1037: In_HOLIDAY_YN(j) := p_oks_billrate_schedules_v_tbl(i).HOLIDAY_YN;

Line 1034: In_BILL_RATE_CODE(j) := p_oks_billrate_schedules_v_tbl(i).BILL_RATE_CODE;

1030: In_SUNDAY_FLAG(j) := p_oks_billrate_schedules_v_tbl(i).SUNDAY_FLAG;
1031: In_OBJECT1_ID1(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID1;
1032: In_OBJECT1_ID2(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID2;
1033: In_JTOT_OBJECT1_CODE(j) := p_oks_billrate_schedules_v_tbl(i).JTOT_OBJECT1_CODE;
1034: In_BILL_RATE_CODE(j) := p_oks_billrate_schedules_v_tbl(i).BILL_RATE_CODE;
1035: In_FLAT_RATE(j) := p_oks_billrate_schedules_v_tbl(i).FLAT_RATE;
1036: In_UOM(j) := p_oks_billrate_schedules_v_tbl(i).UOM;
1037: In_HOLIDAY_YN(j) := p_oks_billrate_schedules_v_tbl(i).HOLIDAY_YN;
1038: In_PERCENT_OVER_LIST_PRICE(j) := p_oks_billrate_schedules_v_tbl(i).PERCENT_OVER_LIST_PRICE;

Line 1035: In_FLAT_RATE(j) := p_oks_billrate_schedules_v_tbl(i).FLAT_RATE;

1031: In_OBJECT1_ID1(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID1;
1032: In_OBJECT1_ID2(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID2;
1033: In_JTOT_OBJECT1_CODE(j) := p_oks_billrate_schedules_v_tbl(i).JTOT_OBJECT1_CODE;
1034: In_BILL_RATE_CODE(j) := p_oks_billrate_schedules_v_tbl(i).BILL_RATE_CODE;
1035: In_FLAT_RATE(j) := p_oks_billrate_schedules_v_tbl(i).FLAT_RATE;
1036: In_UOM(j) := p_oks_billrate_schedules_v_tbl(i).UOM;
1037: In_HOLIDAY_YN(j) := p_oks_billrate_schedules_v_tbl(i).HOLIDAY_YN;
1038: In_PERCENT_OVER_LIST_PRICE(j) := p_oks_billrate_schedules_v_tbl(i).PERCENT_OVER_LIST_PRICE;
1039: In_PROGRAM_APPLICATION_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_APPLICATION_ID;

Line 1036: In_UOM(j) := p_oks_billrate_schedules_v_tbl(i).UOM;

1032: In_OBJECT1_ID2(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT1_ID2;
1033: In_JTOT_OBJECT1_CODE(j) := p_oks_billrate_schedules_v_tbl(i).JTOT_OBJECT1_CODE;
1034: In_BILL_RATE_CODE(j) := p_oks_billrate_schedules_v_tbl(i).BILL_RATE_CODE;
1035: In_FLAT_RATE(j) := p_oks_billrate_schedules_v_tbl(i).FLAT_RATE;
1036: In_UOM(j) := p_oks_billrate_schedules_v_tbl(i).UOM;
1037: In_HOLIDAY_YN(j) := p_oks_billrate_schedules_v_tbl(i).HOLIDAY_YN;
1038: In_PERCENT_OVER_LIST_PRICE(j) := p_oks_billrate_schedules_v_tbl(i).PERCENT_OVER_LIST_PRICE;
1039: In_PROGRAM_APPLICATION_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_APPLICATION_ID;
1040: In_PROGRAM_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_ID;

Line 1037: In_HOLIDAY_YN(j) := p_oks_billrate_schedules_v_tbl(i).HOLIDAY_YN;

1033: In_JTOT_OBJECT1_CODE(j) := p_oks_billrate_schedules_v_tbl(i).JTOT_OBJECT1_CODE;
1034: In_BILL_RATE_CODE(j) := p_oks_billrate_schedules_v_tbl(i).BILL_RATE_CODE;
1035: In_FLAT_RATE(j) := p_oks_billrate_schedules_v_tbl(i).FLAT_RATE;
1036: In_UOM(j) := p_oks_billrate_schedules_v_tbl(i).UOM;
1037: In_HOLIDAY_YN(j) := p_oks_billrate_schedules_v_tbl(i).HOLIDAY_YN;
1038: In_PERCENT_OVER_LIST_PRICE(j) := p_oks_billrate_schedules_v_tbl(i).PERCENT_OVER_LIST_PRICE;
1039: In_PROGRAM_APPLICATION_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_APPLICATION_ID;
1040: In_PROGRAM_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_ID;
1041: In_PROGRAM_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_UPDATE_DATE;

Line 1038: In_PERCENT_OVER_LIST_PRICE(j) := p_oks_billrate_schedules_v_tbl(i).PERCENT_OVER_LIST_PRICE;

1034: In_BILL_RATE_CODE(j) := p_oks_billrate_schedules_v_tbl(i).BILL_RATE_CODE;
1035: In_FLAT_RATE(j) := p_oks_billrate_schedules_v_tbl(i).FLAT_RATE;
1036: In_UOM(j) := p_oks_billrate_schedules_v_tbl(i).UOM;
1037: In_HOLIDAY_YN(j) := p_oks_billrate_schedules_v_tbl(i).HOLIDAY_YN;
1038: In_PERCENT_OVER_LIST_PRICE(j) := p_oks_billrate_schedules_v_tbl(i).PERCENT_OVER_LIST_PRICE;
1039: In_PROGRAM_APPLICATION_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_APPLICATION_ID;
1040: In_PROGRAM_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_ID;
1041: In_PROGRAM_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_UPDATE_DATE;
1042: In_REQUEST_ID(j) := p_oks_billrate_schedules_v_tbl(i).REQUEST_ID;

Line 1039: In_PROGRAM_APPLICATION_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_APPLICATION_ID;

1035: In_FLAT_RATE(j) := p_oks_billrate_schedules_v_tbl(i).FLAT_RATE;
1036: In_UOM(j) := p_oks_billrate_schedules_v_tbl(i).UOM;
1037: In_HOLIDAY_YN(j) := p_oks_billrate_schedules_v_tbl(i).HOLIDAY_YN;
1038: In_PERCENT_OVER_LIST_PRICE(j) := p_oks_billrate_schedules_v_tbl(i).PERCENT_OVER_LIST_PRICE;
1039: In_PROGRAM_APPLICATION_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_APPLICATION_ID;
1040: In_PROGRAM_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_ID;
1041: In_PROGRAM_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_UPDATE_DATE;
1042: In_REQUEST_ID(j) := p_oks_billrate_schedules_v_tbl(i).REQUEST_ID;
1043: In_CREATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).CREATED_BY;

Line 1040: In_PROGRAM_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_ID;

1036: In_UOM(j) := p_oks_billrate_schedules_v_tbl(i).UOM;
1037: In_HOLIDAY_YN(j) := p_oks_billrate_schedules_v_tbl(i).HOLIDAY_YN;
1038: In_PERCENT_OVER_LIST_PRICE(j) := p_oks_billrate_schedules_v_tbl(i).PERCENT_OVER_LIST_PRICE;
1039: In_PROGRAM_APPLICATION_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_APPLICATION_ID;
1040: In_PROGRAM_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_ID;
1041: In_PROGRAM_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_UPDATE_DATE;
1042: In_REQUEST_ID(j) := p_oks_billrate_schedules_v_tbl(i).REQUEST_ID;
1043: In_CREATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).CREATED_BY;
1044: In_CREATION_DATE(j) := p_oks_billrate_schedules_v_tbl(i).CREATION_DATE;

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

1037: In_HOLIDAY_YN(j) := p_oks_billrate_schedules_v_tbl(i).HOLIDAY_YN;
1038: In_PERCENT_OVER_LIST_PRICE(j) := p_oks_billrate_schedules_v_tbl(i).PERCENT_OVER_LIST_PRICE;
1039: In_PROGRAM_APPLICATION_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_APPLICATION_ID;
1040: In_PROGRAM_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_ID;
1041: In_PROGRAM_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_UPDATE_DATE;
1042: In_REQUEST_ID(j) := p_oks_billrate_schedules_v_tbl(i).REQUEST_ID;
1043: In_CREATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).CREATED_BY;
1044: In_CREATION_DATE(j) := p_oks_billrate_schedules_v_tbl(i).CREATION_DATE;
1045: In_LAST_UPDATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATED_BY;

Line 1042: In_REQUEST_ID(j) := p_oks_billrate_schedules_v_tbl(i).REQUEST_ID;

1038: In_PERCENT_OVER_LIST_PRICE(j) := p_oks_billrate_schedules_v_tbl(i).PERCENT_OVER_LIST_PRICE;
1039: In_PROGRAM_APPLICATION_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_APPLICATION_ID;
1040: In_PROGRAM_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_ID;
1041: In_PROGRAM_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_UPDATE_DATE;
1042: In_REQUEST_ID(j) := p_oks_billrate_schedules_v_tbl(i).REQUEST_ID;
1043: In_CREATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).CREATED_BY;
1044: In_CREATION_DATE(j) := p_oks_billrate_schedules_v_tbl(i).CREATION_DATE;
1045: In_LAST_UPDATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATED_BY;
1046: In_LAST_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_DATE;

Line 1043: In_CREATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).CREATED_BY;

1039: In_PROGRAM_APPLICATION_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_APPLICATION_ID;
1040: In_PROGRAM_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_ID;
1041: In_PROGRAM_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_UPDATE_DATE;
1042: In_REQUEST_ID(j) := p_oks_billrate_schedules_v_tbl(i).REQUEST_ID;
1043: In_CREATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).CREATED_BY;
1044: In_CREATION_DATE(j) := p_oks_billrate_schedules_v_tbl(i).CREATION_DATE;
1045: In_LAST_UPDATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATED_BY;
1046: In_LAST_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_DATE;
1047: In_LAST_UPDATE_LOGIN(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_LOGIN;

Line 1044: In_CREATION_DATE(j) := p_oks_billrate_schedules_v_tbl(i).CREATION_DATE;

1040: In_PROGRAM_ID(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_ID;
1041: In_PROGRAM_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_UPDATE_DATE;
1042: In_REQUEST_ID(j) := p_oks_billrate_schedules_v_tbl(i).REQUEST_ID;
1043: In_CREATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).CREATED_BY;
1044: In_CREATION_DATE(j) := p_oks_billrate_schedules_v_tbl(i).CREATION_DATE;
1045: In_LAST_UPDATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATED_BY;
1046: In_LAST_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_DATE;
1047: In_LAST_UPDATE_LOGIN(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_LOGIN;
1048: In_SECURITY_GROUP_ID(j) := p_oks_billrate_schedules_v_tbl(i).SECURITY_GROUP_ID;

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

1041: In_PROGRAM_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).PROGRAM_UPDATE_DATE;
1042: In_REQUEST_ID(j) := p_oks_billrate_schedules_v_tbl(i).REQUEST_ID;
1043: In_CREATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).CREATED_BY;
1044: In_CREATION_DATE(j) := p_oks_billrate_schedules_v_tbl(i).CREATION_DATE;
1045: In_LAST_UPDATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATED_BY;
1046: In_LAST_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_DATE;
1047: In_LAST_UPDATE_LOGIN(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_LOGIN;
1048: In_SECURITY_GROUP_ID(j) := p_oks_billrate_schedules_v_tbl(i).SECURITY_GROUP_ID;
1049: In_OBJECT_VERSION_NUMBER(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT_VERSION_NUMBER;

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

1042: In_REQUEST_ID(j) := p_oks_billrate_schedules_v_tbl(i).REQUEST_ID;
1043: In_CREATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).CREATED_BY;
1044: In_CREATION_DATE(j) := p_oks_billrate_schedules_v_tbl(i).CREATION_DATE;
1045: In_LAST_UPDATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATED_BY;
1046: In_LAST_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_DATE;
1047: In_LAST_UPDATE_LOGIN(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_LOGIN;
1048: In_SECURITY_GROUP_ID(j) := p_oks_billrate_schedules_v_tbl(i).SECURITY_GROUP_ID;
1049: In_OBJECT_VERSION_NUMBER(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT_VERSION_NUMBER;
1050:

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

1043: In_CREATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).CREATED_BY;
1044: In_CREATION_DATE(j) := p_oks_billrate_schedules_v_tbl(i).CREATION_DATE;
1045: In_LAST_UPDATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATED_BY;
1046: In_LAST_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_DATE;
1047: In_LAST_UPDATE_LOGIN(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_LOGIN;
1048: In_SECURITY_GROUP_ID(j) := p_oks_billrate_schedules_v_tbl(i).SECURITY_GROUP_ID;
1049: In_OBJECT_VERSION_NUMBER(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT_VERSION_NUMBER;
1050:
1051: i :=p_oks_billrate_schedules_v_tbl.NEXT(i);

Line 1048: In_SECURITY_GROUP_ID(j) := p_oks_billrate_schedules_v_tbl(i).SECURITY_GROUP_ID;

1044: In_CREATION_DATE(j) := p_oks_billrate_schedules_v_tbl(i).CREATION_DATE;
1045: In_LAST_UPDATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATED_BY;
1046: In_LAST_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_DATE;
1047: In_LAST_UPDATE_LOGIN(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_LOGIN;
1048: In_SECURITY_GROUP_ID(j) := p_oks_billrate_schedules_v_tbl(i).SECURITY_GROUP_ID;
1049: In_OBJECT_VERSION_NUMBER(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT_VERSION_NUMBER;
1050:
1051: i :=p_oks_billrate_schedules_v_tbl.NEXT(i);
1052:

Line 1049: In_OBJECT_VERSION_NUMBER(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT_VERSION_NUMBER;

1045: In_LAST_UPDATED_BY(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATED_BY;
1046: In_LAST_UPDATE_DATE(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_DATE;
1047: In_LAST_UPDATE_LOGIN(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_LOGIN;
1048: In_SECURITY_GROUP_ID(j) := p_oks_billrate_schedules_v_tbl(i).SECURITY_GROUP_ID;
1049: In_OBJECT_VERSION_NUMBER(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT_VERSION_NUMBER;
1050:
1051: i :=p_oks_billrate_schedules_v_tbl.NEXT(i);
1052:
1053: END LOOP;

Line 1051: i :=p_oks_billrate_schedules_v_tbl.NEXT(i);

1047: In_LAST_UPDATE_LOGIN(j) := p_oks_billrate_schedules_v_tbl(i).LAST_UPDATE_LOGIN;
1048: In_SECURITY_GROUP_ID(j) := p_oks_billrate_schedules_v_tbl(i).SECURITY_GROUP_ID;
1049: In_OBJECT_VERSION_NUMBER(j) := p_oks_billrate_schedules_v_tbl(i).OBJECT_VERSION_NUMBER;
1050:
1051: i :=p_oks_billrate_schedules_v_tbl.NEXT(i);
1052:
1053: END LOOP;
1054:
1055: FORALL i in 1..l_tabsize

Line 1056: INSERT INTO OKS_BILLRATE_SCHEDULES (

1052:
1053: END LOOP;
1054:
1055: FORALL i in 1..l_tabsize
1056: INSERT INTO OKS_BILLRATE_SCHEDULES (
1057: ID,
1058: CLE_ID,
1059: BT_CLE_ID,
1060: DNZ_CHR_ID,