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.OKC_CPR_PVT dependencies on OKC_CHANGE_PARTY_ROLE

Line 45: -- FUNCTION get_rec for: OKC_CHANGE_PARTY_ROLE

41: null;
42: END api_copy;
43:
44: ---------------------------------------------------------------------------
45: -- FUNCTION get_rec for: OKC_CHANGE_PARTY_ROLE
46: ---------------------------------------------------------------------------
47: FUNCTION get_rec (
48: p_cpr_rec IN cpr_rec_type,
49: x_no_data_found OUT NOCOPY BOOLEAN

Line 63: FROM Okc_Change_Party_Role

59: LAST_UPDATED_BY,
60: LAST_UPDATE_DATE,
61: ACCEPTANCE_DATE,
62: LAST_UPDATE_LOGIN
63: FROM Okc_Change_Party_Role
64: WHERE okc_change_party_role.crt_id = p_crt_id
65: AND okc_change_party_role.cpl_id = p_cpl_id;
66: l_cpr_pk cpr_pk_csr%ROWTYPE;
67: l_cpr_rec cpr_rec_type;

Line 64: WHERE okc_change_party_role.crt_id = p_crt_id

60: LAST_UPDATE_DATE,
61: ACCEPTANCE_DATE,
62: LAST_UPDATE_LOGIN
63: FROM Okc_Change_Party_Role
64: WHERE okc_change_party_role.crt_id = p_crt_id
65: AND okc_change_party_role.cpl_id = p_cpl_id;
66: l_cpr_pk cpr_pk_csr%ROWTYPE;
67: l_cpr_rec cpr_rec_type;
68: BEGIN

Line 65: AND okc_change_party_role.cpl_id = p_cpl_id;

61: ACCEPTANCE_DATE,
62: LAST_UPDATE_LOGIN
63: FROM Okc_Change_Party_Role
64: WHERE okc_change_party_role.crt_id = p_crt_id
65: AND okc_change_party_role.cpl_id = p_cpl_id;
66: l_cpr_pk cpr_pk_csr%ROWTYPE;
67: l_cpr_rec cpr_rec_type;
68: BEGIN
69: x_no_data_found := TRUE;

Line 96: -- FUNCTION get_rec for: OKC_CHANGE_PARTY_ROLE_V

92: BEGIN
93: RETURN(get_rec(p_cpr_rec, l_row_notfound));
94: END get_rec;
95: ---------------------------------------------------------------------------
96: -- FUNCTION get_rec for: OKC_CHANGE_PARTY_ROLE_V
97: ---------------------------------------------------------------------------
98: FUNCTION get_rec (
99: p_cprv_rec IN cprv_rec_type,
100: x_no_data_found OUT NOCOPY BOOLEAN

Line 114: FROM Okc_Change_Party_Role_V

110: CREATION_DATE,
111: LAST_UPDATED_BY,
112: LAST_UPDATE_DATE,
113: LAST_UPDATE_LOGIN
114: FROM Okc_Change_Party_Role_V
115: WHERE okc_change_party_role_v.crt_id = p_crt_id
116: AND okc_change_party_role_v.cpl_id = p_cpl_id;
117: l_okc_cprv_pk okc_cprv_pk_csr%ROWTYPE;
118: l_cprv_rec cprv_rec_type;

Line 115: WHERE okc_change_party_role_v.crt_id = p_crt_id

111: LAST_UPDATED_BY,
112: LAST_UPDATE_DATE,
113: LAST_UPDATE_LOGIN
114: FROM Okc_Change_Party_Role_V
115: WHERE okc_change_party_role_v.crt_id = p_crt_id
116: AND okc_change_party_role_v.cpl_id = p_cpl_id;
117: l_okc_cprv_pk okc_cprv_pk_csr%ROWTYPE;
118: l_cprv_rec cprv_rec_type;
119: BEGIN

Line 116: AND okc_change_party_role_v.cpl_id = p_cpl_id;

112: LAST_UPDATE_DATE,
113: LAST_UPDATE_LOGIN
114: FROM Okc_Change_Party_Role_V
115: WHERE okc_change_party_role_v.crt_id = p_crt_id
116: AND okc_change_party_role_v.cpl_id = p_cpl_id;
117: l_okc_cprv_pk okc_cprv_pk_csr%ROWTYPE;
118: l_cprv_rec cprv_rec_type;
119: BEGIN
120: x_no_data_found := TRUE;

Line 148: -- FUNCTION null_out_defaults for: OKC_CHANGE_PARTY_ROLE_V --

144: RETURN(get_rec(p_cprv_rec, l_row_notfound));
145: END get_rec;
146:
147: -------------------------------------------------------------
148: -- FUNCTION null_out_defaults for: OKC_CHANGE_PARTY_ROLE_V --
149: -------------------------------------------------------------
150: FUNCTION null_out_defaults (
151: p_cprv_rec IN cprv_rec_type
152: ) RETURN cprv_rec_type IS

Line 292: -- Validate_Attributes for:OKC_CHANGE_PARTY_ROLE_V --

288: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
289: end validate_crt_id;
290: /*+++++++++++++End of hand code +++++++++++++++++++*/
291: -----------------------------------------------------
292: -- Validate_Attributes for:OKC_CHANGE_PARTY_ROLE_V --
293: -----------------------------------------------------
294: FUNCTION Validate_Attributes (
295: p_cprv_rec IN cprv_rec_type
296: ) RETURN VARCHAR2 IS

Line 361: -- Validate_Record for:OKC_CHANGE_PARTY_ROLE_V --

357: ---------------------------------------------------------------------------
358: -- PROCEDURE Validate_Record
359: ---------------------------------------------------------------------------
360: -------------------------------------------------
361: -- Validate_Record for:OKC_CHANGE_PARTY_ROLE_V --
362: -------------------------------------------------
363: FUNCTION Validate_Record (
364: p_cprv_rec IN cprv_rec_type
365: --+++++++++++++++Start handcode +++++++++++++++++++++++++++++++++++

Line 451: select '!' from okc_change_party_role

447: ---------------End of the commented code-----------*/
448: /*+++++++++++++Start of hand code +++++++++++++++++*/
449: x_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
450: cursor pk_csr is
451: select '!' from okc_change_party_role
452: where cpl_id = p_cprv_rec.cpl_id
453: and crt_id = p_cprv_rec.crt_id;
454: l_dummy varchar2(1) := '?';
455: BEGIN

Line 530: -- validate_row for:OKC_CHANGE_PARTY_ROLE_V --

526: ---------------------------------------------------------------------------
527: -- PROCEDURE validate_row
528: ---------------------------------------------------------------------------
529: ----------------------------------------------
530: -- validate_row for:OKC_CHANGE_PARTY_ROLE_V --
531: ----------------------------------------------
532: PROCEDURE validate_row(
533: p_api_version IN NUMBER,
534: p_init_msg_list IN VARCHAR2 ,

Line 674: -- insert_row for:OKC_CHANGE_PARTY_ROLE --

670: ---------------------------------------------------------------------------
671: -- PROCEDURE insert_row
672: ---------------------------------------------------------------------------
673: ------------------------------------------
674: -- insert_row for:OKC_CHANGE_PARTY_ROLE --
675: ------------------------------------------
676: PROCEDURE insert_row(
677: p_init_msg_list IN VARCHAR2 ,
678: x_return_status OUT NOCOPY VARCHAR2,

Line 690: -- Set_Attributes for:OKC_CHANGE_PARTY_ROLE --

686: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
687: l_cpr_rec cpr_rec_type := p_cpr_rec;
688: l_def_cpr_rec cpr_rec_type;
689: ----------------------------------------------
690: -- Set_Attributes for:OKC_CHANGE_PARTY_ROLE --
691: ----------------------------------------------
692: FUNCTION Set_Attributes (
693: p_cpr_rec IN cpr_rec_type,
694: x_cpr_rec OUT NOCOPY cpr_rec_type

Line 721: INSERT INTO OKC_CHANGE_PARTY_ROLE(

717: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
718: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
719: RAISE OKC_API.G_EXCEPTION_ERROR;
720: END IF;
721: INSERT INTO OKC_CHANGE_PARTY_ROLE(
722: crt_id,
723: cpl_id,
724: object_version_number,
725: created_by,

Line 777: -- insert_row for:OKC_CHANGE_PARTY_ROLE_V --

773: '_PVT'
774: );
775: END insert_row;
776: --------------------------------------------
777: -- insert_row for:OKC_CHANGE_PARTY_ROLE_V --
778: --------------------------------------------
779: PROCEDURE insert_row(
780: p_api_version IN NUMBER,
781: p_init_msg_list IN VARCHAR2 ,

Line 811: -- Set_Attributes for:OKC_CHANGE_PARTY_ROLE_V --

807: l_cprv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
808: RETURN(l_cprv_rec);
809: END fill_who_columns;
810: ------------------------------------------------
811: -- Set_Attributes for:OKC_CHANGE_PARTY_ROLE_V --
812: ------------------------------------------------
813: FUNCTION Set_Attributes (
814: p_cprv_rec IN cprv_rec_type,
815: x_cprv_rec OUT NOCOPY cprv_rec_type

Line 994: -- lock_row for:OKC_CHANGE_PARTY_ROLE --

990: ---------------------------------------------------------------------------
991: -- PROCEDURE lock_row
992: ---------------------------------------------------------------------------
993: ----------------------------------------
994: -- lock_row for:OKC_CHANGE_PARTY_ROLE --
995: ----------------------------------------
996: PROCEDURE lock_row(
997: p_init_msg_list IN VARCHAR2 ,
998: x_return_status OUT NOCOPY VARCHAR2,

Line 1007: FROM OKC_CHANGE_PARTY_ROLE

1003: E_Resource_Busy EXCEPTION;
1004: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1005: CURSOR lock_csr (p_cpr_rec IN cpr_rec_type) IS
1006: SELECT OBJECT_VERSION_NUMBER
1007: FROM OKC_CHANGE_PARTY_ROLE
1008: WHERE CRT_ID = p_cpr_rec.crt_id
1009: AND CPL_ID = p_cpr_rec.cpl_id
1010: AND OBJECT_VERSION_NUMBER = p_cpr_rec.object_version_number
1011: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 1015: FROM OKC_CHANGE_PARTY_ROLE

1011: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1012:
1013: CURSOR lchk_csr (p_cpr_rec IN cpr_rec_type) IS
1014: SELECT OBJECT_VERSION_NUMBER
1015: FROM OKC_CHANGE_PARTY_ROLE
1016: WHERE CRT_ID = p_cpr_rec.crt_id
1017: AND CPL_ID = p_cpr_rec.cpl_id;
1018: l_api_version CONSTANT NUMBER := 1;
1019: l_api_name CONSTANT VARCHAR2(30) := 'ROLE_lock_row';

Line 1021: l_object_version_number OKC_CHANGE_PARTY_ROLE.OBJECT_VERSION_NUMBER%TYPE;

1017: AND CPL_ID = p_cpr_rec.cpl_id;
1018: l_api_version CONSTANT NUMBER := 1;
1019: l_api_name CONSTANT VARCHAR2(30) := 'ROLE_lock_row';
1020: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1021: l_object_version_number OKC_CHANGE_PARTY_ROLE.OBJECT_VERSION_NUMBER%TYPE;
1022: lc_object_version_number OKC_CHANGE_PARTY_ROLE.OBJECT_VERSION_NUMBER%TYPE;
1023: l_row_notfound BOOLEAN := FALSE;
1024: lc_row_notfound BOOLEAN := FALSE;
1025: BEGIN

Line 1022: lc_object_version_number OKC_CHANGE_PARTY_ROLE.OBJECT_VERSION_NUMBER%TYPE;

1018: l_api_version CONSTANT NUMBER := 1;
1019: l_api_name CONSTANT VARCHAR2(30) := 'ROLE_lock_row';
1020: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1021: l_object_version_number OKC_CHANGE_PARTY_ROLE.OBJECT_VERSION_NUMBER%TYPE;
1022: lc_object_version_number OKC_CHANGE_PARTY_ROLE.OBJECT_VERSION_NUMBER%TYPE;
1023: l_row_notfound BOOLEAN := FALSE;
1024: lc_row_notfound BOOLEAN := FALSE;
1025: BEGIN
1026: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1102: -- lock_row for:OKC_CHANGE_PARTY_ROLE_V --

1098: '_PVT'
1099: );
1100: END lock_row;
1101: ------------------------------------------
1102: -- lock_row for:OKC_CHANGE_PARTY_ROLE_V --
1103: ------------------------------------------
1104: PROCEDURE lock_row(
1105: p_api_version IN NUMBER,
1106: p_init_msg_list IN VARCHAR2 ,

Line 1250: -- update_row for:OKC_CHANGE_PARTY_ROLE --

1246: ---------------------------------------------------------------------------
1247: -- PROCEDURE update_row
1248: ---------------------------------------------------------------------------
1249: ------------------------------------------
1250: -- update_row for:OKC_CHANGE_PARTY_ROLE --
1251: ------------------------------------------
1252: PROCEDURE update_row(
1253: p_init_msg_list IN VARCHAR2 ,
1254: x_return_status OUT NOCOPY VARCHAR2,

Line 1322: -- Set_Attributes for:OKC_CHANGE_PARTY_ROLE --

1318: END IF;
1319: RETURN(l_return_status);
1320: END populate_new_record;
1321: ----------------------------------------------
1322: -- Set_Attributes for:OKC_CHANGE_PARTY_ROLE --
1323: ----------------------------------------------
1324: FUNCTION Set_Attributes (
1325: p_cpr_rec IN cpr_rec_type,
1326: x_cpr_rec OUT NOCOPY cpr_rec_type

Line 1359: UPDATE OKC_CHANGE_PARTY_ROLE

1355: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1356: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1357: RAISE OKC_API.G_EXCEPTION_ERROR;
1358: END IF;
1359: UPDATE OKC_CHANGE_PARTY_ROLE
1360: SET OBJECT_VERSION_NUMBER = l_def_cpr_rec.object_version_number,
1361: CREATED_BY = l_def_cpr_rec.created_by,
1362: CREATION_DATE = l_def_cpr_rec.creation_date,
1363: LAST_UPDATED_BY = l_def_cpr_rec.last_updated_by,

Line 1405: -- update_row for:OKC_CHANGE_PARTY_ROLE_V --

1401: '_PVT'
1402: );
1403: END update_row;
1404: --------------------------------------------
1405: -- update_row for:OKC_CHANGE_PARTY_ROLE_V --
1406: --------------------------------------------
1407: PROCEDURE update_row(
1408: p_api_version IN NUMBER,
1409: p_init_msg_list IN VARCHAR2 ,

Line 1492: -- Set_Attributes for:OKC_CHANGE_PARTY_ROLE_V --

1488: END IF;
1489: RETURN(l_return_status);
1490: END populate_new_record;
1491: ------------------------------------------------
1492: -- Set_Attributes for:OKC_CHANGE_PARTY_ROLE_V --
1493: ------------------------------------------------
1494: FUNCTION Set_Attributes (
1495: p_cprv_rec IN cprv_rec_type,
1496: x_cprv_rec OUT NOCOPY cprv_rec_type

Line 1675: -- delete_row for:OKC_CHANGE_PARTY_ROLE --

1671: ---------------------------------------------------------------------------
1672: -- PROCEDURE delete_row
1673: ---------------------------------------------------------------------------
1674: ------------------------------------------
1675: -- delete_row for:OKC_CHANGE_PARTY_ROLE --
1676: ------------------------------------------
1677: PROCEDURE delete_row(
1678: p_init_msg_list IN VARCHAR2 ,
1679: x_return_status OUT NOCOPY VARCHAR2,

Line 1699: DELETE FROM OKC_CHANGE_PARTY_ROLE

1695: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1696: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1697: RAISE OKC_API.G_EXCEPTION_ERROR;
1698: END IF;
1699: DELETE FROM OKC_CHANGE_PARTY_ROLE
1700: WHERE CRT_ID = l_cpr_rec.crt_id AND
1701: CPL_ID = l_cpr_rec.cpl_id;
1702:
1703: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1737: -- delete_row for:OKC_CHANGE_PARTY_ROLE_V --

1733: '_PVT'
1734: );
1735: END delete_row;
1736: --------------------------------------------
1737: -- delete_row for:OKC_CHANGE_PARTY_ROLE_V --
1738: --------------------------------------------
1739: PROCEDURE delete_row(
1740: p_api_version IN NUMBER,
1741: p_init_msg_list IN VARCHAR2 ,