DBA Data[Home] [Help]

APPS.OKC_CGP_PVT dependencies on OKC_K_GROUPS_B

Line 75: FROM OKC_K_GROUPS_B B

71: BEGIN
72: DELETE FROM OKC_K_GROUPS_TL T
73: WHERE NOT EXISTS (
74: SELECT NULL
75: FROM OKC_K_GROUPS_B B
76: WHERE B.ID = T.ID
77: );
78:
79: UPDATE OKC_K_GROUPS_TL T SET (

Line 137: -- FUNCTION get_rec for: OKC_K_GROUPS_B

133:
134: END add_language;
135:
136: ---------------------------------------------------------------------------
137: -- FUNCTION get_rec for: OKC_K_GROUPS_B
138: ---------------------------------------------------------------------------
139: FUNCTION get_rec (
140: p_cgp_rec IN cgp_rec_type,
141: x_no_data_found OUT NOCOPY BOOLEAN

Line 170: FROM Okc_K_Groups_B

166: ATTRIBUTE12,
167: ATTRIBUTE13,
168: ATTRIBUTE14,
169: ATTRIBUTE15
170: FROM Okc_K_Groups_B
171: WHERE okc_K_groups_b.id = p_id;
172: l_cgp_pk cgp_pk_csr%ROWTYPE;
173: l_cgp_rec cgp_rec_type;
174: BEGIN

Line 171: WHERE okc_K_groups_b.id = p_id;

167: ATTRIBUTE13,
168: ATTRIBUTE14,
169: ATTRIBUTE15
170: FROM Okc_K_Groups_B
171: WHERE okc_K_groups_b.id = p_id;
172: l_cgp_pk cgp_pk_csr%ROWTYPE;
173: l_cgp_rec cgp_rec_type;
174: BEGIN
175: x_no_data_found := TRUE;

Line 1170: -- insert_row for:OKC_K_GROUPS_B --

1166: ---------------------------------------------------------------------------
1167: -- PROCEDURE insert_row
1168: ---------------------------------------------------------------------------
1169: ------------------------------------------
1170: -- insert_row for:OKC_K_GROUPS_B --
1171: ------------------------------------------
1172: PROCEDURE insert_row(
1173: p_init_msg_list IN VARCHAR2 ,
1174: x_return_status OUT NOCOPY VARCHAR2,

Line 1186: -- Set_Attributes for:OKC_K_GROUPS_B --

1182: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1183: l_cgp_rec cgp_rec_type := p_cgp_rec;
1184: l_def_cgp_rec cgp_rec_type;
1185: ----------------------------------------------
1186: -- Set_Attributes for:OKC_K_GROUPS_B --
1187: ----------------------------------------------
1188: FUNCTION Set_Attributes (
1189: p_cgp_rec IN cgp_rec_type,
1190: x_cgp_rec OUT NOCOPY cgp_rec_type

Line 1217: INSERT INTO OKC_K_GROUPS_B(

1213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1214: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1215: RAISE OKC_API.G_EXCEPTION_ERROR;
1216: END IF;
1217: INSERT INTO OKC_K_GROUPS_B(
1218: id,
1219: public_yn,
1220: object_version_number,
1221: created_by,

Line 1659: -- lock_row for:OKC_K_GROUPS_B --

1655: ---------------------------------------------------------------------------
1656: -- PROCEDURE lock_row
1657: ---------------------------------------------------------------------------
1658: ----------------------------------------
1659: -- lock_row for:OKC_K_GROUPS_B --
1660: ----------------------------------------
1661: PROCEDURE lock_row(
1662: p_init_msg_list IN VARCHAR2 ,
1663: x_return_status OUT NOCOPY VARCHAR2,

Line 1672: FROM OKC_K_GROUPS_B

1668: E_Resource_Busy EXCEPTION;
1669: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1670: CURSOR lock_csr (p_cgp_rec IN cgp_rec_type) IS
1671: SELECT OBJECT_VERSION_NUMBER
1672: FROM OKC_K_GROUPS_B
1673: WHERE ID = p_cgp_rec.id
1674: AND OBJECT_VERSION_NUMBER = p_cgp_rec.object_version_number
1675: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1676:

Line 1679: FROM OKC_K_GROUPS_B

1675: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1676:
1677: CURSOR lchk_csr (p_cgp_rec IN cgp_rec_type) IS
1678: SELECT OBJECT_VERSION_NUMBER
1679: FROM OKC_K_GROUPS_B
1680: WHERE ID = p_cgp_rec.id;
1681: l_api_version CONSTANT NUMBER := 1;
1682: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1683: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1684: l_object_version_number OKC_K_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

1680: WHERE ID = p_cgp_rec.id;
1681: l_api_version CONSTANT NUMBER := 1;
1682: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1683: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1684: l_object_version_number OKC_K_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
1685: lc_object_version_number OKC_K_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
1686: l_row_notfound BOOLEAN := FALSE;
1687: lc_row_notfound BOOLEAN := FALSE;
1688: BEGIN

Line 1685: lc_object_version_number OKC_K_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

1681: l_api_version CONSTANT NUMBER := 1;
1682: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1683: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1684: l_object_version_number OKC_K_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
1685: lc_object_version_number OKC_K_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
1686: l_row_notfound BOOLEAN := FALSE;
1687: lc_row_notfound BOOLEAN := FALSE;
1688: BEGIN
1689: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2011: -- update_row for:OKC_K_GROUPS_B --

2007: ---------------------------------------------------------------------------
2008: -- PROCEDURE update_row
2009: ---------------------------------------------------------------------------
2010: ------------------------------------------
2011: -- update_row for:OKC_K_GROUPS_B --
2012: ------------------------------------------
2013: PROCEDURE update_row(
2014: p_init_msg_list IN VARCHAR2 ,
2015: x_return_status OUT NOCOPY VARCHAR2,

Line 2147: -- Set_Attributes for:OKC_K_GROUPS_B --

2143: END IF;
2144: RETURN(l_return_status);
2145: END populate_new_record;
2146: ----------------------------------------------
2147: -- Set_Attributes for:OKC_K_GROUPS_B --
2148: ----------------------------------------------
2149: FUNCTION Set_Attributes (
2150: p_cgp_rec IN cgp_rec_type,
2151: x_cgp_rec OUT NOCOPY cgp_rec_type

Line 2184: UPDATE OKC_K_GROUPS_B

2180: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2181: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2182: RAISE OKC_API.G_EXCEPTION_ERROR;
2183: END IF;
2184: UPDATE OKC_K_GROUPS_B
2185: SET PUBLIC_YN = l_def_cgp_rec.public_yn,
2186: OBJECT_VERSION_NUMBER = l_def_cgp_rec.object_version_number,
2187: CREATED_BY = l_def_cgp_rec.created_by,
2188: CREATION_DATE = l_def_cgp_rec.creation_date,

Line 2792: -- delete_row for:OKC_K_GROUPS_B --

2788: ---------------------------------------------------------------------------
2789: -- PROCEDURE delete_row
2790: ---------------------------------------------------------------------------
2791: ------------------------------------------
2792: -- delete_row for:OKC_K_GROUPS_B --
2793: ------------------------------------------
2794: PROCEDURE delete_row(
2795: p_init_msg_list IN VARCHAR2 ,
2796: x_return_status OUT NOCOPY VARCHAR2,

Line 2816: DELETE FROM OKC_K_GROUPS_B

2812: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2813: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2814: RAISE OKC_API.G_EXCEPTION_ERROR;
2815: END IF;
2816: DELETE FROM OKC_K_GROUPS_B
2817: WHERE ID = l_cgp_rec.id;
2818:
2819: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2820: EXCEPTION