DBA Data[Home] [Help]

APPS.OKL_LRV_PVT dependencies on STANDARD

Line 701: ,standard_rate

697: ,attribute12
698: ,attribute13
699: ,attribute14
700: ,attribute15
701: ,standard_rate
702: FROM okl_fe_rate_set_versions_v
703: WHERE rate_set_version_id = p_id;
704: l_lrvv_pk lrvv_pk_csr%ROWTYPE;
705: l_lrvv_rec okl_lrvv_rec;

Line 751: ,l_lrvv_rec.standard_rate;

747: ,l_lrvv_rec.attribute12
748: ,l_lrvv_rec.attribute13
749: ,l_lrvv_rec.attribute14
750: ,l_lrvv_rec.attribute15
751: ,l_lrvv_rec.standard_rate;
752: x_no_data_found := lrvv_pk_csr%NOTFOUND;
753: CLOSE lrvv_pk_csr;
754: RETURN(l_lrvv_rec);
755: END get_rec;

Line 917: IF (l_lrvv_rec.standard_rate = okl_api.g_miss_num) THEN

913: IF (l_lrvv_rec.attribute15 = okl_api.g_miss_char) THEN
914: l_lrvv_rec.attribute15 := NULL;
915: END IF;
916:
917: IF (l_lrvv_rec.standard_rate = okl_api.g_miss_num) THEN
918: l_lrvv_rec.standard_rate := NULL;
919: END IF;
920: RETURN(l_lrvv_rec);
921: END null_out_defaults;

Line 918: l_lrvv_rec.standard_rate := NULL;

914: l_lrvv_rec.attribute15 := NULL;
915: END IF;
916:
917: IF (l_lrvv_rec.standard_rate = okl_api.g_miss_num) THEN
918: l_lrvv_rec.standard_rate := NULL;
919: END IF;
920: RETURN(l_lrvv_rec);
921: END null_out_defaults;
922:

Line 1298: ,standard_rate)

1294: ,attribute12
1295: ,attribute13
1296: ,attribute14
1297: ,attribute15
1298: ,standard_rate)
1299: VALUES (l_def_lrvv_rec.rate_set_version_id
1300: ,l_def_lrvv_rec.object_version_number
1301: ,l_def_lrvv_rec.arrears_yn
1302: ,l_def_lrvv_rec.effective_from_date

Line 1336: ,l_def_lrvv_rec.standard_rate);

1332: ,l_def_lrvv_rec.attribute12
1333: ,l_def_lrvv_rec.attribute13
1334: ,l_def_lrvv_rec.attribute14
1335: ,l_def_lrvv_rec.attribute15
1336: ,l_def_lrvv_rec.standard_rate);
1337:
1338: --Set OUT Values
1339:
1340: x_lrvv_rec := l_def_lrvv_rec;

Line 1634: IF (x_lrvv_rec.standard_rate IS NULL) THEN

1630: IF (x_lrvv_rec.attribute15 IS NULL) THEN
1631: x_lrvv_rec.attribute15 := l_lrvv_rec.attribute15;
1632: END IF;
1633:
1634: IF (x_lrvv_rec.standard_rate IS NULL) THEN
1635: x_lrvv_rec.standard_rate := l_lrvv_rec.standard_rate;
1636: END IF;
1637: RETURN(l_return_status);
1638: END populate_new_record;

Line 1635: x_lrvv_rec.standard_rate := l_lrvv_rec.standard_rate;

1631: x_lrvv_rec.attribute15 := l_lrvv_rec.attribute15;
1632: END IF;
1633:
1634: IF (x_lrvv_rec.standard_rate IS NULL) THEN
1635: x_lrvv_rec.standard_rate := l_lrvv_rec.standard_rate;
1636: END IF;
1637: RETURN(l_return_status);
1638: END populate_new_record;
1639:

Line 1768: ,standard_rate = l_def_lrvv_rec.standard_rate

1764: ,attribute12 = l_def_lrvv_rec.attribute12
1765: ,attribute13 = l_def_lrvv_rec.attribute13
1766: ,attribute14 = l_def_lrvv_rec.attribute14
1767: ,attribute15 = l_def_lrvv_rec.attribute15
1768: ,standard_rate = l_def_lrvv_rec.standard_rate
1769: WHERE rate_set_version_id = l_def_lrvv_rec.rate_set_version_id;
1770:
1771: --Set OUT Values
1772: