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_QCO_PVT dependencies on OKL_TRX_QTE_CF_OBJECTS

Line 94: -- FUNCTION get_rec for: OKL_TRX_QTE_CF_OBJECTS_V

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

Line 128: FROM Okl_Trx_Qte_Cf_Objects_V

124: ATTRIBUTE12,
125: ATTRIBUTE13,
126: ATTRIBUTE14,
127: ATTRIBUTE15
128: FROM Okl_Trx_Qte_Cf_Objects_V
129: WHERE okl_trx_qte_cf_objects_v.id = p_id;
130: l_okl_qcov_pk okl_qcov_pk_csr%ROWTYPE;
131: l_qcov_rec qcov_rec_type;
132: BEGIN

Line 129: WHERE okl_trx_qte_cf_objects_v.id = p_id;

125: ATTRIBUTE13,
126: ATTRIBUTE14,
127: ATTRIBUTE15
128: FROM Okl_Trx_Qte_Cf_Objects_V
129: WHERE okl_trx_qte_cf_objects_v.id = p_id;
130: l_okl_qcov_pk okl_qcov_pk_csr%ROWTYPE;
131: l_qcov_rec qcov_rec_type;
132: BEGIN
133: x_no_data_found := TRUE;

Line 197: -- FUNCTION get_rec for: OKL_TRX_QTE_CF_OBJECTS

193: BEGIN
194: RETURN(get_rec(p_qcov_rec, l_row_not_found));
195: END get_rec;
196: ---------------------------------------------------------------------------
197: -- FUNCTION get_rec for: OKL_TRX_QTE_CF_OBJECTS
198: ---------------------------------------------------------------------------
199: FUNCTION get_rec (
200: p_qco_rec IN qco_rec_type,
201: x_no_data_found OUT NOCOPY BOOLEAN

Line 231: FROM Okl_Trx_Qte_Cf_Objects

227: ATTRIBUTE12,
228: ATTRIBUTE13,
229: ATTRIBUTE14,
230: ATTRIBUTE15
231: FROM Okl_Trx_Qte_Cf_Objects
232: WHERE okl_trx_qte_cf_objects.id = p_id;
233: l_okl_trx_quotes_cf_objects_pk okl_trx_quotes_cf_o1%ROWTYPE;
234: l_qco_rec qco_rec_type;
235: BEGIN

Line 232: WHERE okl_trx_qte_cf_objects.id = p_id;

228: ATTRIBUTE13,
229: ATTRIBUTE14,
230: ATTRIBUTE15
231: FROM Okl_Trx_Qte_Cf_Objects
232: WHERE okl_trx_qte_cf_objects.id = p_id;
233: l_okl_trx_quotes_cf_objects_pk okl_trx_quotes_cf_o1%ROWTYPE;
234: l_qco_rec qco_rec_type;
235: BEGIN
236: x_no_data_found := TRUE;

Line 300: -- FUNCTION null_out_defaults for: OKL_TRX_QTE_CF_OBJECTS_V

296: BEGIN
297: RETURN(get_rec(p_qco_rec, l_row_not_found));
298: END get_rec;
299: ---------------------------------------------------------------------------
300: -- FUNCTION null_out_defaults for: OKL_TRX_QTE_CF_OBJECTS_V
301: ---------------------------------------------------------------------------
302: FUNCTION null_out_defaults (
303: p_qcov_rec IN qcov_rec_type
304: ) RETURN qcov_rec_type IS

Line 461: 'OKL_TRX_QTE_CF_OBJECTS_V',

457: g_no_parent_record,
458: g_col_name_token,
459: 'qte_id',
460: g_child_table_token ,
461: 'OKL_TRX_QTE_CF_OBJECTS_V',
462: g_parent_table_token ,
463: 'OKL_TRX_QUOTES_V OR OKL_TRX_REQUESTS');
464: l_return_status := OKC_API.G_RET_STS_ERROR;
465: END IF;

Line 516: 'OKL_TRX_QTE_CF_OBJECTS_V',

512: g_no_parent_record,
513: g_col_name_token,
514: 'cfo_id',
515: g_child_table_token ,
516: 'OKL_TRX_QTE_CF_OBJECTS_V',
517: g_parent_table_token ,
518: 'OKL_CASH_FLOW_OBJECTS_V');
519: l_return_status := OKC_API.G_RET_STS_ERROR;
520:

Line 593: -- Validate_Attributes for:OKL_TRX_QTE_CF_OBJECTS_V --

589: ---------------------------------------------------------------------------
590: -- FUNCTION Validate_Attributes
591: ---------------------------------------------------------------------------
592: --------------------------------------------------------
593: -- Validate_Attributes for:OKL_TRX_QTE_CF_OBJECTS_V --
594: --------------------------------------------------------
595: FUNCTION Validate_Attributes (
596: p_qcov_rec IN qcov_rec_type
597: ) RETURN VARCHAR2 IS

Line 689: -- Validate Record for:OKL_TRX_QTE_CF_OBJECTS_V --

685: ---------------------------------------------------------------------------
686:
687: /* SECHAWLA - Not needed, as foreign key validation was moved under individual validate_ procedures
688: ----------------------------------------------------
689: -- Validate Record for:OKL_TRX_QTE_CF_OBJECTS_V --
690: ----------------------------------------------------
691: FUNCTION Validate_Record (
692: p_qcov_rec IN qcov_rec_type,
693: p_db_qcov_rec IN qcov_rec_type

Line 839: -- validate_row for:OKL_TRX_QTE_CF_OBJECTS_V --

835: ---------------------------------------------------------------------------
836: -- PROCEDURE validate_row
837: ---------------------------------------------------------------------------
838: -------------------------------------------------
839: -- validate_row for:OKL_TRX_QTE_CF_OBJECTS_V --
840: -------------------------------------------------
841: PROCEDURE validate_row(
842: p_api_version IN NUMBER,
843: p_init_msg_list IN VARCHAR2,

Line 922: -- PL/SQL TBL validate_row for:OKL_TRX_QTE_CF_OBJECTS_V --

918: '_PVT'
919: );
920: END validate_row;
921: ------------------------------------------------------------
922: -- PL/SQL TBL validate_row for:OKL_TRX_QTE_CF_OBJECTS_V --
923: ------------------------------------------------------------
924: PROCEDURE validate_row(
925: p_api_version IN NUMBER,
926: p_init_msg_list IN VARCHAR2,

Line 1018: -- PL/SQL TBL validate_row for:OKL_TRX_QTE_CF_OBJECTS_V --

1014: );
1015: END validate_row;
1016:
1017: ------------------------------------------------------------
1018: -- PL/SQL TBL validate_row for:OKL_TRX_QTE_CF_OBJECTS_V --
1019: ------------------------------------------------------------
1020: PROCEDURE validate_row(
1021: p_api_version IN NUMBER,
1022: p_init_msg_list IN VARCHAR2,

Line 1083: -- insert_row for:OKL_TRX_QTE_CF_OBJECTS --

1079: ---------------------------------------------------------------------------
1080: -- PROCEDURE insert_row
1081: ---------------------------------------------------------------------------
1082: ---------------------------------------------
1083: -- insert_row for:OKL_TRX_QTE_CF_OBJECTS --
1084: ---------------------------------------------
1085: PROCEDURE insert_row(
1086: p_init_msg_list IN VARCHAR2,
1087: x_return_status OUT NOCOPY VARCHAR2,

Line 1099: -- Set_Attributes for:OKL_TRX_QTE_CF_OBJECTS --

1095: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1096: l_qco_rec qco_rec_type := p_qco_rec;
1097: l_def_qco_rec qco_rec_type;
1098: -------------------------------------------------
1099: -- Set_Attributes for:OKL_TRX_QTE_CF_OBJECTS --
1100: -------------------------------------------------
1101: FUNCTION Set_Attributes (
1102: p_qco_rec IN qco_rec_type,
1103: x_qco_rec OUT NOCOPY qco_rec_type

Line 1130: INSERT INTO OKL_TRX_QTE_CF_OBJECTS(

1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;
1130: INSERT INTO OKL_TRX_QTE_CF_OBJECTS(
1131: id,
1132: qte_id,
1133: cfo_id,
1134: base_source_id,

Line 1221: -- insert_row for :OKL_TRX_QTE_CF_OBJECTS_V --

1217: '_PVT'
1218: );
1219: END insert_row;
1220: ------------------------------------------------
1221: -- insert_row for :OKL_TRX_QTE_CF_OBJECTS_V --
1222: ------------------------------------------------
1223: PROCEDURE insert_row(
1224: p_api_version IN NUMBER,
1225: p_init_msg_list IN VARCHAR2,

Line 1255: -- Set_Attributes for:OKL_TRX_QTE_CF_OBJECTS_V --

1251: l_qcov_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1252: RETURN(l_qcov_rec);
1253: END fill_who_columns;
1254: ---------------------------------------------------
1255: -- Set_Attributes for:OKL_TRX_QTE_CF_OBJECTS_V --
1256: ---------------------------------------------------
1257: FUNCTION Set_Attributes (
1258: p_qcov_rec IN qcov_rec_type,
1259: x_qcov_rec OUT NOCOPY qcov_rec_type

Line 1538: -- insert row for bulk insert in OKL_TRX_QTE_CF_OBJECTS --

1534:
1535: --Bug 4299668 PAGARG new procedure to implement bulk insert
1536: --**START**--
1537: ----------------------------------------------------------
1538: -- insert row for bulk insert in OKL_TRX_QTE_CF_OBJECTS --
1539: ----------------------------------------------------------
1540: PROCEDURE insert_row_bulk(
1541: p_api_version IN NUMBER,
1542: p_init_msg_list IN VARCHAR2,

Line 1670: INSERT INTO OKL_TRX_QTE_CF_OBJECTS(

1666: END LOOP;
1667:
1668: -- Bulk insert into table
1669: FORALL i in 1..l_tabsize
1670: INSERT INTO OKL_TRX_QTE_CF_OBJECTS(
1671: id,
1672: qte_id,
1673: cfo_id,
1674: base_source_id,

Line 1767: -- lock_row for:OKL_TRX_QTE_CF_OBJECTS --

1763: ---------------------------------------------------------------------------
1764: -- PROCEDURE lock_row
1765: ---------------------------------------------------------------------------
1766: -------------------------------------------
1767: -- lock_row for:OKL_TRX_QTE_CF_OBJECTS --
1768: -------------------------------------------
1769: PROCEDURE lock_row(
1770: p_init_msg_list IN VARCHAR2,
1771: x_return_status OUT NOCOPY VARCHAR2,

Line 1780: FROM OKL_TRX_QTE_CF_OBJECTS

1776: E_Resource_Busy EXCEPTION;
1777: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1778: CURSOR lock_csr (p_qco_rec IN qco_rec_type) IS
1779: SELECT OBJECT_VERSION_NUMBER
1780: FROM OKL_TRX_QTE_CF_OBJECTS
1781: WHERE ID = p_qco_rec.id
1782: AND OBJECT_VERSION_NUMBER = p_qco_rec.object_version_number
1783: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1784:

Line 1787: FROM OKL_TRX_QTE_CF_OBJECTS

1783: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1784:
1785: CURSOR lchk_csr (p_qco_rec IN qco_rec_type) IS
1786: SELECT OBJECT_VERSION_NUMBER
1787: FROM OKL_TRX_QTE_CF_OBJECTS
1788: WHERE ID = p_qco_rec.id;
1789: l_api_version CONSTANT NUMBER := 1;
1790: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1791: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1792: l_object_version_number OKL_TRX_QTE_CF_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;

1788: WHERE ID = p_qco_rec.id;
1789: l_api_version CONSTANT NUMBER := 1;
1790: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1791: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1792: l_object_version_number OKL_TRX_QTE_CF_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
1793: lc_object_version_number OKL_TRX_QTE_CF_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
1794: l_row_notfound BOOLEAN := FALSE;
1795: lc_row_notfound BOOLEAN := FALSE;
1796: BEGIN

Line 1793: lc_object_version_number OKL_TRX_QTE_CF_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;

1789: l_api_version CONSTANT NUMBER := 1;
1790: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1791: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1792: l_object_version_number OKL_TRX_QTE_CF_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
1793: lc_object_version_number OKL_TRX_QTE_CF_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
1794: l_row_notfound BOOLEAN := FALSE;
1795: lc_row_notfound BOOLEAN := FALSE;
1796: BEGIN
1797: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1874: -- lock_row for: OKL_TRX_QTE_CF_OBJECTS_V --

1870: '_PVT'
1871: );
1872: END lock_row;
1873: ----------------------------------------------
1874: -- lock_row for: OKL_TRX_QTE_CF_OBJECTS_V --
1875: ----------------------------------------------
1876: PROCEDURE lock_row(
1877: p_api_version IN NUMBER,
1878: p_init_msg_list IN VARCHAR2,

Line 2114: -- update_row for:OKL_TRX_QTE_CF_OBJECTS --

2110: ---------------------------------------------------------------------------
2111: -- PROCEDURE update_row
2112: ---------------------------------------------------------------------------
2113: ---------------------------------------------
2114: -- update_row for:OKL_TRX_QTE_CF_OBJECTS --
2115: ---------------------------------------------
2116: PROCEDURE update_row(
2117: p_init_msg_list IN VARCHAR2,
2118: x_return_status OUT NOCOPY VARCHAR2,

Line 2253: -- Set_Attributes for:OKL_TRX_QTE_CF_OBJECTS --

2249: END IF;
2250: RETURN(l_return_status);
2251: END populate_new_record;
2252: -------------------------------------------------
2253: -- Set_Attributes for:OKL_TRX_QTE_CF_OBJECTS --
2254: -------------------------------------------------
2255: FUNCTION Set_Attributes (
2256: p_qco_rec IN qco_rec_type,
2257: x_qco_rec OUT NOCOPY qco_rec_type

Line 2291: UPDATE OKL_TRX_QTE_CF_OBJECTS

2287: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2288: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2289: RAISE OKL_API.G_EXCEPTION_ERROR;
2290: END IF;
2291: UPDATE OKL_TRX_QTE_CF_OBJECTS
2292: SET QTE_ID = l_def_qco_rec.qte_id,
2293: CFO_ID = l_def_qco_rec.cfo_id,
2294: BASE_SOURCE_ID = l_def_qco_rec.base_source_id,
2295: OBJECT_VERSION_NUMBER = l_def_qco_rec.object_version_number,

Line 2355: -- update_row for:OKL_TRX_QTE_CF_OBJECTS_V --

2351: '_PVT'
2352: );
2353: END update_row;
2354: -----------------------------------------------
2355: -- update_row for:OKL_TRX_QTE_CF_OBJECTS_V --
2356: -----------------------------------------------
2357: PROCEDURE update_row(
2358: p_api_version IN NUMBER,
2359: p_init_msg_list IN VARCHAR2,

Line 2507: -- Set_Attributes for:OKL_TRX_QTE_CF_OBJECTS_V --

2503: END IF;
2504: RETURN(l_return_status);
2505: END populate_new_record;
2506: ---------------------------------------------------
2507: -- Set_Attributes for:OKL_TRX_QTE_CF_OBJECTS_V --
2508: ---------------------------------------------------
2509: FUNCTION Set_Attributes (
2510: p_qcov_rec IN qcov_rec_type,
2511: x_qcov_rec OUT NOCOPY qcov_rec_type

Line 2806: -- delete_row for:OKL_TRX_QTE_CF_OBJECTS --

2802: ---------------------------------------------------------------------------
2803: -- PROCEDURE delete_row
2804: ---------------------------------------------------------------------------
2805: ---------------------------------------------
2806: -- delete_row for:OKL_TRX_QTE_CF_OBJECTS --
2807: ---------------------------------------------
2808: PROCEDURE delete_row(
2809: p_init_msg_list IN VARCHAR2,
2810: x_return_status OUT NOCOPY VARCHAR2,

Line 2831: DELETE FROM OKL_TRX_QTE_CF_OBJECTS

2827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2828: RAISE OKL_API.G_EXCEPTION_ERROR;
2829: END IF;
2830:
2831: DELETE FROM OKL_TRX_QTE_CF_OBJECTS
2832: WHERE ID = p_qco_rec.id;
2833:
2834: x_return_status := l_return_status;
2835: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2869: -- delete_row for:OKL_TRX_QTE_CF_OBJECTS_V --

2865: '_PVT'
2866: );
2867: END delete_row;
2868: -----------------------------------------------
2869: -- delete_row for:OKL_TRX_QTE_CF_OBJECTS_V --
2870: -----------------------------------------------
2871: PROCEDURE delete_row(
2872: p_api_version IN NUMBER,
2873: p_init_msg_list IN VARCHAR2,

Line 2951: -- PL/SQL TBL delete_row for:OKL_TRX_QTE_CF_OBJECTS_V --

2947: '_PVT'
2948: );
2949: END delete_row;
2950: ----------------------------------------------------------
2951: -- PL/SQL TBL delete_row for:OKL_TRX_QTE_CF_OBJECTS_V --
2952: ----------------------------------------------------------
2953: PROCEDURE delete_row(
2954: p_api_version IN NUMBER,
2955: p_init_msg_list IN VARCHAR2,

Line 3047: -- PL/SQL TBL delete_row for:OKL_TRX_QTE_CF_OBJECTS_V --

3043: );
3044: END delete_row;
3045:
3046: ----------------------------------------------------------
3047: -- PL/SQL TBL delete_row for:OKL_TRX_QTE_CF_OBJECTS_V --
3048: ----------------------------------------------------------
3049: PROCEDURE delete_row(
3050: p_api_version IN NUMBER,
3051: p_init_msg_list IN VARCHAR2,