DBA Data[Home] [Help]

APPS.OKL_TPL_PVT dependencies on OKL_TXL_AP_INV_LNS_V

Line 531: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',

527: p_msg_name => g_no_parent_record,
528: p_token1 => g_col_name_token,
529: p_token1_value => 'code_combination_id',
530: p_token2 => g_child_table_token,
531: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',
532: p_token3 => g_parent_table_token,
533: p_token3_value => 'OKX_CODE_COMBINATIONS_V');
534:
535: x_return_status := OKL_Api.G_RET_STS_ERROR;

Line 624: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',

620: p_msg_name => g_no_parent_record,
621: p_token1 => g_col_name_token,
622: p_token1_value => 'itc_id',
623: p_token2 => g_child_table_token,
624: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',
625: p_token3 => g_parent_table_token,
626: p_token3_value => 'OKX_TAX_CODES_V');
627:
628: x_return_status := OKL_Api.G_RET_STS_ERROR;

Line 716: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',

712: p_msg_name => g_no_parent_record,
713: p_token1 => g_col_name_token,
714: p_token1_value => 'kle_id',
715: p_token2 => g_child_table_token,
716: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',
717: p_token3 => g_parent_table_token,
718: p_token3_value => 'OKL_K_LINES_V');
719:
720: x_return_status := OKL_Api.G_RET_STS_ERROR;

Line 808: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',

804: p_msg_name => g_no_parent_record,
805: p_token1 => g_col_name_token,
806: p_token1_value => 'lsm_id',
807: p_token2 => g_child_table_token,
808: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',
809: p_token3 => g_parent_table_token,
810: p_token3_value => 'OKL_CNSLD_AR_STRMS_V');
811:
812: x_return_status := OKL_Api.G_RET_STS_ERROR;

Line 900: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',

896: p_msg_name => g_no_parent_record,
897: p_token1 => g_col_name_token,
898: p_token1_value => 'sty_id',
899: p_token2 => g_child_table_token,
900: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',
901: p_token3 => g_parent_table_token,
902: p_token3_value => 'OKL_STRM_TYPE_V');
903:
904: x_return_status := OKL_Api.G_RET_STS_ERROR;

Line 950: FROM OKL_TXL_AP_INV_LNS_V

946: l_dummy_var VARCHAR2(1) := '?';
947:
948: CURSOR l_tplv_csr IS
949: SELECT 'x'
950: FROM OKL_TXL_AP_INV_LNS_V
951: WHERE id = p_tplv_rec.tpl_id_reverses;
952:
953: BEGIN
954:

Line 992: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',

988: p_msg_name => g_no_parent_record,
989: p_token1 => g_col_name_token,
990: p_token1_value => 'tpl_id_reverses',
991: p_token2 => g_child_table_token,
992: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',
993: p_token3 => g_parent_table_token,
994: p_token3_value => 'OKL_TXL_AP_INV_LNS_V');
995:
996: x_return_status := OKL_Api.G_RET_STS_ERROR;

Line 994: p_token3_value => 'OKL_TXL_AP_INV_LNS_V');

990: p_token1_value => 'tpl_id_reverses',
991: p_token2 => g_child_table_token,
992: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',
993: p_token3 => g_parent_table_token,
994: p_token3_value => 'OKL_TXL_AP_INV_LNS_V');
995:
996: x_return_status := OKL_Api.G_RET_STS_ERROR;
997:
998: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1077: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',

1073: p_msg_name => g_no_parent_record,
1074: p_token1 => g_col_name_token,
1075: p_token1_value => 'tap_id',
1076: p_token2 => g_child_table_token,
1077: p_token2_value => 'OKL_TXL_AP_INV_LNS_V',
1078: p_token3 => g_parent_table_token,
1079: p_token3_value => 'OKL_TRX_AP_INVOICES_V');
1080:
1081: x_return_status := OKL_Api.G_RET_STS_ERROR;

Line 1512: -- FUNCTION get_rec for: OKL_TXL_AP_INV_LNS_V

1508: BEGIN
1509: RETURN(get_rec(p_okl_txl_ap_inv_lns_tl_rec, l_row_notfound));
1510: END get_rec;
1511: ---------------------------------------------------------------------------
1512: -- FUNCTION get_rec for: OKL_TXL_AP_INV_LNS_V
1513: ---------------------------------------------------------------------------
1514: FUNCTION get_rec (
1515: p_tplv_rec IN tplv_rec_type,
1516: x_no_data_found OUT NOCOPY BOOLEAN

Line 1570: FROM Okl_Txl_Ap_Inv_Lns_V

1566: --start:| 14-May-07 cklee -- added TLD_ID column |
1567: TLD_ID,
1568: --end:| 14-May-07 cklee -- added TLD_ID column |
1569: SEL_ID
1570: FROM Okl_Txl_Ap_Inv_Lns_V
1571: WHERE okl_txl_ap_inv_lns_v.id = p_id;
1572: l_okl_tplv_pk okl_tplv_pk_csr%ROWTYPE;
1573: l_tplv_rec tplv_rec_type;
1574: BEGIN

Line 1571: WHERE okl_txl_ap_inv_lns_v.id = p_id;

1567: TLD_ID,
1568: --end:| 14-May-07 cklee -- added TLD_ID column |
1569: SEL_ID
1570: FROM Okl_Txl_Ap_Inv_Lns_V
1571: WHERE okl_txl_ap_inv_lns_v.id = p_id;
1572: l_okl_tplv_pk okl_tplv_pk_csr%ROWTYPE;
1573: l_tplv_rec tplv_rec_type;
1574: BEGIN
1575: x_no_data_found := TRUE;

Line 1643: -- FUNCTION null_out_defaults for: OKL_TXL_AP_INV_LNS_V --

1639: RETURN(get_rec(p_tplv_rec, l_row_notfound));
1640: END get_rec;
1641:
1642: ----------------------------------------------------------
1643: -- FUNCTION null_out_defaults for: OKL_TXL_AP_INV_LNS_V --
1644: ----------------------------------------------------------
1645: FUNCTION null_out_defaults (
1646: p_tplv_rec IN tplv_rec_type
1647: ) RETURN tplv_rec_type IS

Line 1815: -- PROCEDURE Validate_Attributes for:OKL_TXL_AP_INV_LNS_V : Modified for PostGen-12

1811: RETURN(l_tplv_rec);
1812: END null_out_defaults;
1813:
1814: -----------------------------------------------------------------------------------
1815: -- PROCEDURE Validate_Attributes for:OKL_TXL_AP_INV_LNS_V : Modified for PostGen-12
1816: -----------------------------------------------------------------------------------
1817: FUNCTION Validate_Attributes
1818: ( p_tplv_rec IN tplv_rec_type
1819: ) RETURN VARCHAR2 IS

Line 2063: -- PROCEDURE Validate_Record for:OKL_TXL_AP_INV_LNS_V : Modified for PostGen-13

2059:
2060: END Validate_Attributes;
2061:
2062: -------------------------------------------------------------------------------
2063: -- PROCEDURE Validate_Record for:OKL_TXL_AP_INV_LNS_V : Modified for PostGen-13
2064: -------------------------------------------------------------------------------
2065: FUNCTION Validate_Record
2066: ( p_tplv_rec IN tplv_rec_type
2067: ) RETURN VARCHAR2 IS

Line 2249: -- validate_row for:OKL_TXL_AP_INV_LNS_V --

2245: ---------------------------------------------------------------------------
2246: -- PROCEDURE validate_row
2247: ---------------------------------------------------------------------------
2248: -------------------------------------------
2249: -- validate_row for:OKL_TXL_AP_INV_LNS_V --
2250: -------------------------------------------
2251: PROCEDURE validate_row(
2252: p_api_version IN NUMBER,
2253: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2711: -- insert_row for:OKL_TXL_AP_INV_LNS_V --

2707: '_PVT'
2708: );
2709: END insert_row;
2710: -----------------------------------------
2711: -- insert_row for:OKL_TXL_AP_INV_LNS_V --
2712: -----------------------------------------
2713: PROCEDURE insert_row(
2714: p_api_version IN NUMBER,
2715: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2747: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_V --

2743: l_tplv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2744: RETURN(l_tplv_rec);
2745: END fill_who_columns;
2746: ---------------------------------------------
2747: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_V --
2748: ---------------------------------------------
2749: FUNCTION Set_Attributes (
2750: p_tplv_rec IN tplv_rec_type,
2751: x_tplv_rec OUT NOCOPY tplv_rec_type

Line 3161: -- lock_row for:OKL_TXL_AP_INV_LNS_V --

3157: '_PVT'
3158: );
3159: END lock_row;
3160: ---------------------------------------
3161: -- lock_row for:OKL_TXL_AP_INV_LNS_V --
3162: ---------------------------------------
3163: PROCEDURE lock_row(
3164: p_api_version IN NUMBER,
3165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3873: -- update_row for:OKL_TXL_AP_INV_LNS_V --

3869: '_PVT'
3870: );
3871: END update_row;
3872: -----------------------------------------
3873: -- update_row for:OKL_TXL_AP_INV_LNS_V --
3874: -----------------------------------------
3875: PROCEDURE update_row(
3876: p_api_version IN NUMBER,
3877: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4142: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_V --

4138:
4139: RETURN(l_return_status);
4140: END populate_new_record;
4141: ---------------------------------------------
4142: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_V --
4143: ---------------------------------------------
4144: FUNCTION Set_Attributes (
4145: p_tplv_rec IN tplv_rec_type,
4146: x_tplv_rec OUT NOCOPY tplv_rec_type

Line 4516: -- delete_row for:OKL_TXL_AP_INV_LNS_V --

4512: '_PVT'
4513: );
4514: END delete_row;
4515: -----------------------------------------
4516: -- delete_row for:OKL_TXL_AP_INV_LNS_V --
4517: -----------------------------------------
4518: PROCEDURE delete_row(
4519: p_api_version IN NUMBER,
4520: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,