DBA Data[Home] [Help]

APPS.OKC_PDP_PVT dependencies on OKC_PROCESS_DEF_PARAMETERS_V

Line 233: -- FUNCTION get_rec for: OKC_PROCESS_DEF_PARAMETERS_V

229: BEGIN
230: RETURN(get_rec(p_pdp_rec, l_row_notfound));
231: END get_rec;
232: ---------------------------------------------------------------------------
233: -- FUNCTION get_rec for: OKC_PROCESS_DEF_PARAMETERS_V
234: ---------------------------------------------------------------------------
235: FUNCTION get_rec (
236: p_pdpv_rec IN pdpv_rec_type,
237: x_no_data_found OUT NOCOPY BOOLEAN

Line 261: FROM Okc_Process_Def_Parameters_V

257: LAST_UPDATE_LOGIN,
258: JTOT_OBJECT_CODE,
259: NAME_COLUMN,
260: DESCRIPTION_COLUMN
261: FROM Okc_Process_Def_Parameters_V
262: WHERE okc_process_def_parameters_v.id = p_id;
263: l_okc_pdpv_pk okc_pdpv_pk_csr%ROWTYPE;
264: l_pdpv_rec pdpv_rec_type;
265: BEGIN

Line 262: WHERE okc_process_def_parameters_v.id = p_id;

258: JTOT_OBJECT_CODE,
259: NAME_COLUMN,
260: DESCRIPTION_COLUMN
261: FROM Okc_Process_Def_Parameters_V
262: WHERE okc_process_def_parameters_v.id = p_id;
263: l_okc_pdpv_pk okc_pdpv_pk_csr%ROWTYPE;
264: l_pdpv_rec pdpv_rec_type;
265: BEGIN
266: x_no_data_found := TRUE;

Line 304: -- FUNCTION null_out_defaults for: OKC_PROCESS_DEF_PARAMETERS_V --

300: RETURN(get_rec(p_pdpv_rec, l_row_notfound));
301: END get_rec;
302:
303: ------------------------------------------------------------------
304: -- FUNCTION null_out_defaults for: OKC_PROCESS_DEF_PARAMETERS_V --
305: ------------------------------------------------------------------
306: FUNCTION null_out_defaults (
307: p_pdpv_rec IN pdpv_rec_type
308: ) RETURN pdpv_rec_type IS

Line 376: -- Validate_Attributes for:OKC_PROCESS_DEF_PARAMETERS_V --

372: ---------------------------------------------------------------------------
373: -- PROCEDURE Validate_Attributes
374: ---------------------------------------------------------------------------
375: ----------------------------------------------------------
376: -- Validate_Attributes for:OKC_PROCESS_DEF_PARAMETERS_V --
377: ----------------------------------------------------------
378: FUNCTION Validate_Attributes (
379: p_pdpv_rec IN pdpv_rec_type
380: ) RETURN VARCHAR2 IS

Line 426: -- Validate_Record for:OKC_PROCESS_DEF_PARAMETERS_V --

422: ---------------------------------------------------------------------------
423: -- PROCEDURE Validate_Record
424: ---------------------------------------------------------------------------
425: ------------------------------------------------------
426: -- Validate_Record for:OKC_PROCESS_DEF_PARAMETERS_V --
427: ------------------------------------------------------
428: FUNCTION Validate_Record (
429: p_pdpv_rec IN pdpv_rec_type
430: ) RETURN VARCHAR2 IS

Line 476: -- Validate_Attributes for:OKC_PROCESS_DEF_PARAMETERS_V --

472: ---------------------------------------------------------------------------
473: -- PROCEDURE Validate_Attributes
474: ---------------------------------------------------------------------------
475: ----------------------------------------------------------
476: -- Validate_Attributes for:OKC_PROCESS_DEF_PARAMETERS_V --
477: ----------------------------------------------------------
478: -- Start of comments
479: -- Procedure Name : validate_object_version_number
480: -- Description : Check if object version number is null

Line 565: p_token2_value => 'OKC_PROCESS_DEF_PARAMETERS_V',

561: p_msg_name => g_no_parent_record,
562: p_token1 => g_col_name_token,
563: p_token1_value => 'pdf_id',
564: p_token2 => g_child_table_token,
565: p_token2_value => 'OKC_PROCESS_DEF_PARAMETERS_V',
566: p_token3 => g_parent_table_token,
567: p_token3_value => 'OKC_PROCESS_DEFS_V');
568:
569: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1145: -- Validate_Record for:OKC_PROCESS_DEF_PARAMETERS_V --

1141: ---------------------------------------------------------------------------
1142: -- PROCEDURE Validate_Record
1143: ---------------------------------------------------------------------------
1144: ------------------------------------------------------
1145: -- Validate_Record for:OKC_PROCESS_DEF_PARAMETERS_V --
1146: ------------------------------------------------------
1147: FUNCTION Validate_Record (
1148: p_pdpv_rec IN pdpv_rec_type
1149: ) RETURN VARCHAR2 IS

Line 1155: FROM okc_process_def_parameters_v

1151: l_dummy Varchar2(1);
1152: l_row_found Boolean;
1153: cursor c1 is
1154: SELECT 'x'
1155: FROM okc_process_def_parameters_v
1156: WHERE name = p_pdpv_rec.name
1157: AND pdf_id = p_pdpv_rec.pdf_id
1158: AND id <> p_pdpv_rec.id;
1159: -- OR p_pdfv_rec.id is null)

Line 1269: -- validate_row for:OKC_PROCESS_DEF_PARAMETERS_V --

1265: ---------------------------------------------------------------------------
1266: -- PROCEDURE validate_row
1267: ---------------------------------------------------------------------------
1268: ---------------------------------------------------
1269: -- validate_row for:OKC_PROCESS_DEF_PARAMETERS_V --
1270: ---------------------------------------------------
1271: PROCEDURE validate_row(
1272: p_api_version IN NUMBER,
1273: p_init_msg_list IN VARCHAR2 ,

Line 1649: -- insert_row for:OKC_PROCESS_DEF_PARAMETERS_V --

1645: '_PVT'
1646: );
1647: END insert_row;
1648: -------------------------------------------------
1649: -- insert_row for:OKC_PROCESS_DEF_PARAMETERS_V --
1650: -------------------------------------------------
1651: PROCEDURE insert_row(
1652: p_api_version IN NUMBER,
1653: p_init_msg_list IN VARCHAR2 ,

Line 1686: -- Set_Attributes for:OKC_PROCESS_DEF_PARAMETERS_V --

1682: l_pdpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1683: RETURN(l_pdpv_rec);
1684: END fill_who_columns;
1685: -----------------------------------------------------
1686: -- Set_Attributes for:OKC_PROCESS_DEF_PARAMETERS_V --
1687: -----------------------------------------------------
1688: FUNCTION Set_Attributes (
1689: p_pdpv_rec IN pdpv_rec_type,
1690: x_pdpv_rec OUT NOCOPY pdpv_rec_type

Line 2083: -- lock_row for:OKC_PROCESS_DEF_PARAMETERS_V --

2079: '_PVT'
2080: );
2081: END lock_row;
2082: -----------------------------------------------
2083: -- lock_row for:OKC_PROCESS_DEF_PARAMETERS_V --
2084: -----------------------------------------------
2085: PROCEDURE lock_row(
2086: p_api_version IN NUMBER,
2087: p_init_msg_list IN VARCHAR2 ,

Line 2611: -- update_row for:OKC_PROCESS_DEF_PARAMETERS_V --

2607: '_PVT'
2608: );
2609: END update_row;
2610: -------------------------------------------------
2611: -- update_row for:OKC_PROCESS_DEF_PARAMETERS_V --
2612: -------------------------------------------------
2613: PROCEDURE update_row(
2614: p_api_version IN NUMBER,
2615: p_init_msg_list IN VARCHAR2 ,

Line 2744: -- Set_Attributes for:OKC_PROCESS_DEF_PARAMETERS_V --

2740: END IF;
2741: RETURN(l_return_status);
2742: END populate_new_record;
2743: -----------------------------------------------------
2744: -- Set_Attributes for:OKC_PROCESS_DEF_PARAMETERS_V --
2745: -----------------------------------------------------
2746: FUNCTION Set_Attributes (
2747: p_pdpv_rec IN pdpv_rec_type,
2748: x_pdpv_rec OUT NOCOPY pdpv_rec_type

Line 3098: -- delete_row for:OKC_PROCESS_DEF_PARAMETERS_V --

3094: '_PVT'
3095: );
3096: END delete_row;
3097: -------------------------------------------------
3098: -- delete_row for:OKC_PROCESS_DEF_PARAMETERS_V --
3099: -------------------------------------------------
3100: PROCEDURE delete_row(
3101: p_api_version IN NUMBER,
3102: p_init_msg_list IN VARCHAR2 ,