DBA Data[Home] [Help]

APPS.OKS_CDT_PVT dependencies on OKS_K_DEFAULTS_V

Line 190: -- FUNCTION get_rec for: OKS_K_DEFAULTS_V

186: BEGIN
187: RETURN(get_rec(p_cdt_rec, l_row_notfound));
188: END get_rec;
189: ---------------------------------------------------------------------------
190: -- FUNCTION get_rec for: OKS_K_DEFAULTS_V
191: ---------------------------------------------------------------------------
192: FUNCTION get_rec (
193: p_cdtv_rec IN cdtv_rec_type,
194: x_no_data_found OUT NOCOPY BOOLEAN

Line 257: FROM Oks_K_Defaults_V

253: COMMITMENT_NUMBER_FLAG,
254: CHECK_FLAG,
255: TEMPLATE_LANGUAGE
256: -- R12 Data Model Changes 4485150 End
257: FROM Oks_K_Defaults_V
258: WHERE oks_k_defaults_v.id = p_id;
259: l_oks_kdf_pk oks_kdf_pk_csr%ROWTYPE;
260: l_cdtv_rec cdtv_rec_type;
261: BEGIN

Line 258: WHERE oks_k_defaults_v.id = p_id;

254: CHECK_FLAG,
255: TEMPLATE_LANGUAGE
256: -- R12 Data Model Changes 4485150 End
257: FROM Oks_K_Defaults_V
258: WHERE oks_k_defaults_v.id = p_id;
259: l_oks_kdf_pk oks_kdf_pk_csr%ROWTYPE;
260: l_cdtv_rec cdtv_rec_type;
261: BEGIN
262: x_no_data_found := TRUE;

Line 341: -- FUNCTION null_out_defaults for: OKS_K_DEFAULTS_V --

337: RETURN(get_rec(p_cdtv_rec, l_row_notfound));
338: END get_rec;
339:
340: ------------------------------------------------------
341: -- FUNCTION null_out_defaults for: OKS_K_DEFAULTS_V --
342: ------------------------------------------------------
343: FUNCTION null_out_defaults (
344: p_cdtv_rec IN cdtv_rec_type
345: ) RETURN cdtv_rec_type IS

Line 523: -- Validate_Attributes for:OKS_K_DEFAULTS_V --

519:
520: RETURN(l_cdtv_rec);
521: END null_out_defaults;
522: ----------------------------------------------
523: -- Validate_Attributes for:OKS_K_DEFAULTS_V --
524: ----------------------------------------------
525: -- Validate ID--
526: -----------------------------------------------------
527: PROCEDURE validate_id(x_return_status OUT NOCOPY varchar2,

Line 1182: -- Validate_Attributes for:OKS_K_DEFAULTS_V

1178: -- R12 Data Model Changes 4485150 End
1179:
1180:
1181: ---------------------------------------------------
1182: -- Validate_Attributes for:OKS_K_DEFAULTS_V
1183: ---------------------------------------------------
1184: FUNCTION Validate_Attributes (
1185: p_cdtv_rec IN cdtv_rec_type
1186: )

Line 1194: OKC_UTIL.ADD_VIEW('OKS_K_DEFAULTS_V',x_return_status);

1190:
1191: Begin
1192: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1193:
1194: OKC_UTIL.ADD_VIEW('OKS_K_DEFAULTS_V',x_return_status);
1195:
1196: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1197: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1198: -- need to leave

Line 1410: -- Validate_Record for:OKS_K_DEFAULTS_V --

1406: ---------------------------------------------------------------------------
1407: -- PROCEDURE Validate_Record
1408: ---------------------------------------------------------------------------
1409: ------------------------------------------
1410: -- Validate_Record for:OKS_K_DEFAULTS_V --
1411: ------------------------------------------
1412: FUNCTION Validate_Record (
1413: p_cdtv_rec IN cdtv_rec_type
1414: ) RETURN VARCHAR2 IS

Line 1559: -- validate_row for:OKS_K_DEFAULTS_V --

1555: ---------------------------------------------------------------------------
1556: -- PROCEDURE validate_row
1557: ---------------------------------------------------------------------------
1558: ---------------------------------------
1559: -- validate_row for:OKS_K_DEFAULTS_V --
1560: ---------------------------------------
1561: PROCEDURE validate_row(
1562: p_api_version IN NUMBER,
1563: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1909: -- insert_row for:OKS_K_DEFAULTS_V --

1905: '_PVT'
1906: );
1907: END insert_row;
1908: -------------------------------------
1909: -- insert_row for:OKS_K_DEFAULTS_V --
1910: -------------------------------------
1911: PROCEDURE insert_row(
1912: p_api_version IN NUMBER,
1913: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1942: -- Set_Attributes for:OKS_K_DEFAULTS_V --

1938: l_cdtv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1939: RETURN(l_cdtv_rec);
1940: END fill_who_columns;
1941: -----------------------------------------
1942: -- Set_Attributes for:OKS_K_DEFAULTS_V --
1943: -----------------------------------------
1944: FUNCTION Set_Attributes (
1945: p_cdtv_rec IN cdtv_rec_type,
1946: x_cdtv_rec OUT NOCOPY cdtv_rec_type

Line 2228: -- lock_row for:OKS_K_DEFAULTS_V --

2224: '_PVT'
2225: );
2226: END lock_row;
2227: -----------------------------------
2228: -- lock_row for:OKS_K_DEFAULTS_V --
2229: -----------------------------------
2230: PROCEDURE lock_row(
2231: p_api_version IN NUMBER,
2232: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2756: -- update_row for:OKS_K_DEFAULTS_V --

2752: '_PVT'
2753: );
2754: END update_row;
2755: -------------------------------------
2756: -- update_row for:OKS_K_DEFAULTS_V --
2757: -------------------------------------
2758: PROCEDURE update_row(
2759: p_api_version IN NUMBER,
2760: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3007: -- Set_Attributes for:OKS_K_DEFAULTS_V --

3003:
3004: RETURN(l_return_status);
3005: END populate_new_record;
3006: -----------------------------------------
3007: -- Set_Attributes for:OKS_K_DEFAULTS_V --
3008: -----------------------------------------
3009: FUNCTION Set_Attributes (
3010: p_cdtv_rec IN cdtv_rec_type,
3011: x_cdtv_rec OUT NOCOPY cdtv_rec_type

Line 3251: -- delete_row for:OKS_K_DEFAULTS_V --

3247: '_PVT'
3248: );
3249: END delete_row;
3250: -------------------------------------
3251: -- delete_row for:OKS_K_DEFAULTS_V --
3252: -------------------------------------
3253: PROCEDURE delete_row(
3254: p_api_version IN NUMBER,
3255: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,