DBA Data[Home] [Help]

APPS.OKL_LLN_PVT dependencies on OKL_CNSLD_AR_LINES_V

Line 123: FROM OKL_CNSLD_AR_LINES_V

119: l_dummy_var VARCHAR2(1) := '0';
120:
121: CURSOR l_lln_id_parent_csr IS
122: SELECT '1'
123: FROM OKL_CNSLD_AR_LINES_V
124: WHERE id = p_llnv_rec.lln_id_parent;
125:
126:
127: BEGIN

Line 144: p_token3_value => 'OKL_CNSLD_AR_LINES_V' );

140: p_token1_value => 'LLN_ID_PARENT_FOR',
141: p_token2 => G_CHILD_TABLE_TOKEN,
142: p_token2_value => G_VIEW,
143: p_token3 => G_PARENT_TABLE_TOKEN,
144: p_token3_value => 'OKL_CNSLD_AR_LINES_V' );
145:
146: RAISE G_EXCEPTION_HALT_VALIDATION;
147: END IF;
148: END IF;

Line 182: p_token3_value => 'OKL_CNSLD_AR_LINES_V' );

178: p_token1_value => 'KLE_ID_FOR',
179: p_token2 => G_CHILD_TABLE_TOKEN,
180: p_token2_value => G_VIEW,
181: p_token3 => G_PARENT_TABLE_TOKEN,
182: p_token3_value => 'OKL_CNSLD_AR_LINES_V' );
183:
184: RAISE G_EXCEPTION_HALT_VALIDATION;
185: END IF;
186: END IF;

Line 220: p_token3_value => 'OKL_CNSLD_AR_LINES_V' );

216: p_token1_value => 'KHR_ID_FOR',
217: p_token2 => G_CHILD_TABLE_TOKEN,
218: p_token2_value => G_VIEW,
219: p_token3 => G_PARENT_TABLE_TOKEN,
220: p_token3_value => 'OKL_CNSLD_AR_LINES_V' );
221:
222: RAISE G_EXCEPTION_HALT_VALIDATION;
223: END IF;
224: END IF;

Line 258: p_token3_value => 'OKL_CNSLD_AR_LINES_V' );

254: p_token1_value => 'CNR_ID_FOR',
255: p_token2 => G_CHILD_TABLE_TOKEN,
256: p_token2_value => G_VIEW,
257: p_token3 => G_PARENT_TABLE_TOKEN,
258: p_token3_value => 'OKL_CNSLD_AR_LINES_V' );
259:
260: RAISE G_EXCEPTION_HALT_VALIDATION;
261: END IF;
262: END IF;

Line 296: p_token3_value => 'OKL_CNSLD_AR_LINES_V' );

292: p_token1_value => 'ILT_ID_FOR',
293: p_token2 => G_CHILD_TABLE_TOKEN,
294: p_token2_value => G_VIEW,
295: p_token3 => G_PARENT_TABLE_TOKEN,
296: p_token3_value => 'OKL_CNSLD_AR_LINES_V' );
297:
298: RAISE G_EXCEPTION_HALT_VALIDATION;
299: END IF;
300: END IF;

Line 335: p_token3_value => 'OKL_CNSLD_AR_LINES_V' );

331: p_token1_value => 'CURRENCY_CODE_FOR',
332: p_token2 => G_CHILD_TABLE_TOKEN,
333: p_token2_value => G_VIEW,
334: p_token3 => G_PARENT_TABLE_TOKEN,
335: p_token3_value => 'OKL_CNSLD_AR_LINES_V' );
336:
337: RAISE G_EXCEPTION_HALT_VALIDATION;
338: END IF;
339: END IF;

Line 600: -- FUNCTION get_rec for: OKL_CNSLD_AR_LINES_V

596: BEGIN
597: RETURN(get_rec(p_okl_cnsld_ar_lines_tl_rec, l_row_notfound));
598: END get_rec;
599: ---------------------------------------------------------------------------
600: -- FUNCTION get_rec for: OKL_CNSLD_AR_LINES_V
601: ---------------------------------------------------------------------------
602: FUNCTION get_rec (
603: p_llnv_rec IN llnv_rec_type,
604: x_no_data_found OUT NOCOPY BOOLEAN

Line 646: FROM Okl_Cnsld_Ar_Lines_V

642: CREATION_DATE,
643: LAST_UPDATED_BY,
644: LAST_UPDATE_DATE,
645: LAST_UPDATE_LOGIN
646: FROM Okl_Cnsld_Ar_Lines_V
647: WHERE okl_cnsld_ar_lines_v.id = p_id;
648: l_okl_llnv_pk okl_llnv_pk_csr%ROWTYPE;
649: l_llnv_rec llnv_rec_type;
650: BEGIN

Line 647: WHERE okl_cnsld_ar_lines_v.id = p_id;

643: LAST_UPDATED_BY,
644: LAST_UPDATE_DATE,
645: LAST_UPDATE_LOGIN
646: FROM Okl_Cnsld_Ar_Lines_V
647: WHERE okl_cnsld_ar_lines_v.id = p_id;
648: l_okl_llnv_pk okl_llnv_pk_csr%ROWTYPE;
649: l_llnv_rec llnv_rec_type;
650: BEGIN
651: x_no_data_found := TRUE;

Line 707: -- FUNCTION null_out_defaults for: OKL_CNSLD_AR_LINES_V --

703: RETURN(get_rec(p_llnv_rec, l_row_notfound));
704: END get_rec;
705:
706: ----------------------------------------------------------
707: -- FUNCTION null_out_defaults for: OKL_CNSLD_AR_LINES_V --
708: ----------------------------------------------------------
709: FUNCTION null_out_defaults (
710: p_llnv_rec IN llnv_rec_type
711: ) RETURN llnv_rec_type IS

Line 831: -- Validate_Attributes for:OKL_CNSLD_AR_LINES_V --

827: ---------------------------------------------------------------------------
828: -- PROCEDURE Validate_Attributes
829: ---------------------------------------------------------------------------
830: --------------------------------------------------
831: -- Validate_Attributes for:OKL_CNSLD_AR_LINES_V --
832: --------------------------------------------------
833: FUNCTION Validate_Attributes (
834: p_llnv_rec IN llnv_rec_type
835: ) RETURN VARCHAR2 IS

Line 982: -- Validate_Record for:OKL_CNSLD_AR_LINES_V --

978: ---------------------------------------------------------------------------
979: -- PROCEDURE Validate_Record
980: ---------------------------------------------------------------------------
981: ----------------------------------------------
982: -- Validate_Record for:OKL_CNSLD_AR_LINES_V --
983: ----------------------------------------------
984: FUNCTION Validate_Record (
985: p_llnv_rec IN llnv_rec_type
986: ) RETURN VARCHAR2 IS

Line 1112: -- validate_row for:OKL_CNSLD_AR_LINES_V --

1108: ---------------------------------------------------------------------------
1109: -- PROCEDURE validate_row
1110: ---------------------------------------------------------------------------
1111: -------------------------------------------
1112: -- validate_row for:OKL_CNSLD_AR_LINES_V --
1113: -------------------------------------------
1114: PROCEDURE validate_row(
1115: p_api_version IN NUMBER,
1116: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1548: -- insert_row for:OKL_CNSLD_AR_LINES_V --

1544: '_PVT'
1545: );
1546: END insert_row;
1547: -----------------------------------------
1548: -- insert_row for:OKL_CNSLD_AR_LINES_V --
1549: -----------------------------------------
1550: PROCEDURE insert_row(
1551: p_api_version IN NUMBER,
1552: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1584: -- Set_Attributes for:OKL_CNSLD_AR_LINES_V --

1580: l_llnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1581: RETURN(l_llnv_rec);
1582: END fill_who_columns;
1583: ---------------------------------------------
1584: -- Set_Attributes for:OKL_CNSLD_AR_LINES_V --
1585: ---------------------------------------------
1586: FUNCTION Set_Attributes (
1587: p_llnv_rec IN llnv_rec_type,
1588: x_llnv_rec OUT NOCOPY llnv_rec_type

Line 2004: -- lock_row for:OKL_CNSLD_AR_LINES_V --

2000: '_PVT'
2001: );
2002: END lock_row;
2003: ---------------------------------------
2004: -- lock_row for:OKL_CNSLD_AR_LINES_V --
2005: ---------------------------------------
2006: PROCEDURE lock_row(
2007: p_api_version IN NUMBER,
2008: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2622: -- update_row for:OKL_CNSLD_AR_LINES_V --

2618: '_PVT'
2619: );
2620: END update_row;
2621: -----------------------------------------
2622: -- update_row for:OKL_CNSLD_AR_LINES_V --
2623: -----------------------------------------
2624: PROCEDURE update_row(
2625: p_api_version IN NUMBER,
2626: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2827: -- Set_Attributes for:OKL_CNSLD_AR_LINES_V --

2823: END IF;
2824: RETURN(l_return_status);
2825: END populate_new_record;
2826: ---------------------------------------------
2827: -- Set_Attributes for:OKL_CNSLD_AR_LINES_V --
2828: ---------------------------------------------
2829: FUNCTION Set_Attributes (
2830: p_llnv_rec IN llnv_rec_type,
2831: x_llnv_rec OUT NOCOPY llnv_rec_type

Line 3192: -- delete_row for:OKL_CNSLD_AR_LINES_V --

3188: '_PVT'
3189: );
3190: END delete_row;
3191: -----------------------------------------
3192: -- delete_row for:OKL_CNSLD_AR_LINES_V --
3193: -----------------------------------------
3194: PROCEDURE delete_row(
3195: p_api_version IN NUMBER,
3196: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,