DBA Data[Home] [Help]

APPS.OKL_POT_PVT dependencies on OKL_POOL_TYPES_V

Line 94: -- FUNCTION get_rec for: OKL_POOL_TYPES_V

90: NULL;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_POOL_TYPES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_potv_rec IN potv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 130: FROM OKL_POOL_TYPES_V

126: CREATION_DATE,
127: LAST_UPDATED_BY,
128: LAST_UPDATE_DATE,
129: LAST_UPDATE_LOGIN
130: FROM OKL_POOL_TYPES_V
131: WHERE OKL_POOL_TYPES_V.id = p_id;
132: l_okl_potv_pk okl_potv_pk_csr%ROWTYPE;
133: l_potv_rec potv_rec_type;
134: BEGIN

Line 131: WHERE OKL_POOL_TYPES_V.id = p_id;

127: LAST_UPDATED_BY,
128: LAST_UPDATE_DATE,
129: LAST_UPDATE_LOGIN
130: FROM OKL_POOL_TYPES_V
131: WHERE OKL_POOL_TYPES_V.id = p_id;
132: l_okl_potv_pk okl_potv_pk_csr%ROWTYPE;
133: l_potv_rec potv_rec_type;
134: BEGIN
135: x_no_data_found := TRUE;

Line 309: -- FUNCTION null_out_defaults for: OKL_POOL_TYPES_V

305: RETURN(get_rec(p_pot_rec, l_row_not_found));
306: END get_rec;
307:
308: ---------------------------------------------------------------------------
309: -- FUNCTION null_out_defaults for: OKL_POOL_TYPES_V
310: -- mvasudev, hold this off for now
311: ---------------------------------------------------------------------------
312: FUNCTION null_out_defaults (
313: p_potv_rec IN potv_rec_type

Line 493: -- Validate_Attributes for:OKL_POOL_TYPES_V --

489: ---------------------------------------------------------------------------
490: -- FUNCTION Validate_Attributes
491: ---------------------------------------------------------------------------
492: ---------------------------------------------------
493: -- Validate_Attributes for:OKL_POOL_TYPES_V --
494: ---------------------------------------------------
495: FUNCTION Validate_Attributes (
496: p_potv_rec IN potv_rec_type
497: ) RETURN VARCHAR2 IS

Line 549: -- Validate Record for:OKL_POOL_TYPES_V --

545: ---------------------------------------------------------------------------
546: -- PROCEDURE Validate_Record
547: ---------------------------------------------------------------------------
548: -----------------------------------------
549: -- Validate Record for:OKL_POOL_TYPES_V --
550: -----------------------------------------
551: FUNCTION Validate_Record (
552: p_potv_rec IN potv_rec_type,
553: p_db_potv_rec IN potv_rec_type

Line 664: -- validate_row for:OKL_POOL_TYPES_V --

660: ---------------------------------------------------------------------------
661: -- PROCEDURE validate_row
662: ---------------------------------------------------------------------------
663: --------------------------------------------
664: -- validate_row for:OKL_POOL_TYPES_V --
665: --------------------------------------------
666: PROCEDURE validate_row(
667: p_api_version IN NUMBER,
668: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 741: -- PL/SQL TBL validate_row for:OKL_POOL_TYPES_V --

737: '_PVT'
738: );
739: END validate_row;
740: -------------------------------------------------------
741: -- PL/SQL TBL validate_row for:OKL_POOL_TYPES_V --
742: -------------------------------------------------------
743: PROCEDURE validate_row(
744: p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 837: -- PL/SQL TBL validate_row for:OKL_POOL_TYPES_V --

833: );
834: END validate_row;
835:
836: -------------------------------------------------------
837: -- PL/SQL TBL validate_row for:OKL_POOL_TYPES_V --
838: -------------------------------------------------------
839: PROCEDURE validate_row(
840: p_api_version IN NUMBER,
841: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1044: -- insert_row for :OKL_POOL_TYPES_V --

1040: '_PVT'
1041: );
1042: END insert_row;
1043: -------------------------------------------
1044: -- insert_row for :OKL_POOL_TYPES_V --
1045: -------------------------------------------
1046: PROCEDURE insert_row(
1047: p_api_version IN NUMBER,
1048: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1078: -- Set_Attributes for:OKL_POOL_TYPES_V --

1074: l_potv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1075: RETURN(l_potv_rec);
1076: END fill_who_columns;
1077: ----------------------------------------------
1078: -- Set_Attributes for:OKL_POOL_TYPES_V --
1079: ----------------------------------------------
1080: FUNCTION Set_Attributes (
1081: p_potv_rec IN potv_rec_type,
1082: x_potv_rec OUT NOCOPY potv_rec_type

Line 1461: -- lock_row for: OKL_POOL_TYPES_V --

1457: '_PVT'
1458: );
1459: END lock_row;
1460: -----------------------------------------
1461: -- lock_row for: OKL_POOL_TYPES_V --
1462: -----------------------------------------
1463: PROCEDURE lock_row(
1464: p_api_version IN NUMBER,
1465: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1953: -- update_row for:OKL_POOL_TYPES_V --

1949: '_PVT'
1950: );
1951: END update_row;
1952: ------------------------------------------
1953: -- update_row for:OKL_POOL_TYPES_V --
1954: ------------------------------------------
1955: PROCEDURE update_row(
1956: p_api_version IN NUMBER,
1957: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2117: -- Set_Attributes for:OKL_POOL_TYPES_V --

2113: END IF;
2114: RETURN(l_return_status);
2115: END populate_new_record;
2116: ----------------------------------------------
2117: -- Set_Attributes for:OKL_POOL_TYPES_V --
2118: ----------------------------------------------
2119: FUNCTION Set_Attributes (
2120: p_potv_rec IN potv_rec_type,
2121: x_potv_rec OUT NOCOPY potv_rec_type

Line 2475: -- delete_row for:OKL_POOL_TYPES_V --

2471: '_PVT'
2472: );
2473: END delete_row;
2474: ------------------------------------------
2475: -- delete_row for:OKL_POOL_TYPES_V --
2476: ------------------------------------------
2477: PROCEDURE delete_row(
2478: p_api_version IN NUMBER,
2479: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2557: -- PL/SQL TBL delete_row for:OKL_POOL_TYPES_V --

2553: '_PVT'
2554: );
2555: END delete_row;
2556: -----------------------------------------------------
2557: -- PL/SQL TBL delete_row for:OKL_POOL_TYPES_V --
2558: -----------------------------------------------------
2559: PROCEDURE delete_row(
2560: p_api_version IN NUMBER,
2561: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2653: -- PL/SQL TBL delete_row for:OKL_POOL_TYPES_V --

2649: );
2650: END delete_row;
2651:
2652: -----------------------------------------------------
2653: -- PL/SQL TBL delete_row for:OKL_POOL_TYPES_V --
2654: -----------------------------------------------------
2655: PROCEDURE delete_row(
2656: p_api_version IN NUMBER,
2657: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,