DBA Data[Home] [Help]

APPS.OKL_PTM_PVT dependencies on OKL_PROCESS_TMPLTS_V

Line 202: p_token2_value => 'OKL_PROCESS_TMPLTS_V',

198: p_msg_name => G_NO_PARENT_RECORD,
199: p_token1 => G_COL_NAME_TOKEN,
200: p_token1_value => 'PTM_CODE',
201: p_token2 => G_CHILD_TABLE_TOKEN,
202: p_token2_value => 'OKL_PROCESS_TMPLTS_V',
203: p_token3 => G_PARENT_TABLE_TOKEN,
204: p_token3_value => 'FND_LOOKUPS');
205: x_return_status := OKL_API.G_RET_STS_ERROR;
206: END IF;

Line 264: p_token2_value => 'OKL_PROCESS_TMPLTS_V',

260: p_msg_name => G_NO_PARENT_RECORD,
261: p_token1 => G_COL_NAME_TOKEN,
262: p_token1_value => 'template',
263: p_token2 => G_CHILD_TABLE_TOKEN,
264: p_token2_value => 'OKL_PROCESS_TMPLTS_V',
265: p_token3 => G_PARENT_TABLE_TOKEN,
266: p_token3_value => 'JTF_AMV_ITEMS_VL');
267: x_return_status := OKL_API.G_RET_STS_ERROR;
268:

Line 844: -- FUNCTION get_rec for: okl_process_tmplts_v

840: END get_rec;
841:
842:
843: ---------------------------------------------------------------------------
844: -- FUNCTION get_rec for: okl_process_tmplts_v
845: ---------------------------------------------------------------------------
846: FUNCTION get_rec (p_ptmv_rec IN ptmv_rec_type,
847: x_no_data_found OUT NOCOPY BOOLEAN) RETURN ptmv_rec_type IS
848:

Line 889: FROM okl_process_tmplts_v

885: */
886: recipient_type_code ,
887: xml_tmplt_code
888: /* End Changes */
889: FROM okl_process_tmplts_v
890: WHERE okl_process_tmplts_v.id = p_id;
891:
892: l_ptmv_rec ptmv_rec_type;
893:

Line 890: WHERE okl_process_tmplts_v.id = p_id;

886: recipient_type_code ,
887: xml_tmplt_code
888: /* End Changes */
889: FROM okl_process_tmplts_v
890: WHERE okl_process_tmplts_v.id = p_id;
891:
892: l_ptmv_rec ptmv_rec_type;
893:
894: BEGIN

Line 950: -- FUNCTION null_out_defaults for: okl_process_tmplts_v --

946: RETURN(get_rec(p_ptmv_rec, l_row_notfound));
947: END get_rec;
948:
949: ----------------------------------------------------------
950: -- FUNCTION null_out_defaults for: okl_process_tmplts_v --
951: ----------------------------------------------------------
952: FUNCTION null_out_defaults (p_ptmv_rec IN ptmv_rec_type) RETURN ptmv_rec_type IS
953:
954: l_ptmv_rec ptmv_rec_type := p_ptmv_rec;

Line 1068: -- Validate_Attributes for: okl_process_tmplts_v --

1064: END null_out_defaults;
1065:
1066:
1067: --------------------------------------------------
1068: -- Validate_Attributes for: okl_process_tmplts_v --
1069: --------------------------------------------------
1070:
1071: FUNCTION Validate_Attributes (p_ptmv_rec IN ptmv_rec_type) RETURN VARCHAR2 IS
1072:

Line 1156: -- Validate_Record for: okl_process_tmplts_v --

1152: END Validate_Attributes;
1153:
1154:
1155: ----------------------------------------------
1156: -- Validate_Record for: okl_process_tmplts_v --
1157: ----------------------------------------------
1158:
1159: FUNCTION Validate_Record (p_ptmv_rec IN ptmv_rec_type) RETURN VARCHAR2 IS
1160:

Line 1385: -- validate_row for: okl_process_tmplts_v --

1381:
1382: END migrate;
1383:
1384: -------------------------------------------
1385: -- validate_row for: okl_process_tmplts_v --
1386: -------------------------------------------
1387:
1388: PROCEDURE validate_row(
1389: p_api_version IN NUMBER,

Line 1833: -- insert_row for: okl_process_tmplts_v --

1829: END insert_row;
1830:
1831:
1832: -----------------------------------------
1833: -- insert_row for: okl_process_tmplts_v --
1834: -----------------------------------------
1835: PROCEDURE insert_row(
1836: p_api_version IN NUMBER,
1837: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1874: -- Set_Attributes for:okl_process_tmplts_v --

1870:
1871: END fill_who_columns;
1872:
1873: ---------------------------------------------
1874: -- Set_Attributes for:okl_process_tmplts_v --
1875: ---------------------------------------------
1876: FUNCTION Set_Attributes (p_ptmv_rec IN ptmv_rec_type, x_ptmv_rec OUT NOCOPY ptmv_rec_type)
1877: RETURN VARCHAR2 IS
1878:

Line 2297: -- lock_row for:OKL_PROCESS_TMPLTS_V --

2293: );
2294: END lock_row;
2295:
2296: ---------------------------------------
2297: -- lock_row for:OKL_PROCESS_TMPLTS_V --
2298: ---------------------------------------
2299: PROCEDURE lock_row(
2300: p_api_version IN NUMBER,
2301: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2905: -- update_row for:okl_process_tmplts_v --

2901: END update_row;
2902:
2903:
2904: -----------------------------------------
2905: -- update_row for:okl_process_tmplts_v --
2906: -----------------------------------------
2907: PROCEDURE update_row(
2908: p_api_version IN NUMBER,
2909: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3087: -- Set_Attributes for:okl_process_tmplts_v --

3083: /* End Changes */
3084: RETURN(l_return_status);
3085: END populate_new_record;
3086: ---------------------------------------------
3087: -- Set_Attributes for:okl_process_tmplts_v --
3088: ---------------------------------------------
3089: FUNCTION Set_Attributes (p_ptmv_rec IN ptmv_rec_type,
3090: x_ptmv_rec OUT NOCOPY ptmv_rec_type) RETURN VARCHAR2 IS
3091:

Line 3462: -- delete_row for:OKL_PROCESS_TMPLTS_V --

3458: '_PVT'
3459: );
3460: END delete_row;
3461: -----------------------------------------
3462: -- delete_row for:OKL_PROCESS_TMPLTS_V --
3463: -----------------------------------------
3464: PROCEDURE delete_row(
3465: p_api_version IN NUMBER,
3466: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,