DBA Data[Home] [Help]

APPS.OKS_INTERACTION_HIST_PVT dependencies on OKS_INTERACTION_HIST_V

Line 94: -- FUNCTION get_rec for: OKS_INTERACTION_HIST_V

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

Line 119: FROM Oks_Interaction_Hist_V

115: LAST_UPDATE_DATE,
116: LAST_UPDATED_BY,
117: LAST_UPDATE_LOGIN,
118: OBJECT_VERSION_NUMBER
119: FROM Oks_Interaction_Hist_V
120: WHERE oks_interaction_hist_v.id = p_id;
121: l_inh_v_pk inh_v_pk_csr%ROWTYPE;
122: l_inhv_rec inhv_rec_type;
123: BEGIN

Line 120: WHERE oks_interaction_hist_v.id = p_id;

116: LAST_UPDATED_BY,
117: LAST_UPDATE_LOGIN,
118: OBJECT_VERSION_NUMBER
119: FROM Oks_Interaction_Hist_V
120: WHERE oks_interaction_hist_v.id = p_id;
121: l_inh_v_pk inh_v_pk_csr%ROWTYPE;
122: l_inhv_rec inhv_rec_type;
123: BEGIN
124: x_no_data_found := TRUE;

Line 264: -- FUNCTION null_out_defaults for: OKS_INTERACTION_HIST_V

260: BEGIN
261: RETURN(get_rec(p_inh_rec, l_row_not_found));
262: END get_rec;
263: ---------------------------------------------------------------------------
264: -- FUNCTION null_out_defaults for: OKS_INTERACTION_HIST_V
265: ---------------------------------------------------------------------------
266: FUNCTION null_out_defaults (
267: p_inhv_rec IN inhv_rec_type
268: ) RETURN inhv_rec_type IS

Line 355: -- Validate_Attributes for:OKS_INTERACTION_HIST_V --

351: ---------------------------------------------------------------------------
352: -- FUNCTION Validate_Attributes
353: ---------------------------------------------------------------------------
354: ----------------------------------------------------
355: -- Validate_Attributes for:OKS_INTERACTION_HIST_V --
356: ----------------------------------------------------
357: FUNCTION Validate_Attributes (
358: p_inhv_rec IN inhv_rec_type
359: ) RETURN VARCHAR2 IS

Line 393: -- Validate Record for:OKS_INTERACTION_HIST_V --

389: ---------------------------------------------------------------------------
390: -- PROCEDURE Validate_Record
391: ---------------------------------------------------------------------------
392: ------------------------------------------------
393: -- Validate Record for:OKS_INTERACTION_HIST_V --
394: ------------------------------------------------
395: FUNCTION Validate_Record (
396: p_inhv_rec IN inhv_rec_type,
397: p_db_inhv_rec IN inhv_rec_type

Line 467: -- validate_row for:OKS_INTERACTION_HIST_V --

463: ---------------------------------------------------------------------------
464: -- PROCEDURE validate_row
465: ---------------------------------------------------------------------------
466: ---------------------------------------------
467: -- validate_row for:OKS_INTERACTION_HIST_V --
468: ---------------------------------------------
469: PROCEDURE validate_row(
470: p_api_version IN NUMBER,
471: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 544: -- PL/SQL TBL validate_row for:OKS_INTERACTION_HIST_V --

540: '_PVT'
541: );
542: END validate_row;
543: --------------------------------------------------------
544: -- PL/SQL TBL validate_row for:OKS_INTERACTION_HIST_V --
545: --------------------------------------------------------
546: PROCEDURE validate_row(
547: p_api_version IN NUMBER,
548: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 640: -- PL/SQL TBL validate_row for:OKS_INTERACTION_HIST_V --

636: );
637: END validate_row;
638:
639: --------------------------------------------------------
640: -- PL/SQL TBL validate_row for:OKS_INTERACTION_HIST_V --
641: --------------------------------------------------------
642: PROCEDURE validate_row(
643: p_api_version IN NUMBER,
644: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 825: -- insert_row for :OKS_INTERACTION_HIST_V --

821: '_PVT'
822: );
823: END insert_row;
824: --------------------------------------------
825: -- insert_row for :OKS_INTERACTION_HIST_V --
826: --------------------------------------------
827: PROCEDURE insert_row(
828: p_api_version IN NUMBER,
829: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 859: -- Set_Attributes for:OKS_INTERACTION_HIST_V --

855: l_inhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
856: RETURN(l_inhv_rec);
857: END fill_who_columns;
858: -----------------------------------------------
859: -- Set_Attributes for:OKS_INTERACTION_HIST_V --
860: -----------------------------------------------
861: FUNCTION Set_Attributes (
862: p_inhv_rec IN inhv_rec_type,
863: x_inhv_rec OUT NOCOPY inhv_rec_type

Line 1242: -- lock_row for: OKS_INTERACTION_HIST_V --

1238: '_PVT'
1239: );
1240: END lock_row;
1241: ------------------------------------------
1242: -- lock_row for: OKS_INTERACTION_HIST_V --
1243: ------------------------------------------
1244: PROCEDURE lock_row(
1245: p_api_version IN NUMBER,
1246: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1678: -- update_row for:OKS_INTERACTION_HIST_V --

1674: '_PVT'
1675: );
1676: END update_row;
1677: -------------------------------------------
1678: -- update_row for:OKS_INTERACTION_HIST_V --
1679: -------------------------------------------
1680: PROCEDURE update_row(
1681: p_api_version IN NUMBER,
1682: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1794: -- Set_Attributes for:OKS_INTERACTION_HIST_V --

1790: END IF;
1791: RETURN(l_return_status);
1792: END populate_new_record;
1793: -----------------------------------------------
1794: -- Set_Attributes for:OKS_INTERACTION_HIST_V --
1795: -----------------------------------------------
1796: FUNCTION Set_Attributes (
1797: p_inhv_rec IN inhv_rec_type,
1798: x_inhv_rec OUT NOCOPY inhv_rec_type

Line 2149: -- delete_row for:OKS_INTERACTION_HIST_V --

2145: '_PVT'
2146: );
2147: END delete_row;
2148: -------------------------------------------
2149: -- delete_row for:OKS_INTERACTION_HIST_V --
2150: -------------------------------------------
2151: PROCEDURE delete_row(
2152: p_api_version IN NUMBER,
2153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2231: -- PL/SQL TBL delete_row for:OKS_INTERACTION_HIST_V --

2227: '_PVT'
2228: );
2229: END delete_row;
2230: ------------------------------------------------------
2231: -- PL/SQL TBL delete_row for:OKS_INTERACTION_HIST_V --
2232: ------------------------------------------------------
2233: PROCEDURE delete_row(
2234: p_api_version IN NUMBER,
2235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2327: -- PL/SQL TBL delete_row for:OKS_INTERACTION_HIST_V --

2323: );
2324: END delete_row;
2325:
2326: ------------------------------------------------------
2327: -- PL/SQL TBL delete_row for:OKS_INTERACTION_HIST_V --
2328: ------------------------------------------------------
2329: PROCEDURE delete_row(
2330: p_api_version IN NUMBER,
2331: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,