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_LDB_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 94: -- FUNCTION get_rec for: OKL_PARTY_PAYMENT_HDR_V

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

Line 100: CURSOR okl_party_payment_hdr_v_pk_csr (p_id IN NUMBER) IS

96: FUNCTION get_rec (
97: p_pphv_rec IN pphv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN pphv_rec_type IS
100: CURSOR okl_party_payment_hdr_v_pk_csr (p_id IN NUMBER) IS
101: SELECT
102: ID,
103: OBJECT_VERSION_NUMBER,
104: DNZ_CHR_ID,

Line 119: FROM Okl_Party_Payment_Hdr_V

115: CREATION_DATE,
116: LAST_UPDATED_BY,
117: LAST_UPDATE_DATE,
118: LAST_UPDATE_LOGIN
119: FROM Okl_Party_Payment_Hdr_V
120: WHERE okl_party_payment_hdr_v.id = p_id;
121: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;
122: l_pphv_rec pphv_rec_type;
123: BEGIN

Line 120: WHERE okl_party_payment_hdr_v.id = p_id;

116: LAST_UPDATED_BY,
117: LAST_UPDATE_DATE,
118: LAST_UPDATE_LOGIN
119: FROM Okl_Party_Payment_Hdr_V
120: WHERE okl_party_payment_hdr_v.id = p_id;
121: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;
122: l_pphv_rec pphv_rec_type;
123: BEGIN
124: x_no_data_found := TRUE;

Line 121: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;

117: LAST_UPDATE_DATE,
118: LAST_UPDATE_LOGIN
119: FROM Okl_Party_Payment_Hdr_V
120: WHERE okl_party_payment_hdr_v.id = p_id;
121: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;
122: l_pphv_rec pphv_rec_type;
123: BEGIN
124: x_no_data_found := TRUE;
125: -- Get current database values

Line 126: OPEN okl_party_payment_hdr_v_pk_csr (p_pphv_rec.id);

122: l_pphv_rec pphv_rec_type;
123: BEGIN
124: x_no_data_found := TRUE;
125: -- Get current database values
126: OPEN okl_party_payment_hdr_v_pk_csr (p_pphv_rec.id);
127: FETCH okl_party_payment_hdr_v_pk_csr INTO
128: l_pphv_rec.id,
129: l_pphv_rec.object_version_number,
130: l_pphv_rec.dnz_chr_id,

Line 127: FETCH okl_party_payment_hdr_v_pk_csr INTO

123: BEGIN
124: x_no_data_found := TRUE;
125: -- Get current database values
126: OPEN okl_party_payment_hdr_v_pk_csr (p_pphv_rec.id);
127: FETCH okl_party_payment_hdr_v_pk_csr INTO
128: l_pphv_rec.id,
129: l_pphv_rec.object_version_number,
130: l_pphv_rec.dnz_chr_id,
131: l_pphv_rec.cle_id,

Line 145: x_no_data_found := okl_party_payment_hdr_v_pk_csr%NOTFOUND;

141: l_pphv_rec.creation_date,
142: l_pphv_rec.last_updated_by,
143: l_pphv_rec.last_update_date,
144: l_pphv_rec.last_update_login;
145: x_no_data_found := okl_party_payment_hdr_v_pk_csr%NOTFOUND;
146: CLOSE okl_party_payment_hdr_v_pk_csr;
147: RETURN(l_pphv_rec);
148: END get_rec;
149:

Line 146: CLOSE okl_party_payment_hdr_v_pk_csr;

142: l_pphv_rec.last_updated_by,
143: l_pphv_rec.last_update_date,
144: l_pphv_rec.last_update_login;
145: x_no_data_found := okl_party_payment_hdr_v_pk_csr%NOTFOUND;
146: CLOSE okl_party_payment_hdr_v_pk_csr;
147: RETURN(l_pphv_rec);
148: END get_rec;
149:
150: ------------------------------------------------------------------

Line 179: -- FUNCTION get_rec for: OKL_PARTY_PAYMENT_HDR

175: BEGIN
176: RETURN(get_rec(p_pphv_rec, l_row_not_found));
177: END get_rec;
178: ---------------------------------------------------------------------------
179: -- FUNCTION get_rec for: OKL_PARTY_PAYMENT_HDR
180: ---------------------------------------------------------------------------
181: FUNCTION get_rec (
182: p_pph_rec IN pph_rec_type,
183: x_no_data_found OUT NOCOPY BOOLEAN

Line 185: CURSOR okl_party_payment_hdr_pk_csr (p_id IN NUMBER) IS

181: FUNCTION get_rec (
182: p_pph_rec IN pph_rec_type,
183: x_no_data_found OUT NOCOPY BOOLEAN
184: ) RETURN pph_rec_type IS
185: CURSOR okl_party_payment_hdr_pk_csr (p_id IN NUMBER) IS
186: SELECT
187: ID,
188: OBJECT_VERSION_NUMBER,
189: DNZ_CHR_ID,

Line 204: FROM Okl_Party_Payment_Hdr

200: CREATION_DATE,
201: LAST_UPDATED_BY,
202: LAST_UPDATE_DATE,
203: LAST_UPDATE_LOGIN
204: FROM Okl_Party_Payment_Hdr
205: WHERE okl_party_payment_hdr.id = p_id;
206: l_okl_party_payment_hdr_pk okl_party_payment_hdr_pk_csr%ROWTYPE;
207: l_pph_rec pph_rec_type;
208: BEGIN

Line 205: WHERE okl_party_payment_hdr.id = p_id;

201: LAST_UPDATED_BY,
202: LAST_UPDATE_DATE,
203: LAST_UPDATE_LOGIN
204: FROM Okl_Party_Payment_Hdr
205: WHERE okl_party_payment_hdr.id = p_id;
206: l_okl_party_payment_hdr_pk okl_party_payment_hdr_pk_csr%ROWTYPE;
207: l_pph_rec pph_rec_type;
208: BEGIN
209: x_no_data_found := TRUE;

Line 206: l_okl_party_payment_hdr_pk okl_party_payment_hdr_pk_csr%ROWTYPE;

202: LAST_UPDATE_DATE,
203: LAST_UPDATE_LOGIN
204: FROM Okl_Party_Payment_Hdr
205: WHERE okl_party_payment_hdr.id = p_id;
206: l_okl_party_payment_hdr_pk okl_party_payment_hdr_pk_csr%ROWTYPE;
207: l_pph_rec pph_rec_type;
208: BEGIN
209: x_no_data_found := TRUE;
210: -- Get current database values

Line 211: OPEN okl_party_payment_hdr_pk_csr (p_pph_rec.id);

207: l_pph_rec pph_rec_type;
208: BEGIN
209: x_no_data_found := TRUE;
210: -- Get current database values
211: OPEN okl_party_payment_hdr_pk_csr (p_pph_rec.id);
212: FETCH okl_party_payment_hdr_pk_csr INTO
213: l_pph_rec.id,
214: l_pph_rec.object_version_number,
215: l_pph_rec.dnz_chr_id,

Line 212: FETCH okl_party_payment_hdr_pk_csr INTO

208: BEGIN
209: x_no_data_found := TRUE;
210: -- Get current database values
211: OPEN okl_party_payment_hdr_pk_csr (p_pph_rec.id);
212: FETCH okl_party_payment_hdr_pk_csr INTO
213: l_pph_rec.id,
214: l_pph_rec.object_version_number,
215: l_pph_rec.dnz_chr_id,
216: l_pph_rec.cle_id,

Line 230: x_no_data_found := okl_party_payment_hdr_pk_csr%NOTFOUND;

226: l_pph_rec.creation_date,
227: l_pph_rec.last_updated_by,
228: l_pph_rec.last_update_date,
229: l_pph_rec.last_update_login;
230: x_no_data_found := okl_party_payment_hdr_pk_csr%NOTFOUND;
231: CLOSE okl_party_payment_hdr_pk_csr;
232: RETURN(l_pph_rec);
233: END get_rec;
234:

Line 231: CLOSE okl_party_payment_hdr_pk_csr;

227: l_pph_rec.last_updated_by,
228: l_pph_rec.last_update_date,
229: l_pph_rec.last_update_login;
230: x_no_data_found := okl_party_payment_hdr_pk_csr%NOTFOUND;
231: CLOSE okl_party_payment_hdr_pk_csr;
232: RETURN(l_pph_rec);
233: END get_rec;
234:
235: ------------------------------------------------------------------

Line 264: -- FUNCTION null_out_defaults for: OKL_PARTY_PAYMENT_HDR_V

260: BEGIN
261: RETURN(get_rec(p_pph_rec, l_row_not_found));
262: END get_rec;
263: ---------------------------------------------------------------------------
264: -- FUNCTION null_out_defaults for: OKL_PARTY_PAYMENT_HDR_V
265: ---------------------------------------------------------------------------
266: FUNCTION null_out_defaults (
267: p_pphv_rec IN pphv_rec_type
268: ) RETURN pphv_rec_type IS

Line 519: -- Validate_Attributes for:OKL_PARTY_PAYMENT_HDR_V --

515: ---------------------------------------------------------------------------
516: -- FUNCTION Validate_Attributes
517: ---------------------------------------------------------------------------
518: -----------------------------------------------------
519: -- Validate_Attributes for:OKL_PARTY_PAYMENT_HDR_V --
520: -----------------------------------------------------
521: FUNCTION Validate_Attributes (
522: p_pphv_rec IN pphv_rec_type
523: ) RETURN VARCHAR2 IS

Line 584: -- Validate Record for:OKL_PARTY_PAYMENT_HDR_V --

580: ---------------------------------------------------------------------------
581: -- PROCEDURE Validate_Record
582: ---------------------------------------------------------------------------
583: -------------------------------------------------
584: -- Validate Record for:OKL_PARTY_PAYMENT_HDR_V --
585: -------------------------------------------------
586: FUNCTION Validate_Record (
587: p_pphv_rec IN pphv_rec_type,
588: p_db_pphv_rec IN pphv_rec_type

Line 659: -- validate_row for:OKL_PARTY_PAYMENT_HDR_V --

655: ---------------------------------------------------------------------------
656: -- PROCEDURE validate_row
657: ---------------------------------------------------------------------------
658: ----------------------------------------------
659: -- validate_row for:OKL_PARTY_PAYMENT_HDR_V --
660: ----------------------------------------------
661: PROCEDURE validate_row(
662: p_api_version IN NUMBER,
663: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 736: -- PL/SQL TBL validate_row for:OKL_PARTY_PAYMENT_HDR_V --

732: '_PVT'
733: );
734: END validate_row;
735: ---------------------------------------------------------
736: -- PL/SQL TBL validate_row for:OKL_PARTY_PAYMENT_HDR_V --
737: ---------------------------------------------------------
738: PROCEDURE validate_row(
739: p_api_version IN NUMBER,
740: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 832: -- PL/SQL TBL validate_row for:OKL_PARTY_PAYMENT_HDR_V --

828: );
829: END validate_row;
830:
831: ---------------------------------------------------------
832: -- PL/SQL TBL validate_row for:OKL_PARTY_PAYMENT_HDR_V --
833: ---------------------------------------------------------
834: PROCEDURE validate_row(
835: p_api_version IN NUMBER,
836: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 897: -- insert_row for:OKL_PARTY_PAYMENT_HDR --

893: ---------------------------------------------------------------------------
894: -- PROCEDURE insert_row
895: ---------------------------------------------------------------------------
896: ------------------------------------------
897: -- insert_row for:OKL_PARTY_PAYMENT_HDR --
898: ------------------------------------------
899: PROCEDURE insert_row(
900: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
901: x_return_status OUT NOCOPY VARCHAR2,

Line 913: -- Set_Attributes for:OKL_PARTY_PAYMENT_HDR --

909: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
910: l_pph_rec pph_rec_type := p_pph_rec;
911: l_def_pph_rec pph_rec_type;
912: ----------------------------------------------
913: -- Set_Attributes for:OKL_PARTY_PAYMENT_HDR --
914: ----------------------------------------------
915: FUNCTION Set_Attributes (
916: p_pph_rec IN pph_rec_type,
917: x_pph_rec OUT NOCOPY pph_rec_type

Line 950: INSERT INTO OKL_PARTY_PAYMENT_HDR(

946: SELECT start_date INTO l_pph_rec.effective_from
947: FROM okc_k_headers_b
948: WHERE id = l_pph_rec.dnz_chr_id;
949:
950: INSERT INTO OKL_PARTY_PAYMENT_HDR(
951: id,
952: object_version_number,
953: dnz_chr_id,
954: cle_id,

Line 1023: -- insert_row for :OKL_PARTY_PAYMENT_HDR_V --

1019: '_PVT'
1020: );
1021: END insert_row;
1022: ---------------------------------------------
1023: -- insert_row for :OKL_PARTY_PAYMENT_HDR_V --
1024: ---------------------------------------------
1025: PROCEDURE insert_row(
1026: p_api_version IN NUMBER,
1027: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1057: -- Set_Attributes for:OKL_PARTY_PAYMENT_HDR_V --

1053: l_pphv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1054: RETURN(l_pphv_rec);
1055: END fill_who_columns;
1056: ------------------------------------------------
1057: -- Set_Attributes for:OKL_PARTY_PAYMENT_HDR_V --
1058: ------------------------------------------------
1059: FUNCTION Set_Attributes (
1060: p_pphv_rec IN pphv_rec_type,
1061: x_pphv_rec OUT NOCOPY pphv_rec_type

Line 1333: -- lock_row for:OKL_PARTY_PAYMENT_HDR --

1329: ---------------------------------------------------------------------------
1330: -- PROCEDURE lock_row
1331: ---------------------------------------------------------------------------
1332: ----------------------------------------
1333: -- lock_row for:OKL_PARTY_PAYMENT_HDR --
1334: ----------------------------------------
1335: PROCEDURE lock_row(
1336: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1337: x_return_status OUT NOCOPY VARCHAR2,

Line 1346: FROM OKL_PARTY_PAYMENT_HDR

1342: E_Resource_Busy EXCEPTION;
1343: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1344: CURSOR lock_csr (p_pph_rec IN pph_rec_type) IS
1345: SELECT OBJECT_VERSION_NUMBER
1346: FROM OKL_PARTY_PAYMENT_HDR
1347: WHERE ID = p_pph_rec.id
1348: AND OBJECT_VERSION_NUMBER = p_pph_rec.object_version_number
1349: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1350:

Line 1353: FROM OKL_PARTY_PAYMENT_HDR

1349: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1350:
1351: CURSOR lchk_csr (p_pph_rec IN pph_rec_type) IS
1352: SELECT OBJECT_VERSION_NUMBER
1353: FROM OKL_PARTY_PAYMENT_HDR
1354: WHERE ID = p_pph_rec.id;
1355: l_api_version CONSTANT NUMBER := 1;
1356: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1358: l_object_version_number OKL_PARTY_PAYMENT_HDR.OBJECT_VERSION_NUMBER%TYPE;

1354: WHERE ID = p_pph_rec.id;
1355: l_api_version CONSTANT NUMBER := 1;
1356: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1358: l_object_version_number OKL_PARTY_PAYMENT_HDR.OBJECT_VERSION_NUMBER%TYPE;
1359: lc_object_version_number OKL_PARTY_PAYMENT_HDR.OBJECT_VERSION_NUMBER%TYPE;
1360: l_row_notfound BOOLEAN := FALSE;
1361: lc_row_notfound BOOLEAN := FALSE;
1362: BEGIN

Line 1359: lc_object_version_number OKL_PARTY_PAYMENT_HDR.OBJECT_VERSION_NUMBER%TYPE;

1355: l_api_version CONSTANT NUMBER := 1;
1356: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1358: l_object_version_number OKL_PARTY_PAYMENT_HDR.OBJECT_VERSION_NUMBER%TYPE;
1359: lc_object_version_number OKL_PARTY_PAYMENT_HDR.OBJECT_VERSION_NUMBER%TYPE;
1360: l_row_notfound BOOLEAN := FALSE;
1361: lc_row_notfound BOOLEAN := FALSE;
1362: BEGIN
1363: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1440: -- lock_row for: OKL_PARTY_PAYMENT_HDR_V --

1436: '_PVT'
1437: );
1438: END lock_row;
1439: -------------------------------------------
1440: -- lock_row for: OKL_PARTY_PAYMENT_HDR_V --
1441: -------------------------------------------
1442: PROCEDURE lock_row(
1443: p_api_version IN NUMBER,
1444: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1680: -- update_row for:OKL_PARTY_PAYMENT_HDR --

1676: ---------------------------------------------------------------------------
1677: -- PROCEDURE update_row
1678: ---------------------------------------------------------------------------
1679: ------------------------------------------
1680: -- update_row for:OKL_PARTY_PAYMENT_HDR --
1681: ------------------------------------------
1682: PROCEDURE update_row(
1683: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1684: x_return_status OUT NOCOPY VARCHAR2,

Line 1781: -- Set_Attributes for:OKL_PARTY_PAYMENT_HDR --

1777: END IF;
1778: RETURN(l_return_status);
1779: END populate_new_record;
1780: ----------------------------------------------
1781: -- Set_Attributes for:OKL_PARTY_PAYMENT_HDR --
1782: ----------------------------------------------
1783: FUNCTION Set_Attributes (
1784: p_pph_rec IN pph_rec_type,
1785: x_pph_rec OUT NOCOPY pph_rec_type

Line 1818: UPDATE OKL_PARTY_PAYMENT_HDR

1814: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1815: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1816: RAISE OKC_API.G_EXCEPTION_ERROR;
1817: END IF;
1818: UPDATE OKL_PARTY_PAYMENT_HDR
1819: SET OBJECT_VERSION_NUMBER = l_def_pph_rec.object_version_number,
1820: DNZ_CHR_ID = l_def_pph_rec.dnz_chr_id,
1821: CLE_ID = l_def_pph_rec.cle_id,
1822: PPL_ID = l_def_pph_rec.ppl_id,

Line 1873: -- update_row for:OKL_PARTY_PAYMENT_HDR_V --

1869: '_PVT'
1870: );
1871: END update_row;
1872: --------------------------------------------
1873: -- update_row for:OKL_PARTY_PAYMENT_HDR_V --
1874: --------------------------------------------
1875: PROCEDURE update_row(
1876: p_api_version IN NUMBER,
1877: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1993: -- Set_Attributes for:OKL_PARTY_PAYMENT_HDR_V --

1989: END IF;
1990: RETURN(l_return_status);
1991: END populate_new_record;
1992: ------------------------------------------------
1993: -- Set_Attributes for:OKL_PARTY_PAYMENT_HDR_V --
1994: ------------------------------------------------
1995: FUNCTION Set_Attributes (
1996: p_pphv_rec IN pphv_rec_type,
1997: x_pphv_rec OUT NOCOPY pphv_rec_type

Line 2286: -- delete_row for:OKL_PARTY_PAYMENT_HDR --

2282: ---------------------------------------------------------------------------
2283: -- PROCEDURE delete_row
2284: ---------------------------------------------------------------------------
2285: ------------------------------------------
2286: -- delete_row for:OKL_PARTY_PAYMENT_HDR --
2287: ------------------------------------------
2288: PROCEDURE delete_row(
2289: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2290: x_return_status OUT NOCOPY VARCHAR2,

Line 2311: DELETE FROM OKL_PARTY_PAYMENT_HDR

2307: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2308: RAISE OKC_API.G_EXCEPTION_ERROR;
2309: END IF;
2310:
2311: DELETE FROM OKL_PARTY_PAYMENT_HDR
2312: WHERE ID = p_pph_rec.id;
2313:
2314: x_return_status := l_return_status;
2315: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2349: -- delete_row for:OKL_PARTY_PAYMENT_HDR_V --

2345: '_PVT'
2346: );
2347: END delete_row;
2348: --------------------------------------------
2349: -- delete_row for:OKL_PARTY_PAYMENT_HDR_V --
2350: --------------------------------------------
2351: PROCEDURE delete_row(
2352: p_api_version IN NUMBER,
2353: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2431: -- PL/SQL TBL delete_row for:OKL_PARTY_PAYMENT_HDR_V --

2427: '_PVT'
2428: );
2429: END delete_row;
2430: -------------------------------------------------------
2431: -- PL/SQL TBL delete_row for:OKL_PARTY_PAYMENT_HDR_V --
2432: -------------------------------------------------------
2433: PROCEDURE delete_row(
2434: p_api_version IN NUMBER,
2435: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2527: -- PL/SQL TBL delete_row for:OKL_PARTY_PAYMENT_HDR_V --

2523: );
2524: END delete_row;
2525:
2526: -------------------------------------------------------
2527: -- PL/SQL TBL delete_row for:OKL_PARTY_PAYMENT_HDR_V --
2528: -------------------------------------------------------
2529: PROCEDURE delete_row(
2530: p_api_version IN NUMBER,
2531: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2599: INSERT INTO OKL_PARTY_PAYMENT_HDR_H

2595:
2596: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2597:
2598: BEGIN
2599: INSERT INTO OKL_PARTY_PAYMENT_HDR_H
2600: (
2601: ID,
2602: DNZ_CHR_ID,
2603: CLE_ID,

Line 2637: FROM okl_party_payment_hdr

2633: LAST_UPDATED_BY,
2634: LAST_UPDATE_DATE,
2635: LAST_UPDATE_LOGIN,
2636: p_major_version
2637: FROM okl_party_payment_hdr
2638: WHERE dnz_chr_id = p_chr_id;
2639:
2640: RETURN l_return_status;
2641: EXCEPTION

Line 2667: INSERT INTO OKL_PARTY_PAYMENT_HDR

2663:
2664: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2665:
2666: BEGIN
2667: INSERT INTO OKL_PARTY_PAYMENT_HDR
2668: (
2669: ID,
2670: DNZ_CHR_ID,
2671: CLE_ID,

Line 2705: FROM OKL_PARTY_PAYMENT_HDR_H

2701: CREATION_DATE,
2702: LAST_UPDATED_BY,
2703: LAST_UPDATE_DATE,
2704: LAST_UPDATE_LOGIN
2705: FROM OKL_PARTY_PAYMENT_HDR_H
2706: WHERE dnz_chr_id = p_chr_id and major_version = p_major_version;
2707:
2708: RETURN l_return_status;
2709: EXCEPTION