37:
38: l_tgdv_rcn_tbl_in okc_time_pvt.tgdv_ext_tbl_Type;
39: x_tgdv_rcn_tbl_in okc_time_pvt.tgdv_ext_tbl_Type;
40:
41: l_rilv_tbl_in okc_ril_pvt.rilv_tbl_type;
42: x_rilv_tbl_in okc_ril_pvt.rilv_tbl_type;
43:
44: l_rilt_tbl_in okc_ril_pvt.rilv_tbl_type;
45: x_rilt_tbl_in okc_ril_pvt.rilv_tbl_type;
38: l_tgdv_rcn_tbl_in okc_time_pvt.tgdv_ext_tbl_Type;
39: x_tgdv_rcn_tbl_in okc_time_pvt.tgdv_ext_tbl_Type;
40:
41: l_rilv_tbl_in okc_ril_pvt.rilv_tbl_type;
42: x_rilv_tbl_in okc_ril_pvt.rilv_tbl_type;
43:
44: l_rilt_tbl_in okc_ril_pvt.rilv_tbl_type;
45: x_rilt_tbl_in okc_ril_pvt.rilv_tbl_type;
46:
40:
41: l_rilv_tbl_in okc_ril_pvt.rilv_tbl_type;
42: x_rilv_tbl_in okc_ril_pvt.rilv_tbl_type;
43:
44: l_rilt_tbl_in okc_ril_pvt.rilv_tbl_type;
45: x_rilt_tbl_in okc_ril_pvt.rilv_tbl_type;
46:
47: g_timezone_id NUMBER := nvl(FND_PROFILE.VALUE('CS_UPG_CONTRACTS_TIMEZONE'),47);
48:
41: l_rilv_tbl_in okc_ril_pvt.rilv_tbl_type;
42: x_rilv_tbl_in okc_ril_pvt.rilv_tbl_type;
43:
44: l_rilt_tbl_in okc_ril_pvt.rilv_tbl_type;
45: x_rilt_tbl_in okc_ril_pvt.rilv_tbl_type;
46:
47: g_timezone_id NUMBER := nvl(FND_PROFILE.VALUE('CS_UPG_CONTRACTS_TIMEZONE'),47);
48:
49: g_CREATION_DATE date := sysdate;