DBA Data[Home] [Help]

APPS.OKL_VCR_PVT dependencies on OKL_VP_CHANGE_REQUESTS_V

Line 94: -- FUNCTION get_rec for: OKL_VP_CHANGE_REQUESTS_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_VP_CHANGE_REQUESTS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_vcrv_rec IN vcrv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 139: FROM Okl_Vp_Change_Requests_V

135: CREATION_DATE,
136: LAST_UPDATED_BY,
137: LAST_UPDATE_DATE,
138: LAST_UPDATE_LOGIN
139: FROM Okl_Vp_Change_Requests_V
140: WHERE okl_vp_change_requests_v.id = p_id;
141: l_okl_vp_change_requests_v_pk okl_vp_change_reque1%ROWTYPE;
142: l_vcrv_rec vcrv_rec_type;
143: BEGIN

Line 140: WHERE okl_vp_change_requests_v.id = p_id;

136: LAST_UPDATED_BY,
137: LAST_UPDATE_DATE,
138: LAST_UPDATE_LOGIN
139: FROM Okl_Vp_Change_Requests_V
140: WHERE okl_vp_change_requests_v.id = p_id;
141: l_okl_vp_change_requests_v_pk okl_vp_change_reque1%ROWTYPE;
142: l_vcrv_rec vcrv_rec_type;
143: BEGIN
144: x_no_data_found := TRUE;

Line 141: l_okl_vp_change_requests_v_pk okl_vp_change_reque1%ROWTYPE;

137: LAST_UPDATE_DATE,
138: LAST_UPDATE_LOGIN
139: FROM Okl_Vp_Change_Requests_V
140: WHERE okl_vp_change_requests_v.id = p_id;
141: l_okl_vp_change_requests_v_pk okl_vp_change_reque1%ROWTYPE;
142: l_vcrv_rec vcrv_rec_type;
143: BEGIN
144: x_no_data_found := TRUE;
145: -- Get current database values

Line 344: -- FUNCTION null_out_defaults for: OKL_VP_CHANGE_REQUESTS_V

340: BEGIN
341: RETURN(get_rec(p_vcr_rec, l_row_not_found));
342: END get_rec;
343: ---------------------------------------------------------------------------
344: -- FUNCTION null_out_defaults for: OKL_VP_CHANGE_REQUESTS_V
345: ---------------------------------------------------------------------------
346: FUNCTION null_out_defaults (
347: p_vcrv_rec IN vcrv_rec_type
348: ) RETURN vcrv_rec_type IS

Line 678: -- Validate_Attributes for:OKL_VP_CHANGE_REQUESTS_V --

674: ---------------------------------------------------------------------------
675: -- FUNCTION Validate_Attributes
676: ---------------------------------------------------------------------------
677: ------------------------------------------------------
678: -- Validate_Attributes for:OKL_VP_CHANGE_REQUESTS_V --
679: ------------------------------------------------------
680: FUNCTION Validate_Attributes (
681: p_vcrv_rec IN vcrv_rec_type
682: ) RETURN VARCHAR2 IS

Line 761: -- Validate Record for:OKL_VP_CHANGE_REQUESTS_V --

757: ---------------------------------------------------------------------------
758: -- PROCEDURE Validate_Record
759: ---------------------------------------------------------------------------
760: --------------------------------------------------
761: -- Validate Record for:OKL_VP_CHANGE_REQUESTS_V --
762: --------------------------------------------------
763: FUNCTION Validate_Record (
764: p_vcrv_rec IN vcrv_rec_type,
765: p_db_vcrv_rec IN vcrv_rec_type

Line 875: -- validate_row for:OKL_VP_CHANGE_REQUESTS_V --

871: ---------------------------------------------------------------------------
872: -- PROCEDURE validate_row
873: ---------------------------------------------------------------------------
874: -----------------------------------------------
875: -- validate_row for:OKL_VP_CHANGE_REQUESTS_V --
876: -----------------------------------------------
877: PROCEDURE validate_row(
878: p_api_version IN NUMBER,
879: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 952: -- PL/SQL TBL validate_row for:OKL_VP_CHANGE_REQUESTS_V --

948: '_PVT'
949: );
950: END validate_row;
951: ----------------------------------------------------------
952: -- PL/SQL TBL validate_row for:OKL_VP_CHANGE_REQUESTS_V --
953: ----------------------------------------------------------
954: PROCEDURE validate_row(
955: p_api_version IN NUMBER,
956: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1048: -- PL/SQL TBL validate_row for:OKL_VP_CHANGE_REQUESTS_V --

1044: );
1045: END validate_row;
1046:
1047: ----------------------------------------------------------
1048: -- PL/SQL TBL validate_row for:OKL_VP_CHANGE_REQUESTS_V --
1049: ----------------------------------------------------------
1050: PROCEDURE validate_row(
1051: p_api_version IN NUMBER,
1052: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1273: -- insert_row for :OKL_VP_CHANGE_REQUESTS_V --

1269: '_PVT'
1270: );
1271: END insert_row;
1272: ----------------------------------------------
1273: -- insert_row for :OKL_VP_CHANGE_REQUESTS_V --
1274: ----------------------------------------------
1275: PROCEDURE insert_row(
1276: p_api_version IN NUMBER,
1277: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1307: -- Set_Attributes for:OKL_VP_CHANGE_REQUESTS_V --

1303: l_vcrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1304: RETURN(l_vcrv_rec);
1305: END fill_who_columns;
1306: -------------------------------------------------
1307: -- Set_Attributes for:OKL_VP_CHANGE_REQUESTS_V --
1308: -------------------------------------------------
1309: FUNCTION Set_Attributes (
1310: p_vcrv_rec IN vcrv_rec_type,
1311: x_vcrv_rec OUT NOCOPY vcrv_rec_type

Line 1690: -- lock_row for: OKL_VP_CHANGE_REQUESTS_V --

1686: '_PVT'
1687: );
1688: END lock_row;
1689: --------------------------------------------
1690: -- lock_row for: OKL_VP_CHANGE_REQUESTS_V --
1691: --------------------------------------------
1692: PROCEDURE lock_row(
1693: p_api_version IN NUMBER,
1694: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2226: -- update_row for:OKL_VP_CHANGE_REQUESTS_V --

2222: '_PVT'
2223: );
2224: END update_row;
2225: ---------------------------------------------
2226: -- update_row for:OKL_VP_CHANGE_REQUESTS_V --
2227: ---------------------------------------------
2228: PROCEDURE update_row(
2229: p_api_version IN NUMBER,
2230: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2422: -- Set_Attributes for:OKL_VP_CHANGE_REQUESTS_V --

2418: END IF;
2419: RETURN(l_return_status);
2420: END populate_new_record;
2421: -------------------------------------------------
2422: -- Set_Attributes for:OKL_VP_CHANGE_REQUESTS_V --
2423: -------------------------------------------------
2424: FUNCTION Set_Attributes (
2425: p_vcrv_rec IN vcrv_rec_type,
2426: x_vcrv_rec OUT NOCOPY vcrv_rec_type

Line 2778: -- delete_row for:OKL_VP_CHANGE_REQUESTS_V --

2774: '_PVT'
2775: );
2776: END delete_row;
2777: ---------------------------------------------
2778: -- delete_row for:OKL_VP_CHANGE_REQUESTS_V --
2779: ---------------------------------------------
2780: PROCEDURE delete_row(
2781: p_api_version IN NUMBER,
2782: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2860: -- PL/SQL TBL delete_row for:OKL_VP_CHANGE_REQUESTS_V --

2856: '_PVT'
2857: );
2858: END delete_row;
2859: --------------------------------------------------------
2860: -- PL/SQL TBL delete_row for:OKL_VP_CHANGE_REQUESTS_V --
2861: --------------------------------------------------------
2862: PROCEDURE delete_row(
2863: p_api_version IN NUMBER,
2864: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2956: -- PL/SQL TBL delete_row for:OKL_VP_CHANGE_REQUESTS_V --

2952: );
2953: END delete_row;
2954:
2955: --------------------------------------------------------
2956: -- PL/SQL TBL delete_row for:OKL_VP_CHANGE_REQUESTS_V --
2957: --------------------------------------------------------
2958: PROCEDURE delete_row(
2959: p_api_version IN NUMBER,
2960: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,