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_QAB_PVT dependencies on OKL_TXD_QTE_ANTCPT_BILL

Line 94: -- FUNCTION get_rec for: OKL_TXD_QTE_ANTCPT_BILL_V

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

Line 141: FROM OKL_TXD_QTE_ANTCPT_BILL

137: CURRENCY_CONVERSION_CODE,
138: CURRENCY_CONVERSION_TYPE,
139: CURRENCY_CONVERSION_RATE,
140: CURRENCY_CONVERSION_DATE
141: FROM OKL_TXD_QTE_ANTCPT_BILL
142: WHERE OKL_TXD_QTE_ANTCPT_BILL.id = p_id;
143: l_okl_qabv_pk okl_qabv_pk_csr%ROWTYPE;
144: l_qabv_rec qabv_rec_type;
145: BEGIN

Line 142: WHERE OKL_TXD_QTE_ANTCPT_BILL.id = p_id;

138: CURRENCY_CONVERSION_TYPE,
139: CURRENCY_CONVERSION_RATE,
140: CURRENCY_CONVERSION_DATE
141: FROM OKL_TXD_QTE_ANTCPT_BILL
142: WHERE OKL_TXD_QTE_ANTCPT_BILL.id = p_id;
143: l_okl_qabv_pk okl_qabv_pk_csr%ROWTYPE;
144: l_qabv_rec qabv_rec_type;
145: BEGIN
146: x_no_data_found := TRUE;

Line 223: -- FUNCTION get_rec for: OKL_TXD_QTE_ANTCPT_BILL

219: BEGIN
220: RETURN(get_rec(p_qabv_rec, l_row_not_found));
221: END get_rec;
222: ---------------------------------------------------------------------------
223: -- FUNCTION get_rec for: OKL_TXD_QTE_ANTCPT_BILL
224: ---------------------------------------------------------------------------
225: FUNCTION get_rec (
226: p_qab_rec IN qab_rec_type,
227: x_no_data_found OUT NOCOPY BOOLEAN

Line 229: CURSOR okl_txd_qte_antcpt_bill_pk_csr (p_id IN NUMBER) IS

225: FUNCTION get_rec (
226: p_qab_rec IN qab_rec_type,
227: x_no_data_found OUT NOCOPY BOOLEAN
228: ) RETURN qab_rec_type IS
229: CURSOR okl_txd_qte_antcpt_bill_pk_csr (p_id IN NUMBER) IS
230: SELECT
231: ID,
232: OBJECT_VERSION_NUMBER,
233: KHR_ID,

Line 270: FROM Okl_Txd_Qte_Antcpt_Bill

266: CURRENCY_CONVERSION_CODE,
267: CURRENCY_CONVERSION_TYPE,
268: CURRENCY_CONVERSION_RATE,
269: CURRENCY_CONVERSION_DATE
270: FROM Okl_Txd_Qte_Antcpt_Bill
271: WHERE okl_txd_qte_antcpt_bill.id = p_id;
272: l_okl_txd_qte_antcpt_bill_pk okl_txd_qte_antcpt_bill_pk_csr%ROWTYPE;
273: l_qab_rec qab_rec_type;
274: BEGIN

Line 271: WHERE okl_txd_qte_antcpt_bill.id = p_id;

267: CURRENCY_CONVERSION_TYPE,
268: CURRENCY_CONVERSION_RATE,
269: CURRENCY_CONVERSION_DATE
270: FROM Okl_Txd_Qte_Antcpt_Bill
271: WHERE okl_txd_qte_antcpt_bill.id = p_id;
272: l_okl_txd_qte_antcpt_bill_pk okl_txd_qte_antcpt_bill_pk_csr%ROWTYPE;
273: l_qab_rec qab_rec_type;
274: BEGIN
275: x_no_data_found := TRUE;

Line 272: l_okl_txd_qte_antcpt_bill_pk okl_txd_qte_antcpt_bill_pk_csr%ROWTYPE;

268: CURRENCY_CONVERSION_RATE,
269: CURRENCY_CONVERSION_DATE
270: FROM Okl_Txd_Qte_Antcpt_Bill
271: WHERE okl_txd_qte_antcpt_bill.id = p_id;
272: l_okl_txd_qte_antcpt_bill_pk okl_txd_qte_antcpt_bill_pk_csr%ROWTYPE;
273: l_qab_rec qab_rec_type;
274: BEGIN
275: x_no_data_found := TRUE;
276: -- Get current database values

Line 277: OPEN okl_txd_qte_antcpt_bill_pk_csr (p_qab_rec.id);

273: l_qab_rec qab_rec_type;
274: BEGIN
275: x_no_data_found := TRUE;
276: -- Get current database values
277: OPEN okl_txd_qte_antcpt_bill_pk_csr (p_qab_rec.id);
278: FETCH okl_txd_qte_antcpt_bill_pk_csr INTO
279: l_qab_rec.id,
280: l_qab_rec.object_version_number,
281: l_qab_rec.khr_id,

Line 278: FETCH okl_txd_qte_antcpt_bill_pk_csr INTO

274: BEGIN
275: x_no_data_found := TRUE;
276: -- Get current database values
277: OPEN okl_txd_qte_antcpt_bill_pk_csr (p_qab_rec.id);
278: FETCH okl_txd_qte_antcpt_bill_pk_csr INTO
279: l_qab_rec.id,
280: l_qab_rec.object_version_number,
281: l_qab_rec.khr_id,
282: l_qab_rec.qte_id,

Line 318: x_no_data_found := okl_txd_qte_antcpt_bill_pk_csr%NOTFOUND;

314: l_qab_rec.currency_conversion_code,
315: l_qab_rec.currency_conversion_type,
316: l_qab_rec.currency_conversion_rate,
317: l_qab_rec.currency_conversion_date;
318: x_no_data_found := okl_txd_qte_antcpt_bill_pk_csr%NOTFOUND;
319: CLOSE okl_txd_qte_antcpt_bill_pk_csr;
320: RETURN(l_qab_rec);
321: END get_rec;
322:

Line 319: CLOSE okl_txd_qte_antcpt_bill_pk_csr;

315: l_qab_rec.currency_conversion_type,
316: l_qab_rec.currency_conversion_rate,
317: l_qab_rec.currency_conversion_date;
318: x_no_data_found := okl_txd_qte_antcpt_bill_pk_csr%NOTFOUND;
319: CLOSE okl_txd_qte_antcpt_bill_pk_csr;
320: RETURN(l_qab_rec);
321: END get_rec;
322:
323: ------------------------------------------------------------------

Line 352: -- FUNCTION null_out_defaults for: OKL_TXD_QTE_ANTCPT_BILL_V

348: BEGIN
349: RETURN(get_rec(p_qab_rec, l_row_not_found));
350: END get_rec;
351: ---------------------------------------------------------------------------
352: -- FUNCTION null_out_defaults for: OKL_TXD_QTE_ANTCPT_BILL_V
353: ---------------------------------------------------------------------------
354: FUNCTION null_out_defaults (
355: p_qabv_rec IN qabv_rec_type
356: ) RETURN qabv_rec_type IS

Line 824: -- Parameters : Record structure of OKL_TXD_QTE_ANTCPT_BILL_V table

820: -- Business Rules : If transaction currency <> functional currency, then
821: -- conversion columns are mandatory
822: -- Else If transaction currency = functional currency,
823: -- then conversion columns should all be NULL
824: -- Parameters : Record structure of OKL_TXD_QTE_ANTCPT_BILL_V table
825: -- Version : 1.0
826: -- History : 20-Sep-2004 rmunjulu :Added new procedure
827: -- End of comments
828: PROCEDURE validate_currency_record(p_qabv_rec IN qabv_rec_type,

Line 916: -- Parameters : Record structure of OKL_TXD_QTE_ANTCPT_BILL_V table

912: -- Start of comments
913: -- Procedure Name : validate_currency_code
914: -- Description : Validation of Currency Code
915: -- Business Rules :
916: -- Parameters : Record structure of OKL_TXD_QTE_ANTCPT_BILL_V table
917: -- Version : 1.0
918: -- History : 20-Sep-2004 rmunjulu :Added new procedure
919: -- End of comments
920: PROCEDURE validate_currency_code(p_qabv_rec IN qabv_rec_type,

Line 968: -- Parameters : Record structure of OKL_TXD_QTE_ANTCPT_BILL_V table

964: -- Start of comments
965: -- Procedure Name : validate_currency_con_code
966: -- Description : Validation of Currency Conversion Code
967: -- Business Rules :
968: -- Parameters : Record structure of OKL_TXD_QTE_ANTCPT_BILL_V table
969: -- Version : 1.0
970: -- History : 20-Sep-2004 rmunjulu :Added new procedure
971: -- End of comments
972: PROCEDURE validate_currency_con_code(p_qabv_rec IN qabv_rec_type,

Line 1020: -- Parameters : Record structure of OKL_TXD_QTE_ANTCPT_BILL_V table

1016: -- Start of comments
1017: -- Procedure Name : validate_currency_con_type
1018: -- Description : Validation of Currency Conversion type
1019: -- Business Rules :
1020: -- Parameters : Record structure of OKL_TXD_QTE_ANTCPT_BILL_V table
1021: -- Version : 1.0
1022: -- History : 20-Sep-2004 rmunjulu :Added new procedure
1023: -- End of comments
1024: PROCEDURE validate_currency_con_type(p_qabv_rec IN qabv_rec_type,

Line 1063: -- Parameters : Record structure of OKL_TXD_QTE_ANTCPT_BILL_V table

1059: -- Start of comments
1060: -- Procedure Name : validate_org_id
1061: -- Description : Validation of Org_Id
1062: -- Business Rules :
1063: -- Parameters : Record structure of OKL_TXD_QTE_ANTCPT_BILL_V table
1064: -- Version : 1.0
1065: -- History : 20-Sep-2004 rmunjulu :Added new procedure
1066: -- End of comments
1067: PROCEDURE validate_org_id(

Line 1117: -- Validate_Attributes for:OKL_TXD_QTE_ANTCPT_BILL_V --

1113: ---------------------------------------------------------------------------
1114: -- FUNCTION Validate_Attributes
1115: ---------------------------------------------------------------------------
1116: -------------------------------------------------------
1117: -- Validate_Attributes for:OKL_TXD_QTE_ANTCPT_BILL_V --
1118: -------------------------------------------------------
1119: FUNCTION Validate_Attributes (
1120: p_qabv_rec IN qabv_rec_type
1121: ) RETURN VARCHAR2 IS

Line 1242: -- Validate Record for:OKL_TXD_QTE_ANTCPT_BILL_V --

1238: ---------------------------------------------------------------------------
1239: -- PROCEDURE Validate_Record
1240: ---------------------------------------------------------------------------
1241: ---------------------------------------------------
1242: -- Validate Record for:OKL_TXD_QTE_ANTCPT_BILL_V --
1243: ---------------------------------------------------
1244: FUNCTION Validate_Record (
1245: p_qabv_rec IN qabv_rec_type,
1246: p_db_qabv_rec IN qabv_rec_type

Line 1375: -- validate_row for:OKL_TXD_QTE_ANTCPT_BILL_V --

1371: ---------------------------------------------------------------------------
1372: -- PROCEDURE validate_row
1373: ---------------------------------------------------------------------------
1374: ------------------------------------------------
1375: -- validate_row for:OKL_TXD_QTE_ANTCPT_BILL_V --
1376: ------------------------------------------------
1377: PROCEDURE validate_row(
1378: p_api_version IN NUMBER,
1379: p_init_msg_list IN VARCHAR2,

Line 1452: -- PL/SQL TBL validate_row for:OKL_TXD_QTE_ANTCPT_BILL_V --

1448: '_PVT'
1449: );
1450: END validate_row;
1451: -----------------------------------------------------------
1452: -- PL/SQL TBL validate_row for:OKL_TXD_QTE_ANTCPT_BILL_V --
1453: -----------------------------------------------------------
1454: PROCEDURE validate_row(
1455: p_api_version IN NUMBER,
1456: p_init_msg_list IN VARCHAR2,

Line 1548: -- PL/SQL TBL validate_row for:OKL_TXD_QTE_ANTCPT_BILL_V --

1544: );
1545: END validate_row;
1546:
1547: -----------------------------------------------------------
1548: -- PL/SQL TBL validate_row for:OKL_TXD_QTE_ANTCPT_BILL_V --
1549: -----------------------------------------------------------
1550: PROCEDURE validate_row(
1551: p_api_version IN NUMBER,
1552: p_init_msg_list IN VARCHAR2,

Line 1613: -- insert_row for:OKL_TXD_QTE_ANTCPT_BILL --

1609: ---------------------------------------------------------------------------
1610: -- PROCEDURE insert_row
1611: ---------------------------------------------------------------------------
1612: --------------------------------------------
1613: -- insert_row for:OKL_TXD_QTE_ANTCPT_BILL --
1614: --------------------------------------------
1615: PROCEDURE insert_row(
1616: p_init_msg_list IN VARCHAR2,
1617: x_return_status OUT NOCOPY VARCHAR2,

Line 1629: -- Set_Attributes for:OKL_TXD_QTE_ANTCPT_BILL --

1625: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1626: l_qab_rec qab_rec_type := p_qab_rec;
1627: l_def_qab_rec qab_rec_type;
1628: ------------------------------------------------
1629: -- Set_Attributes for:OKL_TXD_QTE_ANTCPT_BILL --
1630: ------------------------------------------------
1631: FUNCTION Set_Attributes (
1632: p_qab_rec IN qab_rec_type,
1633: x_qab_rec OUT NOCOPY qab_rec_type

Line 1660: INSERT INTO OKL_TXD_QTE_ANTCPT_BILL(

1656: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1657: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1658: RAISE OKC_API.G_EXCEPTION_ERROR;
1659: END IF;
1660: INSERT INTO OKL_TXD_QTE_ANTCPT_BILL(
1661: id,
1662: object_version_number,
1663: khr_id,
1664: qte_id,

Line 1777: -- insert_row for :OKL_TXD_QTE_ANTCPT_BILL_V -- rmunjulu added code to default some values

1773: '_PVT'
1774: );
1775: END insert_row;
1776: -----------------------------------------------
1777: -- insert_row for :OKL_TXD_QTE_ANTCPT_BILL_V -- rmunjulu added code to default some values
1778: -----------------------------------------------
1779: PROCEDURE insert_row(
1780: p_api_version IN NUMBER,
1781: p_init_msg_list IN VARCHAR2,

Line 1811: -- Set_Attributes for:OKL_TXD_QTE_ANTCPT_BILL_V --

1807: l_qabv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1808: RETURN(l_qabv_rec);
1809: END fill_who_columns;
1810: --------------------------------------------------
1811: -- Set_Attributes for:OKL_TXD_QTE_ANTCPT_BILL_V --
1812: --------------------------------------------------
1813: FUNCTION Set_Attributes (
1814: p_qabv_rec IN qabv_rec_type,
1815: x_qabv_rec OUT NOCOPY qabv_rec_type

Line 2107: -- lock_row for:OKL_TXD_QTE_ANTCPT_BILL --

2103: ---------------------------------------------------------------------------
2104: -- PROCEDURE lock_row
2105: ---------------------------------------------------------------------------
2106: ------------------------------------------
2107: -- lock_row for:OKL_TXD_QTE_ANTCPT_BILL --
2108: ------------------------------------------
2109: PROCEDURE lock_row(
2110: p_init_msg_list IN VARCHAR2,
2111: x_return_status OUT NOCOPY VARCHAR2,

Line 2120: FROM OKL_TXD_QTE_ANTCPT_BILL

2116: E_Resource_Busy EXCEPTION;
2117: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2118: CURSOR lock_csr (p_qab_rec IN qab_rec_type) IS
2119: SELECT OBJECT_VERSION_NUMBER
2120: FROM OKL_TXD_QTE_ANTCPT_BILL
2121: WHERE ID = p_qab_rec.id
2122: AND OBJECT_VERSION_NUMBER = p_qab_rec.object_version_number
2123: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2124:

Line 2127: FROM OKL_TXD_QTE_ANTCPT_BILL

2123: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2124:
2125: CURSOR lchk_csr (p_qab_rec IN qab_rec_type) IS
2126: SELECT OBJECT_VERSION_NUMBER
2127: FROM OKL_TXD_QTE_ANTCPT_BILL
2128: WHERE ID = p_qab_rec.id;
2129: l_api_version CONSTANT NUMBER := 1;
2130: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2131: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2132: l_object_version_number OKL_TXD_QTE_ANTCPT_BILL.OBJECT_VERSION_NUMBER%TYPE;

2128: WHERE ID = p_qab_rec.id;
2129: l_api_version CONSTANT NUMBER := 1;
2130: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2131: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2132: l_object_version_number OKL_TXD_QTE_ANTCPT_BILL.OBJECT_VERSION_NUMBER%TYPE;
2133: lc_object_version_number OKL_TXD_QTE_ANTCPT_BILL.OBJECT_VERSION_NUMBER%TYPE;
2134: l_row_notfound BOOLEAN := FALSE;
2135: lc_row_notfound BOOLEAN := FALSE;
2136: BEGIN

Line 2133: lc_object_version_number OKL_TXD_QTE_ANTCPT_BILL.OBJECT_VERSION_NUMBER%TYPE;

2129: l_api_version CONSTANT NUMBER := 1;
2130: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2131: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2132: l_object_version_number OKL_TXD_QTE_ANTCPT_BILL.OBJECT_VERSION_NUMBER%TYPE;
2133: lc_object_version_number OKL_TXD_QTE_ANTCPT_BILL.OBJECT_VERSION_NUMBER%TYPE;
2134: l_row_notfound BOOLEAN := FALSE;
2135: lc_row_notfound BOOLEAN := FALSE;
2136: BEGIN
2137: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2214: -- lock_row for: OKL_TXD_QTE_ANTCPT_BILL_V --

2210: '_PVT'
2211: );
2212: END lock_row;
2213: ---------------------------------------------
2214: -- lock_row for: OKL_TXD_QTE_ANTCPT_BILL_V --
2215: ---------------------------------------------
2216: PROCEDURE lock_row(
2217: p_api_version IN NUMBER,
2218: p_init_msg_list IN VARCHAR2,

Line 2454: -- update_row for:OKL_TXD_QTE_ANTCPT_BILL --

2450: ---------------------------------------------------------------------------
2451: -- PROCEDURE update_row
2452: ---------------------------------------------------------------------------
2453: --------------------------------------------
2454: -- update_row for:OKL_TXD_QTE_ANTCPT_BILL --
2455: --------------------------------------------
2456: PROCEDURE update_row(
2457: p_init_msg_list IN VARCHAR2,
2458: x_return_status OUT NOCOPY VARCHAR2,

Line 2646: -- Set_Attributes for:OKL_TXD_QTE_ANTCPT_BILL --

2642: END IF;
2643: RETURN(l_return_status);
2644: END populate_new_record;
2645: ------------------------------------------------
2646: -- Set_Attributes for:OKL_TXD_QTE_ANTCPT_BILL --
2647: ------------------------------------------------
2648: FUNCTION Set_Attributes (
2649: p_qab_rec IN qab_rec_type,
2650: x_qab_rec OUT NOCOPY qab_rec_type

Line 2684: UPDATE OKL_TXD_QTE_ANTCPT_BILL

2680: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2681: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2682: RAISE OKC_API.G_EXCEPTION_ERROR;
2683: END IF;
2684: UPDATE OKL_TXD_QTE_ANTCPT_BILL
2685: SET OBJECT_VERSION_NUMBER = l_def_qab_rec.object_version_number,
2686: KHR_ID = l_def_qab_rec.khr_id,
2687: QTE_ID = l_def_qab_rec.qte_id,
2688: KLE_ID = l_def_qab_rec.kle_id,

Line 2761: -- update_row for:OKL_TXD_QTE_ANTCPT_BILL_V --

2757: '_PVT'
2758: );
2759: END update_row;
2760: ----------------------------------------------
2761: -- update_row for:OKL_TXD_QTE_ANTCPT_BILL_V --
2762: ----------------------------------------------
2763: PROCEDURE update_row(
2764: p_api_version IN NUMBER,
2765: p_init_msg_list IN VARCHAR2,

Line 2966: -- Set_Attributes for:OKL_TXD_QTE_ANTCPT_BILL_V --

2962: END IF;
2963: RETURN(l_return_status);
2964: END populate_new_record;
2965: --------------------------------------------------
2966: -- Set_Attributes for:OKL_TXD_QTE_ANTCPT_BILL_V --
2967: --------------------------------------------------
2968: FUNCTION Set_Attributes (
2969: p_qabv_rec IN qabv_rec_type,
2970: x_qabv_rec OUT NOCOPY qabv_rec_type

Line 3260: -- delete_row for:OKL_TXD_QTE_ANTCPT_BILL --

3256: ---------------------------------------------------------------------------
3257: -- PROCEDURE delete_row
3258: ---------------------------------------------------------------------------
3259: --------------------------------------------
3260: -- delete_row for:OKL_TXD_QTE_ANTCPT_BILL --
3261: --------------------------------------------
3262: PROCEDURE delete_row(
3263: p_init_msg_list IN VARCHAR2,
3264: x_return_status OUT NOCOPY VARCHAR2,

Line 3285: DELETE FROM OKL_TXD_QTE_ANTCPT_BILL

3281: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3282: RAISE OKC_API.G_EXCEPTION_ERROR;
3283: END IF;
3284:
3285: DELETE FROM OKL_TXD_QTE_ANTCPT_BILL
3286: WHERE ID = p_qab_rec.id;
3287:
3288: x_return_status := l_return_status;
3289: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3323: -- delete_row for:OKL_TXD_QTE_ANTCPT_BILL_V --

3319: '_PVT'
3320: );
3321: END delete_row;
3322: ----------------------------------------------
3323: -- delete_row for:OKL_TXD_QTE_ANTCPT_BILL_V --
3324: ----------------------------------------------
3325: PROCEDURE delete_row(
3326: p_api_version IN NUMBER,
3327: p_init_msg_list IN VARCHAR2,

Line 3405: -- PL/SQL TBL delete_row for:OKL_TXD_QTE_ANTCPT_BILL_V --

3401: '_PVT'
3402: );
3403: END delete_row;
3404: ---------------------------------------------------------
3405: -- PL/SQL TBL delete_row for:OKL_TXD_QTE_ANTCPT_BILL_V --
3406: ---------------------------------------------------------
3407: PROCEDURE delete_row(
3408: p_api_version IN NUMBER,
3409: p_init_msg_list IN VARCHAR2,

Line 3501: -- PL/SQL TBL delete_row for:OKL_TXD_QTE_ANTCPT_BILL_V --

3497: );
3498: END delete_row;
3499:
3500: ---------------------------------------------------------
3501: -- PL/SQL TBL delete_row for:OKL_TXD_QTE_ANTCPT_BILL_V --
3502: ---------------------------------------------------------
3503: PROCEDURE delete_row(
3504: p_api_version IN NUMBER,
3505: p_init_msg_list IN VARCHAR2,