DBA Data[Home] [Help]

APPS.OKL_CLG_PVT dependencies on OKL_CNTR_LVLNG_GRPS_V

Line 39: p_token2_value => 'OKL_CNTR_LVLNG_GRPS_V',

35: p_msg_name => g_no_parent_record,
36: p_token1 => g_col_name_token,
37: p_token1_value => 'Currency',
38: p_token2 => g_child_table_token,
39: p_token2_value => 'OKL_CNTR_LVLNG_GRPS_V',
40: p_token3 => g_parent_table_token,
41: p_token3_value => 'FND_CURRENCIES_V');
42:
43: -- notify caller of an error

Line 146: p_token2_value => 'OKL_CNTR_LVLNG_GRPS_V',

142: p_msg_name => g_no_parent_record,
143: p_token1 => g_col_name_token,
144: p_token1_value => 'ibt_id',
145: p_token2 => g_child_table_token,
146: p_token2_value => 'OKL_CNTR_LVLNG_GRPS_V',
147: p_token3 => g_parent_table_token,
148: p_token3_value => 'OKX_BILL_TOS_V');
149:
150: -- notify caller of an error

Line 221: p_token2_value => 'OKL_CNTR_LVLNG_GRPS_V',

217: p_msg_name => g_no_parent_record,
218: p_token1 => g_col_name_token,
219: p_token1_value => 'ica_id',
220: p_token2 => g_child_table_token,
221: p_token2_value => 'OKL_CNTR_LVLNG_GRPS_V',
222: p_token3 => g_parent_table_token,
223: p_token3_value => 'OKX_CUSTOMER_ACCOUNTS_V');
224:
225: -- notify caller of an error

Line 294: p_token2_value => 'OKL_CNTR_LVLNG_GRPS_V',

290: p_msg_name => g_no_parent_record,
291: p_token1 => g_col_name_token,
292: p_token1_value => 'inf_id',
293: p_token2 => g_child_table_token,
294: p_token2_value => 'OKL_CNTR_LVLNG_GRPS_V',
295: p_token3 => g_parent_table_token,
296: p_token3_value => 'OKL_INVOICE_FORMATS_V');
297:
298: -- notify caller of an error

Line 368: p_token2_value => 'OKL_CNTR_LVLNG_GRPS_V',

364: p_msg_name => g_no_parent_record,
365: p_token1 => g_col_name_token,
366: p_token1_value => 'irm_id',
367: p_token2 => g_child_table_token,
368: p_token2_value => 'OKL_CNTR_LVLNG_GRPS_V',
369: p_token3 => g_parent_table_token,
370: p_token3_value => 'OKX_RECEIPT_METHODS_V');
371:
372: -- notify caller of an error

Line 440: p_token2_value => 'OKL_CNTR_LVLNG_GRPS_V',

436: p_msg_name => g_no_parent_record,
437: p_token1 => g_col_name_token,
438: p_token1_value => 'iuv_id',
439: p_token2 => g_child_table_token,
440: p_token2_value => 'OKL_CNTR_LVLNG_GRPS_V',
441: p_token3 => g_parent_table_token,
442: p_token3_value => 'OKX_USAGES_V');
443:
444: -- notify caller of an error

Line 530: FROM OKL_CNTR_LVLNG_GRPS_V

526: l_row_found BOOLEAN := FALSE;
527: l_clg_id NUMBER;
528: CURSOR c1( p_name OKL_CNTR_LVLNG_GRPS_TL.name%TYPE) IS
529: SELECT 1
530: FROM OKL_CNTR_LVLNG_GRPS_V
531: WHERE name = p_name;
532: CURSOR c2( p_name OKL_CNTR_LVLNG_GRPS_TL.name%TYPE) IS
533: SELECT id
534: FROM OKL_CNTR_LVLNG_GRPS_V

Line 534: FROM OKL_CNTR_LVLNG_GRPS_V

530: FROM OKL_CNTR_LVLNG_GRPS_V
531: WHERE name = p_name;
532: CURSOR c2( p_name OKL_CNTR_LVLNG_GRPS_TL.name%TYPE) IS
533: SELECT id
534: FROM OKL_CNTR_LVLNG_GRPS_V
535: WHERE name = p_name;
536: BEGIN
537: -- initialize return status
538: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 871: -- FUNCTION get_rec for: OKL_CNTR_LVLNG_GRPS_V

867: BEGIN
868: RETURN(get_rec(p_okl_cntr_lvlng_grps_tl_rec, l_row_notfound));
869: END get_rec;
870: ---------------------------------------------------------------------------
871: -- FUNCTION get_rec for: OKL_CNTR_LVLNG_GRPS_V
872: ---------------------------------------------------------------------------
873: FUNCTION get_rec (
874: p_clgv_rec IN clgv_rec_type,
875: x_no_data_found OUT NOCOPY BOOLEAN

Line 917: FROM Okl_Cntr_Lvlng_Grps_V

913: EFFECTIVE_DATE_FROM,
914: EFFECTIVE_DATE_TO,
915: IPL_ID,
916: LEGAL_ENTITY_ID -- for LE Uptake project 08-11-2006
917: FROM Okl_Cntr_Lvlng_Grps_V
918: WHERE okl_cntr_lvlng_grps_v.id = p_id;
919: l_okl_clgv_pk okl_clgv_pk_csr%ROWTYPE;
920: l_clgv_rec clgv_rec_type;
921: BEGIN

Line 918: WHERE okl_cntr_lvlng_grps_v.id = p_id;

914: EFFECTIVE_DATE_TO,
915: IPL_ID,
916: LEGAL_ENTITY_ID -- for LE Uptake project 08-11-2006
917: FROM Okl_Cntr_Lvlng_Grps_V
918: WHERE okl_cntr_lvlng_grps_v.id = p_id;
919: l_okl_clgv_pk okl_clgv_pk_csr%ROWTYPE;
920: l_clgv_rec clgv_rec_type;
921: BEGIN
922: x_no_data_found := TRUE;

Line 978: -- FUNCTION null_out_defaults for: OKL_CNTR_LVLNG_GRPS_V --

974: RETURN(get_rec(p_clgv_rec, l_row_notfound));
975: END get_rec;
976:
977: -----------------------------------------------------------
978: -- FUNCTION null_out_defaults for: OKL_CNTR_LVLNG_GRPS_V --
979: -----------------------------------------------------------
980: FUNCTION null_out_defaults (
981: p_clgv_rec IN clgv_rec_type
982: ) RETURN clgv_rec_type IS

Line 1104: -- Validate_Attributes for:OKL_CNTR_LVLNG_GRPS_V --

1100: ---------------------------------------------------------------------------
1101: -- PROCEDURE Validate_Attributes
1102: ---------------------------------------------------------------------------
1103: ---------------------------------------------------
1104: -- Validate_Attributes for:OKL_CNTR_LVLNG_GRPS_V --
1105: ---------------------------------------------------
1106: FUNCTION Validate_Attributes (
1107: p_clgv_rec IN clgv_rec_type
1108: ) RETURN VARCHAR2 IS

Line 1227: -- Validate_Record for:OKL_CNTR_LVLNG_GRPS_V --

1223: ---------------------------------------------------------------------------
1224: -- PROCEDURE Validate_Record
1225: ---------------------------------------------------------------------------
1226: -----------------------------------------------
1227: -- Validate_Record for:OKL_CNTR_LVLNG_GRPS_V --
1228: -----------------------------------------------
1229: FUNCTION Validate_Record (
1230: p_clgv_rec IN clgv_rec_type
1231: ) RETURN VARCHAR2 IS

Line 1358: -- validate_row for:OKL_CNTR_LVLNG_GRPS_V --

1354: ---------------------------------------------------------------------------
1355: -- PROCEDURE validate_row
1356: ---------------------------------------------------------------------------
1357: --------------------------------------------
1358: -- validate_row for:OKL_CNTR_LVLNG_GRPS_V --
1359: --------------------------------------------
1360: PROCEDURE validate_row(
1361: p_api_version IN NUMBER,
1362: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1774: -- insert_row for:OKL_CNTR_LVLNG_GRPS_V --

1770: '_PVT'
1771: );
1772: END insert_row;
1773: ------------------------------------------
1774: -- insert_row for:OKL_CNTR_LVLNG_GRPS_V --
1775: ------------------------------------------
1776: PROCEDURE insert_row(
1777: p_api_version IN NUMBER,
1778: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1810: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_V --

1806: l_clgv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1807: RETURN(l_clgv_rec);
1808: END fill_who_columns;
1809: ----------------------------------------------
1810: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_V --
1811: ----------------------------------------------
1812: FUNCTION Set_Attributes (
1813: p_clgv_rec IN clgv_rec_type,
1814: x_clgv_rec OUT NOCOPY clgv_rec_type

Line 2198: -- lock_row for:OKL_CNTR_LVLNG_GRPS_V --

2194: '_PVT'
2195: );
2196: END lock_row;
2197: ----------------------------------------
2198: -- lock_row for:OKL_CNTR_LVLNG_GRPS_V --
2199: ----------------------------------------
2200: PROCEDURE lock_row(
2201: p_api_version IN NUMBER,
2202: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2818: -- update_row for:OKL_CNTR_LVLNG_GRPS_V --

2814: '_PVT'
2815: );
2816: END update_row;
2817: ------------------------------------------
2818: -- update_row for:OKL_CNTR_LVLNG_GRPS_V --
2819: ------------------------------------------
2820: PROCEDURE update_row(
2821: p_api_version IN NUMBER,
2822: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 3025: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_V --

3021: -- for LE Uptake project 08-11-2006
3022: RETURN(l_return_status);
3023: END populate_new_record;
3024: ----------------------------------------------
3025: -- Set_Attributes for:OKL_CNTR_LVLNG_GRPS_V --
3026: ----------------------------------------------
3027: FUNCTION Set_Attributes (
3028: p_clgv_rec IN clgv_rec_type,
3029: x_clgv_rec OUT NOCOPY clgv_rec_type

Line 3368: -- delete_row for:OKL_CNTR_LVLNG_GRPS_V --

3364: '_PVT'
3365: );
3366: END delete_row;
3367: ------------------------------------------
3368: -- delete_row for:OKL_CNTR_LVLNG_GRPS_V --
3369: ------------------------------------------
3370: PROCEDURE delete_row(
3371: p_api_version IN NUMBER,
3372: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,