DBA Data[Home] [Help]

APPS.OKL_ADJ_PVT dependencies on OKL_TRX_AR_ADJSTS_V

Line 17: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TRX_AR_ADJSTS_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_TRX_AR_ADJSTS_V';
18: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19:
20: ---------------------------------------------------------------------------
21: -- FUNCTION get_seq_id

Line 288: -- FUNCTION get_rec for: OKL_TRX_AR_ADJSTS_V

284: BEGIN
285: RETURN(get_rec(p_okl_trx_ar_adjsts_tl_rec, l_row_notfound));
286: END get_rec;
287: ---------------------------------------------------------------------------
288: -- FUNCTION get_rec for: OKL_TRX_AR_ADJSTS_V
289: ---------------------------------------------------------------------------
290: FUNCTION get_rec (
291: p_adjv_rec IN adjv_rec_type,
292: x_no_data_found OUT NOCOPY BOOLEAN

Line 336: FROM Okl_Trx_Ar_Adjsts_V

332: LAST_UPDATE_LOGIN,
333: --gkhuntet start 02-Nov-07
334: TRANSACTION_DATE
335: --gkhuntet end 02-Nov-07
336: FROM Okl_Trx_Ar_Adjsts_V
337: WHERE okl_trx_ar_adjsts_v.id = p_id;
338: l_okl_adjv_pk okl_adjv_pk_csr%ROWTYPE;
339: l_adjv_rec adjv_rec_type;
340: BEGIN

Line 337: WHERE okl_trx_ar_adjsts_v.id = p_id;

333: --gkhuntet start 02-Nov-07
334: TRANSACTION_DATE
335: --gkhuntet end 02-Nov-07
336: FROM Okl_Trx_Ar_Adjsts_V
337: WHERE okl_trx_ar_adjsts_v.id = p_id;
338: l_okl_adjv_pk okl_adjv_pk_csr%ROWTYPE;
339: l_adjv_rec adjv_rec_type;
340: BEGIN
341: x_no_data_found := TRUE;

Line 399: -- FUNCTION null_out_defaults for: OKL_TRX_AR_ADJSTS_V --

395: RETURN(get_rec(p_adjv_rec, l_row_notfound));
396: END get_rec;
397:
398: ---------------------------------------------------------
399: -- FUNCTION null_out_defaults for: OKL_TRX_AR_ADJSTS_V --
400: ---------------------------------------------------------
401: FUNCTION null_out_defaults (
402: p_adjv_rec IN adjv_rec_type
403: ) RETURN adjv_rec_type IS

Line 925: p_token2_value => 'OKL_TRX_AR_ADJSTS_V',

921: p_msg_name => G_NO_PARENT_RECORD,
922: p_token1 => G_COL_NAME_TOKEN,
923: p_token1_value => 'ccw_id',
924: p_token2 => G_CHILD_TABLE_TOKEN,
925: p_token2_value => 'OKL_TRX_AR_ADJSTS_V',
926: p_token3 => G_PARENT_TABLE_TOKEN,
927: p_token3_value => 'OKL_CSE_K_WRITEOFFS_V');
928:
929: -- notify caller of en error

Line 999: p_token2_value => 'OKL_TRX_AR_ADJSTS_V',

995: p_msg_name => G_NO_PARENT_RECORD,
996: p_token1 => G_COL_NAME_TOKEN,
997: p_token1_value => 'tcn_id',
998: p_token2 => G_CHILD_TABLE_TOKEN,
999: p_token2_value => 'OKL_TRX_AR_ADJSTS_V',
1000: p_token3 => G_PARENT_TABLE_TOKEN,
1001: p_token3_value => 'OKL_TRX_CONTRACTS');
1002:
1003: -- notify caller of en error

Line 1043: -- Validate_Attributes for:OKL_TRX_AR_ADJSTS_V --

1039: -- Post-Generation Change
1040: -- By RDRAGUIL on 24-MAY-2001
1041: ---------------------------------------------------------------------------
1042: -------------------------------------------------
1043: -- Validate_Attributes for:OKL_TRX_AR_ADJSTS_V --
1044: -------------------------------------------------
1045: FUNCTION Validate_Attributes (
1046: p_adjv_rec IN adjv_rec_type
1047: ) RETURN VARCHAR2 IS

Line 1175: -- Validate_Record for:OKL_TRX_AR_ADJSTS_V --

1171: ---------------------------------------------------------------------------
1172: -- PROCEDURE Validate_Record
1173: ---------------------------------------------------------------------------
1174: ---------------------------------------------
1175: -- Validate_Record for:OKL_TRX_AR_ADJSTS_V --
1176: ---------------------------------------------
1177: FUNCTION Validate_Record (
1178: p_adjv_rec IN adjv_rec_type
1179: ) RETURN VARCHAR2 IS

Line 1310: -- validate_row for:OKL_TRX_AR_ADJSTS_V --

1306: ---------------------------------------------------------------------------
1307: -- PROCEDURE validate_row
1308: ---------------------------------------------------------------------------
1309: ------------------------------------------
1310: -- validate_row for:OKL_TRX_AR_ADJSTS_V --
1311: ------------------------------------------
1312: PROCEDURE validate_row(
1313: p_api_version IN NUMBER,
1314: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1758: -- insert_row for:OKL_TRX_AR_ADJSTS_V --

1754: '_PVT'
1755: );
1756: END insert_row;
1757: ----------------------------------------
1758: -- insert_row for:OKL_TRX_AR_ADJSTS_V --
1759: ----------------------------------------
1760: PROCEDURE insert_row(
1761: p_api_version IN NUMBER,
1762: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1794: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_V --

1790: l_adjv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1791: RETURN(l_adjv_rec);
1792: END fill_who_columns;
1793: --------------------------------------------
1794: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_V --
1795: --------------------------------------------
1796: FUNCTION Set_Attributes (
1797: p_adjv_rec IN adjv_rec_type,
1798: x_adjv_rec OUT NOCOPY adjv_rec_type

Line 2219: -- lock_row for:OKL_TRX_AR_ADJSTS_V --

2215: '_PVT'
2216: );
2217: END lock_row;
2218: --------------------------------------
2219: -- lock_row for:OKL_TRX_AR_ADJSTS_V --
2220: --------------------------------------
2221: PROCEDURE lock_row(
2222: p_api_version IN NUMBER,
2223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2868: -- update_row for:OKL_TRX_AR_ADJSTS_V --

2864: '_PVT'
2865: );
2866: END update_row;
2867: ----------------------------------------
2868: -- update_row for:OKL_TRX_AR_ADJSTS_V --
2869: ----------------------------------------
2870: PROCEDURE update_row(
2871: p_api_version IN NUMBER,
2872: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3076: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_V --

3072: --gkhuntet end 02-Nov-07
3073: RETURN(l_return_status);
3074: END populate_new_record;
3075: --------------------------------------------
3076: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_V --
3077: --------------------------------------------
3078: FUNCTION Set_Attributes (
3079: p_adjv_rec IN adjv_rec_type,
3080: x_adjv_rec OUT NOCOPY adjv_rec_type

Line 3458: -- delete_row for:OKL_TRX_AR_ADJSTS_V --

3454: '_PVT'
3455: );
3456: END delete_row;
3457: ----------------------------------------
3458: -- delete_row for:OKL_TRX_AR_ADJSTS_V --
3459: ----------------------------------------
3460: PROCEDURE delete_row(
3461: p_api_version IN NUMBER,
3462: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,