DBA Data[Home] [Help]

APPS.OKL_AJL_PVT dependencies on OKL_TXL_ADJSTS_LNS_V

Line 17: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TXL_ADJSTS_LNS_V';

13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
14: G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
15:
16: --GLOBAL VARIABLES
17: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TXL_ADJSTS_LNS_V';
18: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19:
20: ---------------------------------------------------------------------------
21: -- FUNCTION get_seq_id

Line 282: -- FUNCTION get_rec for: OKL_TXL_ADJSTS_LNS_V

278: BEGIN
279: RETURN(get_rec(p_okl_txl_adjsts_lns_tl_rec, l_row_notfound));
280: END get_rec;
281: ---------------------------------------------------------------------------
282: -- FUNCTION get_rec for: OKL_TXL_ADJSTS_LNS_V
283: ---------------------------------------------------------------------------
284: FUNCTION get_rec (
285: p_ajlv_rec IN ajlv_rec_type,
286: x_no_data_found OUT NOCOPY BOOLEAN

Line 330: FROM Okl_Txl_Adjsts_Lns_V

326: LAST_UPDATE_LOGIN,
327: KHR_ID,
328: KLE_ID,
329: STY_ID
330: FROM Okl_Txl_Adjsts_Lns_V
331: WHERE okl_txl_adjsts_lns_v.id = p_id;
332: l_okl_ajlv_pk okl_ajlv_pk_csr%ROWTYPE;
333: l_ajlv_rec ajlv_rec_type;
334: BEGIN

Line 331: WHERE okl_txl_adjsts_lns_v.id = p_id;

327: KHR_ID,
328: KLE_ID,
329: STY_ID
330: FROM Okl_Txl_Adjsts_Lns_V
331: WHERE okl_txl_adjsts_lns_v.id = p_id;
332: l_okl_ajlv_pk okl_ajlv_pk_csr%ROWTYPE;
333: l_ajlv_rec ajlv_rec_type;
334: BEGIN
335: x_no_data_found := TRUE;

Line 393: -- FUNCTION null_out_defaults for: OKL_TXL_ADJSTS_LNS_V --

389: RETURN(get_rec(p_ajlv_rec, l_row_notfound));
390: END get_rec;
391:
392: ----------------------------------------------------------
393: -- FUNCTION null_out_defaults for: OKL_TXL_ADJSTS_LNS_V --
394: ----------------------------------------------------------
395: FUNCTION null_out_defaults (
396: p_ajlv_rec IN ajlv_rec_type
397: ) RETURN ajlv_rec_type IS

Line 943: p_token2_value => 'OKL_TXL_ADJSTS_LNS_V',

939: p_msg_name => G_NO_PARENT_RECORD,
940: p_token1 => G_COL_NAME_TOKEN,
941: p_token1_value => 'adj_id',
942: p_token2 => G_CHILD_TABLE_TOKEN,
943: p_token2_value => 'OKL_TXL_ADJSTS_LNS_V',
944: p_token3 => G_PARENT_TABLE_TOKEN,
945: p_token3_value => 'OKL_TRX_AR_ADJSTS_V');
946:
947: -- notify caller of en error

Line 1012: p_token2_value => 'OKL_TXL_ADJSTS_LNS_V',

1008: p_msg_name => G_NO_PARENT_RECORD,
1009: p_token1 => G_COL_NAME_TOKEN,
1010: p_token1_value => 'til_id',
1011: p_token2 => G_CHILD_TABLE_TOKEN,
1012: p_token2_value => 'OKL_TXL_ADJSTS_LNS_V',
1013: p_token3 => G_PARENT_TABLE_TOKEN,
1014: p_token3_value => 'OKL_TXL_AR_INV_LNS_V');
1015:
1016: -- notify caller of en error

Line 1083: p_token2_value => 'OKL_TXL_ADJSTS_LNS_V',

1079: p_msg_name => G_NO_PARENT_RECORD,
1080: p_token1 => G_COL_NAME_TOKEN,
1081: p_token1_value => 'tld_id',
1082: p_token2 => G_CHILD_TABLE_TOKEN,
1083: p_token2_value => 'OKL_TXL_ADJSTS_LNS_V',
1084: p_token3 => G_PARENT_TABLE_TOKEN,
1085: p_token3_value => 'OKL_TXD_AR_LN_DTLS_V');
1086:
1087: -- notify caller of en error

Line 1154: p_token2_value => 'OKL_TXL_ADJSTS_LNS_V',

1150: p_msg_name => G_NO_PARENT_RECORD,
1151: p_token1 => G_COL_NAME_TOKEN,
1152: p_token1_value => 'code_combination_id',
1153: p_token2 => G_CHILD_TABLE_TOKEN,
1154: p_token2_value => 'OKL_TXL_ADJSTS_LNS_V',
1155: p_token3 => G_PARENT_TABLE_TOKEN,
1156: p_token3_value => 'GL_CODE_COMBINATIONS');
1157:
1158: -- notify caller of en error

Line 1223: p_token2_value => 'OKL_TXL_ADJSTS_LNS_V',

1219: p_msg_name => G_NO_PARENT_RECORD,
1220: p_token1 => G_COL_NAME_TOKEN,
1221: p_token1_value => 'psl_id',
1222: p_token2 => G_CHILD_TABLE_TOKEN,
1223: p_token2_value => 'OKL_TXL_ADJSTS_LNS_V',
1224: p_token3 => G_PARENT_TABLE_TOKEN,
1225: p_token3_value => 'AR_PAYMENT_SCHEDULES_ALL');
1226:
1227: -- notify caller of en error

Line 1262: -- Validate_Attributes for:OKL_TXL_ADJSTS_LNS_V --

1258: -- Post-Generation Change
1259: -- By RDRAGUIL on 24-MAY-2001
1260: ---------------------------------------------------------------------------
1261: --------------------------------------------------
1262: -- Validate_Attributes for:OKL_TXL_ADJSTS_LNS_V --
1263: --------------------------------------------------
1264: FUNCTION Validate_Attributes (
1265: p_ajlv_rec IN ajlv_rec_type
1266: ) RETURN VARCHAR2 IS

Line 1411: -- Validate_Record for:OKL_TXL_ADJSTS_LNS_V --

1407: ---------------------------------------------------------------------------
1408: -- PROCEDURE Validate_Record
1409: ---------------------------------------------------------------------------
1410: ----------------------------------------------
1411: -- Validate_Record for:OKL_TXL_ADJSTS_LNS_V --
1412: ----------------------------------------------
1413: FUNCTION Validate_Record (
1414: p_ajlv_rec IN ajlv_rec_type
1415: ) RETURN VARCHAR2 IS

Line 1545: -- validate_row for:OKL_TXL_ADJSTS_LNS_V --

1541: ---------------------------------------------------------------------------
1542: -- PROCEDURE validate_row
1543: ---------------------------------------------------------------------------
1544: -------------------------------------------
1545: -- validate_row for:OKL_TXL_ADJSTS_LNS_V --
1546: -------------------------------------------
1547: PROCEDURE validate_row(
1548: p_api_version IN NUMBER,
1549: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1982: -- insert_row for:OKL_TXL_ADJSTS_LNS_V --

1978: '_PVT'
1979: );
1980: END insert_row;
1981: -----------------------------------------
1982: -- insert_row for:OKL_TXL_ADJSTS_LNS_V --
1983: -----------------------------------------
1984: PROCEDURE insert_row(
1985: p_api_version IN NUMBER,
1986: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2018: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_V --

2014: l_ajlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2015: RETURN(l_ajlv_rec);
2016: END fill_who_columns;
2017: ---------------------------------------------
2018: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_V --
2019: ---------------------------------------------
2020: FUNCTION Set_Attributes (
2021: p_ajlv_rec IN ajlv_rec_type,
2022: x_ajlv_rec OUT NOCOPY ajlv_rec_type

Line 2435: -- lock_row for:OKL_TXL_ADJSTS_LNS_V --

2431: '_PVT'
2432: );
2433: END lock_row;
2434: ---------------------------------------
2435: -- lock_row for:OKL_TXL_ADJSTS_LNS_V --
2436: ---------------------------------------
2437: PROCEDURE lock_row(
2438: p_api_version IN NUMBER,
2439: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3080: -- update_row for:OKL_TXL_ADJSTS_LNS_V --

3076: '_PVT'
3077: );
3078: END update_row;
3079: -----------------------------------------
3080: -- update_row for:OKL_TXL_ADJSTS_LNS_V --
3081: -----------------------------------------
3082: PROCEDURE update_row(
3083: p_api_version IN NUMBER,
3084: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3295: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_V --

3291: END IF;
3292: RETURN(l_return_status);
3293: END populate_new_record;
3294: ---------------------------------------------
3295: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_V --
3296: ---------------------------------------------
3297: FUNCTION Set_Attributes (
3298: p_ajlv_rec IN ajlv_rec_type,
3299: x_ajlv_rec OUT NOCOPY ajlv_rec_type

Line 3672: -- delete_row for:OKL_TXL_ADJSTS_LNS_V --

3668: '_PVT'
3669: );
3670: END delete_row;
3671: -----------------------------------------
3672: -- delete_row for:OKL_TXL_ADJSTS_LNS_V --
3673: -----------------------------------------
3674: PROCEDURE delete_row(
3675: p_api_version IN NUMBER,
3676: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,