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.OKL_DRV_PVT dependencies on OKL_DISB_RULE_VENDOR_SITES

Line 66: CURSOR c_pk_csr IS SELECT okl_disb_rule_vendor_sites_s.NEXTVAL FROM DUAL;

62: -- FUNCTION get_seq_id
63: ---------------------------------------------------------------------------
64: FUNCTION get_seq_id RETURN NUMBER IS
65: l_pk_value NUMBER;
66: CURSOR c_pk_csr IS SELECT okl_disb_rule_vendor_sites_s.NEXTVAL FROM DUAL;
67: BEGIN
68: /* Fetch the pk value from the sequence */
69: OPEN c_pk_csr;
70: FETCH c_pk_csr INTO l_pk_value;

Line 100: -- FUNCTION get_rec for: OKL_DISB_RULE_VENDOR_SITES

96: null;
97: END api_copy;
98:
99: ---------------------------------------------------------------------------
100: -- FUNCTION get_rec for: OKL_DISB_RULE_VENDOR_SITES
101: ---------------------------------------------------------------------------
102: FUNCTION get_rec (
103: p_drv_rec IN drv_rec_type,
104: x_no_data_found OUT NOCOPY BOOLEAN

Line 139: FROM Okl_Disb_Rule_Vendor_Sites

135: CREATION_DATE,
136: LAST_UPDATED_BY,
137: LAST_UPDATE_DATE,
138: LAST_UPDATE_LOGIN
139: FROM Okl_Disb_Rule_Vendor_Sites
140: WHERE okl_disb_rule_vendor_sites.disb_rule_vendor_site_id = p_disb_rule_vendor_site_id;
141: l_okl_drv_pk okl_drv_pk_csr%ROWTYPE;
142: l_drv_rec drv_rec_type;
143: BEGIN

Line 140: WHERE okl_disb_rule_vendor_sites.disb_rule_vendor_site_id = p_disb_rule_vendor_site_id;

136: LAST_UPDATED_BY,
137: LAST_UPDATE_DATE,
138: LAST_UPDATE_LOGIN
139: FROM Okl_Disb_Rule_Vendor_Sites
140: WHERE okl_disb_rule_vendor_sites.disb_rule_vendor_site_id = p_disb_rule_vendor_site_id;
141: l_okl_drv_pk okl_drv_pk_csr%ROWTYPE;
142: l_drv_rec drv_rec_type;
143: BEGIN
144: x_no_data_found := TRUE;

Line 213: -- FUNCTION null_out_defaults for: OKL_DISB_RULE_VENDOR_SITES

209: BEGIN
210: RETURN(get_rec(p_drv_rec, l_row_not_found));
211: END get_rec;
212: ---------------------------------------------------------------------------
213: -- FUNCTION null_out_defaults for: OKL_DISB_RULE_VENDOR_SITES
214: ---------------------------------------------------------------------------
215: FUNCTION null_out_defaults (
216: p_drv_rec IN drv_rec_type
217: ) RETURN drv_rec_type IS

Line 444: -- Validate_Attributes for:OKL_DISB_RULE_VENDOR_SITES --

440: ---------------------------------------------------------------------------
441: -- FUNCTION Validate_Attributes
442: ---------------------------------------------------------------------------
443: --------------------------------------------------------
444: -- Validate_Attributes for:OKL_DISB_RULE_VENDOR_SITES --
445: --------------------------------------------------------
446: FUNCTION Validate_Attributes (
447: p_drv_rec IN drv_rec_type
448: ) RETURN VARCHAR2 IS

Line 518: -- Validate Record for:OKL_DISB_RULE_VENDOR_SITES --

514: ---------------------------------------------------------------------------
515: -- PROCEDURE Validate_Record
516: ---------------------------------------------------------------------------
517: ----------------------------------------------------
518: -- Validate Record for:OKL_DISB_RULE_VENDOR_SITES --
519: ----------------------------------------------------
520: FUNCTION Validate_Record (
521: p_drv_rec IN drv_rec_type,
522: p_db_drv_rec IN drv_rec_type

Line 546: -- validate_row for:OKL_DISB_RULE_VENDOR_SITES --

542: ---------------------------------------------------------------------------
543: -- PROCEDURE validate_row
544: ---------------------------------------------------------------------------
545: -------------------------------------------------
546: -- validate_row for:OKL_DISB_RULE_VENDOR_SITES --
547: -------------------------------------------------
548: PROCEDURE validate_row(
549: p_api_version IN NUMBER,
550: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 621: -- PL/SQL TBL validate_row for:OKL_DISB_RULE_VENDOR_SITES --

617: '_PVT'
618: );
619: END validate_row;
620: ------------------------------------------------------------
621: -- PL/SQL TBL validate_row for:OKL_DISB_RULE_VENDOR_SITES --
622: ------------------------------------------------------------
623: PROCEDURE validate_row(
624: p_api_version IN NUMBER,
625: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 717: -- PL/SQL TBL validate_row for:OKL_DISB_RULE_VENDOR_SITES --

713: );
714: END validate_row;
715:
716: ------------------------------------------------------------
717: -- PL/SQL TBL validate_row for:OKL_DISB_RULE_VENDOR_SITES --
718: ------------------------------------------------------------
719: PROCEDURE validate_row(
720: p_api_version IN NUMBER,
721: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 782: -- insert_row for:OKL_DISB_RULE_VENDOR_SITES --

778: ---------------------------------------------------------------------------
779: -- PROCEDURE insert_row
780: ---------------------------------------------------------------------------
781: -----------------------------------------------
782: -- insert_row for:OKL_DISB_RULE_VENDOR_SITES --
783: -----------------------------------------------
784: PROCEDURE insert_row(
785: p_api_version IN NUMBER,
786: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 814: -- Set_Attributes for:OKL_DISB_RULE_VENDOR_SITES --

810: l_drv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
811: RETURN(l_drv_rec);
812: END fill_who_columns;
813: ---------------------------------------------------
814: -- Set_Attributes for:OKL_DISB_RULE_VENDOR_SITES --
815: ---------------------------------------------------
816: FUNCTION Set_Attributes (
817: p_drv_rec IN drv_rec_type,
818: x_drv_rec OUT NOCOPY drv_rec_type

Line 872: INSERT INTO OKL_DISB_RULE_VENDOR_SITES(

868: --DBMS_OUTPUT.put_line('Before insert in DRV PVT');
869: --DBMS_OUTPUT.put_line('l_drv_rec.created_by' || l_def_drv_rec.created_by);
870:
871:
872: INSERT INTO OKL_DISB_RULE_VENDOR_SITES(
873: disb_rule_vendor_site_id,
874: object_version_number,
875: disb_rule_id,
876: vendor_id,

Line 1137: -- lock_row for:OKL_DISB_RULE_VENDOR_SITES --

1133: ---------------------------------------------------------------------------
1134: -- PROCEDURE lock_row
1135: ---------------------------------------------------------------------------
1136: ---------------------------------------------
1137: -- lock_row for:OKL_DISB_RULE_VENDOR_SITES --
1138: ---------------------------------------------
1139: PROCEDURE lock_row(
1140: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1141: x_return_status OUT NOCOPY VARCHAR2,

Line 1150: FROM OKL_DISB_RULE_VENDOR_SITES

1146: E_Resource_Busy EXCEPTION;
1147: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1148: CURSOR lock_csr (p_drv_rec IN drv_rec_type) IS
1149: SELECT OBJECT_VERSION_NUMBER
1150: FROM OKL_DISB_RULE_VENDOR_SITES
1151: WHERE DISB_RULE_VENDOR_SITE_ID = p_drv_rec.disb_rule_vendor_site_id
1152: AND OBJECT_VERSION_NUMBER = p_drv_rec.object_version_number
1153: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1154:

Line 1157: FROM OKL_DISB_RULE_VENDOR_SITES

1153: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1154:
1155: CURSOR lchk_csr (p_drv_rec IN drv_rec_type) IS
1156: SELECT OBJECT_VERSION_NUMBER
1157: FROM OKL_DISB_RULE_VENDOR_SITES
1158: WHERE DISB_RULE_VENDOR_SITE_ID = p_drv_rec.disb_rule_vendor_site_id;
1159: l_api_version CONSTANT NUMBER := 1;
1160: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1161: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1162: l_object_version_number OKL_DISB_RULE_VENDOR_SITES.OBJECT_VERSION_NUMBER%TYPE;

1158: WHERE DISB_RULE_VENDOR_SITE_ID = p_drv_rec.disb_rule_vendor_site_id;
1159: l_api_version CONSTANT NUMBER := 1;
1160: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1161: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1162: l_object_version_number OKL_DISB_RULE_VENDOR_SITES.OBJECT_VERSION_NUMBER%TYPE;
1163: lc_object_version_number OKL_DISB_RULE_VENDOR_SITES.OBJECT_VERSION_NUMBER%TYPE;
1164: l_row_notfound BOOLEAN := FALSE;
1165: lc_row_notfound BOOLEAN := FALSE;
1166: BEGIN

Line 1163: lc_object_version_number OKL_DISB_RULE_VENDOR_SITES.OBJECT_VERSION_NUMBER%TYPE;

1159: l_api_version CONSTANT NUMBER := 1;
1160: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1161: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1162: l_object_version_number OKL_DISB_RULE_VENDOR_SITES.OBJECT_VERSION_NUMBER%TYPE;
1163: lc_object_version_number OKL_DISB_RULE_VENDOR_SITES.OBJECT_VERSION_NUMBER%TYPE;
1164: l_row_notfound BOOLEAN := FALSE;
1165: lc_row_notfound BOOLEAN := FALSE;
1166: BEGIN
1167: --debug_proc('Lock disb_rule_vendor_site_id' || p_drv_rec.disb_rule_vendor_site_id);

Line 1247: -- lock_row for: OKL_DISB_RULE_VENDOR_SITES --

1243: '_PVT'
1244: );
1245: END lock_row;
1246: ----------------------------------------------
1247: -- lock_row for: OKL_DISB_RULE_VENDOR_SITES --
1248: ----------------------------------------------
1249: PROCEDURE lock_row(
1250: p_api_version IN NUMBER,
1251: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1486: -- update_row for:OKL_DISB_RULE_VENDOR_SITES --

1482: ---------------------------------------------------------------------------
1483: -- PROCEDURE update_row
1484: ---------------------------------------------------------------------------
1485: -----------------------------------------------
1486: -- update_row for:OKL_DISB_RULE_VENDOR_SITES --
1487: -----------------------------------------------
1488: PROCEDURE update_row(
1489: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1490: x_return_status OUT NOCOPY VARCHAR2,

Line 1619: -- Set_Attributes for:OKL_DISB_RULE_VENDOR_SITES --

1615: END IF;
1616: RETURN(l_return_status);
1617: END populate_new_record;
1618: ---------------------------------------------------
1619: -- Set_Attributes for:OKL_DISB_RULE_VENDOR_SITES --
1620: ---------------------------------------------------
1621: FUNCTION Set_Attributes (
1622: p_drv_rec IN drv_rec_type,
1623: x_drv_rec OUT NOCOPY drv_rec_type

Line 1667: UPDATE OKL_DISB_RULE_VENDOR_SITES

1663: --g_debug_proc('update query ');
1664:
1665:
1666:
1667: UPDATE OKL_DISB_RULE_VENDOR_SITES
1668: SET OBJECT_VERSION_NUMBER = l_def_drv_rec.object_version_number,
1669: DISB_RULE_ID = l_def_drv_rec.disb_rule_id,
1670: VENDOR_ID = l_def_drv_rec.vendor_id,
1671: VENDOR_SITE_ID = l_def_drv_rec.vendor_site_id,

Line 1736: -- update_row for:OKL_DISB_RULE_VENDOR_SITES --

1732: '_PVT'
1733: );
1734: END update_row;
1735: -----------------------------------------------
1736: -- update_row for:OKL_DISB_RULE_VENDOR_SITES --
1737: -----------------------------------------------
1738: PROCEDURE update_row(
1739: p_api_version IN NUMBER,
1740: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1883: -- Set_Attributes for:OKL_DISB_RULE_VENDOR_SITES --

1879: END IF;
1880: RETURN(l_return_status);
1881: END populate_new_record;
1882: ---------------------------------------------------
1883: -- Set_Attributes for:OKL_DISB_RULE_VENDOR_SITES --
1884: ---------------------------------------------------
1885: FUNCTION Set_Attributes (
1886: p_drv_rec IN drv_rec_type,
1887: x_drv_rec OUT NOCOPY drv_rec_type

Line 2236: -- delete_row for:OKL_DISB_RULE_VENDOR_SITES --

2232: ---------------------------------------------------------------------------
2233: -- PROCEDURE delete_row
2234: ---------------------------------------------------------------------------
2235: -----------------------------------------------
2236: -- delete_row for:OKL_DISB_RULE_VENDOR_SITES --
2237: -----------------------------------------------
2238: PROCEDURE delete_row(
2239: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2240: x_return_status OUT NOCOPY VARCHAR2,

Line 2261: DELETE FROM OKL_DISB_RULE_VENDOR_SITES

2257: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2258: RAISE OKL_API.G_EXCEPTION_ERROR;
2259: END IF;
2260:
2261: DELETE FROM OKL_DISB_RULE_VENDOR_SITES
2262: WHERE DISB_RULE_VENDOR_SITE_ID = p_drv_rec.disb_rule_vendor_site_id;
2263:
2264: x_return_status := l_return_status;
2265: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2299: -- delete_row for:OKL_DISB_RULE_VENDOR_SITES --

2295: '_PVT'
2296: );
2297: END delete_row;
2298: -----------------------------------------------
2299: -- delete_row for:OKL_DISB_RULE_VENDOR_SITES --
2300: -----------------------------------------------
2301: PROCEDURE delete_row(
2302: p_api_version IN NUMBER,
2303: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2379: -- PL/SQL TBL delete_row for:OKL_DISB_RULE_VENDOR_SITES --

2375: '_PVT'
2376: );
2377: END delete_row;
2378: ----------------------------------------------------------
2379: -- PL/SQL TBL delete_row for:OKL_DISB_RULE_VENDOR_SITES --
2380: ----------------------------------------------------------
2381: PROCEDURE delete_row(
2382: p_api_version IN NUMBER,
2383: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2475: -- PL/SQL TBL delete_row for:OKL_DISB_RULE_VENDOR_SITES --

2471: );
2472: END delete_row;
2473:
2474: ----------------------------------------------------------
2475: -- PL/SQL TBL delete_row for:OKL_DISB_RULE_VENDOR_SITES --
2476: ----------------------------------------------------------
2477: PROCEDURE delete_row(
2478: p_api_version IN NUMBER,
2479: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,