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_CRQ_PVT dependencies on OKL_CREDIT_REQUESTS

Line 94: -- FUNCTION get_rec for: OKL_CREDIT_REQUESTS_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_CREDIT_REQUESTS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_crqv_rec IN crqv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 137: FROM OKL_CREDIT_REQUESTS

133: CREATION_DATE,
134: LAST_UPDATED_BY,
135: LAST_UPDATE_DATE,
136: LAST_UPDATE_LOGIN
137: FROM OKL_CREDIT_REQUESTS
138: WHERE OKL_CREDIT_REQUESTS.id = p_id;
139: l_okl_crqv_pk okl_crqv_pk_csr%ROWTYPE;
140: l_crqv_rec crqv_rec_type;
141: BEGIN

Line 138: WHERE OKL_CREDIT_REQUESTS.id = p_id;

134: LAST_UPDATED_BY,
135: LAST_UPDATE_DATE,
136: LAST_UPDATE_LOGIN
137: FROM OKL_CREDIT_REQUESTS
138: WHERE OKL_CREDIT_REQUESTS.id = p_id;
139: l_okl_crqv_pk okl_crqv_pk_csr%ROWTYPE;
140: l_crqv_rec crqv_rec_type;
141: BEGIN
142: x_no_data_found := TRUE;

Line 215: -- FUNCTION get_rec for: OKL_CREDIT_REQUESTS

211: BEGIN
212: RETURN(get_rec(p_crqv_rec, l_row_not_found));
213: END get_rec;
214: ---------------------------------------------------------------------------
215: -- FUNCTION get_rec for: OKL_CREDIT_REQUESTS
216: ---------------------------------------------------------------------------
217: FUNCTION get_rec (
218: p_crq_rec IN crq_rec_type,
219: x_no_data_found OUT NOCOPY BOOLEAN

Line 258: FROM Okl_Credit_Requests

254: CREATION_DATE,
255: LAST_UPDATED_BY,
256: LAST_UPDATE_DATE,
257: LAST_UPDATE_LOGIN
258: FROM Okl_Credit_Requests
259: WHERE okl_credit_requests.id = p_id;
260: l_okl_crq_pk okl_crq_pk_csr%ROWTYPE;
261: l_crq_rec crq_rec_type;
262: BEGIN

Line 259: WHERE okl_credit_requests.id = p_id;

255: LAST_UPDATED_BY,
256: LAST_UPDATE_DATE,
257: LAST_UPDATE_LOGIN
258: FROM Okl_Credit_Requests
259: WHERE okl_credit_requests.id = p_id;
260: l_okl_crq_pk okl_crq_pk_csr%ROWTYPE;
261: l_crq_rec crq_rec_type;
262: BEGIN
263: x_no_data_found := TRUE;

Line 336: -- FUNCTION null_out_defaults for: OKL_CREDIT_REQUESTS_V

332: BEGIN
333: RETURN(get_rec(p_crq_rec, l_row_not_found));
334: END get_rec;
335: ---------------------------------------------------------------------------
336: -- FUNCTION null_out_defaults for: OKL_CREDIT_REQUESTS_V
337: ---------------------------------------------------------------------------
338: FUNCTION null_out_defaults (
339: p_crqv_rec IN crqv_rec_type
340: ) RETURN crqv_rec_type IS

Line 562: -- Validate_Attributes for:OKL_CREDIT_REQUESTS_V --

558: ---------------------------------------------------------------------------
559: -- FUNCTION Validate_Attributes
560: ---------------------------------------------------------------------------
561: ---------------------------------------------------
562: -- Validate_Attributes for:OKL_CREDIT_REQUESTS_V --
563: ---------------------------------------------------
564: FUNCTION Validate_Attributes (
565: p_crqv_rec IN crqv_rec_type
566: ) RETURN VARCHAR2 IS

Line 627: -- Validate Record for:OKL_CREDIT_REQUESTS_V --

623: ---------------------------------------------------------------------------
624: -- PROCEDURE Validate_Record
625: ---------------------------------------------------------------------------
626: -----------------------------------------------
627: -- Validate Record for:OKL_CREDIT_REQUESTS_V --
628: -----------------------------------------------
629: FUNCTION Validate_Record (
630: p_crqv_rec IN crqv_rec_type,
631: p_db_crqv_rec IN crqv_rec_type

Line 774: -- validate_row for:OKL_CREDIT_REQUESTS_V --

770: ---------------------------------------------------------------------------
771: -- PROCEDURE validate_row
772: ---------------------------------------------------------------------------
773: --------------------------------------------
774: -- validate_row for:OKL_CREDIT_REQUESTS_V --
775: --------------------------------------------
776: PROCEDURE validate_row(
777: p_api_version IN NUMBER,
778: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 851: -- PL/SQL TBL validate_row for:OKL_CREDIT_REQUESTS_V --

847: '_PVT'
848: );
849: END validate_row;
850: -------------------------------------------------------
851: -- PL/SQL TBL validate_row for:OKL_CREDIT_REQUESTS_V --
852: -------------------------------------------------------
853: PROCEDURE validate_row(
854: p_api_version IN NUMBER,
855: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 947: -- PL/SQL TBL validate_row for:OKL_CREDIT_REQUESTS_V --

943: );
944: END validate_row;
945:
946: -------------------------------------------------------
947: -- PL/SQL TBL validate_row for:OKL_CREDIT_REQUESTS_V --
948: -------------------------------------------------------
949: PROCEDURE validate_row(
950: p_api_version IN NUMBER,
951: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1012: -- insert_row for:OKL_CREDIT_REQUESTS --

1008: ---------------------------------------------------------------------------
1009: -- PROCEDURE insert_row
1010: ---------------------------------------------------------------------------
1011: ----------------------------------------
1012: -- insert_row for:OKL_CREDIT_REQUESTS --
1013: ----------------------------------------
1014: PROCEDURE insert_row(
1015: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1016: x_return_status OUT NOCOPY VARCHAR2,

Line 1028: -- Set_Attributes for:OKL_CREDIT_REQUESTS --

1024: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1025: l_crq_rec crq_rec_type := p_crq_rec;
1026: l_def_crq_rec crq_rec_type;
1027: --------------------------------------------
1028: -- Set_Attributes for:OKL_CREDIT_REQUESTS --
1029: --------------------------------------------
1030: FUNCTION Set_Attributes (
1031: p_crq_rec IN crq_rec_type,
1032: x_crq_rec OUT NOCOPY crq_rec_type

Line 1059: INSERT INTO OKL_CREDIT_REQUESTS(

1055: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1057: RAISE OKC_API.G_EXCEPTION_ERROR;
1058: END IF;
1059: INSERT INTO OKL_CREDIT_REQUESTS(
1060: id,
1061: quote_id,
1062: credit_req_number,
1063: credit_req_id,

Line 1168: -- insert_row for :OKL_CREDIT_REQUESTS_V --

1164: '_PVT'
1165: );
1166: END insert_row;
1167: -------------------------------------------
1168: -- insert_row for :OKL_CREDIT_REQUESTS_V --
1169: -------------------------------------------
1170: PROCEDURE insert_row(
1171: p_api_version IN NUMBER,
1172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1202: -- Set_Attributes for:OKL_CREDIT_REQUESTS_V --

1198: l_crqv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1199: RETURN(l_crqv_rec);
1200: END fill_who_columns;
1201: ----------------------------------------------
1202: -- Set_Attributes for:OKL_CREDIT_REQUESTS_V --
1203: ----------------------------------------------
1204: FUNCTION Set_Attributes (
1205: p_crqv_rec IN crqv_rec_type,
1206: x_crqv_rec OUT NOCOPY crqv_rec_type

Line 1478: -- lock_row for:OKL_CREDIT_REQUESTS --

1474: ---------------------------------------------------------------------------
1475: -- PROCEDURE lock_row
1476: ---------------------------------------------------------------------------
1477: --------------------------------------
1478: -- lock_row for:OKL_CREDIT_REQUESTS --
1479: --------------------------------------
1480: PROCEDURE lock_row(
1481: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1482: x_return_status OUT NOCOPY VARCHAR2,

Line 1491: FROM OKL_CREDIT_REQUESTS

1487: E_Resource_Busy EXCEPTION;
1488: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1489: CURSOR lock_csr (p_crq_rec IN crq_rec_type) IS
1490: SELECT OBJECT_VERSION_NUMBER
1491: FROM OKL_CREDIT_REQUESTS
1492: WHERE ID = p_crq_rec.id
1493: AND OBJECT_VERSION_NUMBER = p_crq_rec.object_version_number
1494: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1495:

Line 1498: FROM OKL_CREDIT_REQUESTS

1494: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1495:
1496: CURSOR lchk_csr (p_crq_rec IN crq_rec_type) IS
1497: SELECT OBJECT_VERSION_NUMBER
1498: FROM OKL_CREDIT_REQUESTS
1499: WHERE ID = p_crq_rec.id;
1500: l_api_version CONSTANT NUMBER := 1;
1501: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1502: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1503: l_object_version_number OKL_CREDIT_REQUESTS.OBJECT_VERSION_NUMBER%TYPE;

1499: WHERE ID = p_crq_rec.id;
1500: l_api_version CONSTANT NUMBER := 1;
1501: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1502: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1503: l_object_version_number OKL_CREDIT_REQUESTS.OBJECT_VERSION_NUMBER%TYPE;
1504: lc_object_version_number OKL_CREDIT_REQUESTS.OBJECT_VERSION_NUMBER%TYPE;
1505: l_row_notfound BOOLEAN := FALSE;
1506: lc_row_notfound BOOLEAN := FALSE;
1507: BEGIN

Line 1504: lc_object_version_number OKL_CREDIT_REQUESTS.OBJECT_VERSION_NUMBER%TYPE;

1500: l_api_version CONSTANT NUMBER := 1;
1501: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1502: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1503: l_object_version_number OKL_CREDIT_REQUESTS.OBJECT_VERSION_NUMBER%TYPE;
1504: lc_object_version_number OKL_CREDIT_REQUESTS.OBJECT_VERSION_NUMBER%TYPE;
1505: l_row_notfound BOOLEAN := FALSE;
1506: lc_row_notfound BOOLEAN := FALSE;
1507: BEGIN
1508: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1585: -- lock_row for: OKL_CREDIT_REQUESTS_V --

1581: '_PVT'
1582: );
1583: END lock_row;
1584: -----------------------------------------
1585: -- lock_row for: OKL_CREDIT_REQUESTS_V --
1586: -----------------------------------------
1587: PROCEDURE lock_row(
1588: p_api_version IN NUMBER,
1589: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1825: -- update_row for:OKL_CREDIT_REQUESTS --

1821: ---------------------------------------------------------------------------
1822: -- PROCEDURE update_row
1823: ---------------------------------------------------------------------------
1824: ----------------------------------------
1825: -- update_row for:OKL_CREDIT_REQUESTS --
1826: ----------------------------------------
1827: PROCEDURE update_row(
1828: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1829: x_return_status OUT NOCOPY VARCHAR2,

Line 2000: -- Set_Attributes for:OKL_CREDIT_REQUESTS --

1996: END IF;
1997: RETURN(l_return_status);
1998: END populate_new_record;
1999: --------------------------------------------
2000: -- Set_Attributes for:OKL_CREDIT_REQUESTS --
2001: --------------------------------------------
2002: FUNCTION Set_Attributes (
2003: p_crq_rec IN crq_rec_type,
2004: x_crq_rec OUT NOCOPY crq_rec_type

Line 2038: UPDATE OKL_CREDIT_REQUESTS

2034: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2035: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2036: RAISE OKC_API.G_EXCEPTION_ERROR;
2037: END IF;
2038: UPDATE OKL_CREDIT_REQUESTS
2039: SET QUOTE_ID = l_def_crq_rec.quote_id,
2040: CREDIT_REQ_NUMBER = l_def_crq_rec.credit_req_number,
2041: CREDIT_REQ_ID = l_def_crq_rec.credit_req_id,
2042: CREDIT_AMOUNT = l_def_crq_rec.credit_amount,

Line 2111: -- update_row for:OKL_CREDIT_REQUESTS_V --

2107: '_PVT'
2108: );
2109: END update_row;
2110: ------------------------------------------
2111: -- update_row for:OKL_CREDIT_REQUESTS_V --
2112: ------------------------------------------
2113: PROCEDURE update_row(
2114: p_api_version IN NUMBER,
2115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2299: -- Set_Attributes for:OKL_CREDIT_REQUESTS_V --

2295: END IF;
2296: RETURN(l_return_status);
2297: END populate_new_record;
2298: ----------------------------------------------
2299: -- Set_Attributes for:OKL_CREDIT_REQUESTS_V --
2300: ----------------------------------------------
2301: FUNCTION Set_Attributes (
2302: p_crqv_rec IN crqv_rec_type,
2303: x_crqv_rec OUT NOCOPY crqv_rec_type

Line 2591: -- delete_row for:OKL_CREDIT_REQUESTS --

2587: ---------------------------------------------------------------------------
2588: -- PROCEDURE delete_row
2589: ---------------------------------------------------------------------------
2590: ----------------------------------------
2591: -- delete_row for:OKL_CREDIT_REQUESTS --
2592: ----------------------------------------
2593: PROCEDURE delete_row(
2594: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2595: x_return_status OUT NOCOPY VARCHAR2,

Line 2616: DELETE FROM OKL_CREDIT_REQUESTS

2612: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2613: RAISE OKC_API.G_EXCEPTION_ERROR;
2614: END IF;
2615:
2616: DELETE FROM OKL_CREDIT_REQUESTS
2617: WHERE ID = p_crq_rec.id;
2618:
2619: x_return_status := l_return_status;
2620: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2654: -- delete_row for:OKL_CREDIT_REQUESTS_V --

2650: '_PVT'
2651: );
2652: END delete_row;
2653: ------------------------------------------
2654: -- delete_row for:OKL_CREDIT_REQUESTS_V --
2655: ------------------------------------------
2656: PROCEDURE delete_row(
2657: p_api_version IN NUMBER,
2658: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2736: -- PL/SQL TBL delete_row for:OKL_CREDIT_REQUESTS_V --

2732: '_PVT'
2733: );
2734: END delete_row;
2735: -----------------------------------------------------
2736: -- PL/SQL TBL delete_row for:OKL_CREDIT_REQUESTS_V --
2737: -----------------------------------------------------
2738: PROCEDURE delete_row(
2739: p_api_version IN NUMBER,
2740: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2832: -- PL/SQL TBL delete_row for:OKL_CREDIT_REQUESTS_V --

2828: );
2829: END delete_row;
2830:
2831: -----------------------------------------------------
2832: -- PL/SQL TBL delete_row for:OKL_CREDIT_REQUESTS_V --
2833: -----------------------------------------------------
2834: PROCEDURE delete_row(
2835: p_api_version IN NUMBER,
2836: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,