DBA Data[Home] [Help]

APPS.OKS_IHD_PVT dependencies on OKS_INST_HIST_DETAILS_V

Line 94: -- FUNCTION get_rec for: OKS_INST_HIST_DETAILS_V

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

Line 144: FROM Oks_Inst_Hist_Details_V

140: LAST_UPDATE_LOGIN,
141: OBJECT_VERSION_NUMBER,
142: SECURITY_GROUP_ID,
143: DATE_CANCELLED
144: FROM Oks_Inst_Hist_Details_V
145: WHERE oks_inst_hist_details_v.id = p_id;
146: l_oks_ihdv_pk oks_ihdv_pk_csr%ROWTYPE;
147: l_ihdv_rec ihdv_rec_type;
148: BEGIN

Line 145: WHERE oks_inst_hist_details_v.id = p_id;

141: OBJECT_VERSION_NUMBER,
142: SECURITY_GROUP_ID,
143: DATE_CANCELLED
144: FROM Oks_Inst_Hist_Details_V
145: WHERE oks_inst_hist_details_v.id = p_id;
146: l_oks_ihdv_pk oks_ihdv_pk_csr%ROWTYPE;
147: l_ihdv_rec ihdv_rec_type;
148: BEGIN
149: x_no_data_found := TRUE;

Line 362: -- FUNCTION null_out_defaults for: OKS_INST_HIST_DETAILS_V

358: BEGIN
359: RETURN(get_rec(p_ihd_rec, l_row_not_found));
360: END get_rec;
361: ---------------------------------------------------------------------------
362: -- FUNCTION null_out_defaults for: OKS_INST_HIST_DETAILS_V
363: ---------------------------------------------------------------------------
364: FUNCTION null_out_defaults (
365: p_ihdv_rec IN ihdv_rec_type
366: ) RETURN ihdv_rec_type IS

Line 555: -- Validate_Attributes for:OKS_INST_HIST_DETAILS_V --

551: ---------------------------------------------------------------------------
552: -- FUNCTION Validate_Attributes
553: ---------------------------------------------------------------------------
554: -----------------------------------------------------
555: -- Validate_Attributes for:OKS_INST_HIST_DETAILS_V --
556: -----------------------------------------------------
557: FUNCTION Validate_Attributes (
558: p_ihdv_rec IN ihdv_rec_type
559: ) RETURN VARCHAR2 IS

Line 602: -- Validate Record for:OKS_INST_HIST_DETAILS_V --

598: ---------------------------------------------------------------------------
599: -- PROCEDURE Validate_Record
600: ---------------------------------------------------------------------------
601: -------------------------------------------------
602: -- Validate Record for:OKS_INST_HIST_DETAILS_V --
603: -------------------------------------------------
604: FUNCTION Validate_Record (
605: p_ihdv_rec IN ihdv_rec_type,
606: p_db_ihdv_rec IN ihdv_rec_type

Line 724: -- validate_row for:OKS_INST_HIST_DETAILS_V --

720: ---------------------------------------------------------------------------
721: -- PROCEDURE validate_row
722: ---------------------------------------------------------------------------
723: ----------------------------------------------
724: -- validate_row for:OKS_INST_HIST_DETAILS_V --
725: ----------------------------------------------
726: PROCEDURE validate_row(
727: p_api_version IN NUMBER,
728: p_init_msg_list IN VARCHAR2,

Line 801: -- PL/SQL TBL validate_row for:OKS_INST_HIST_DETAILS_V --

797: '_PVT'
798: );
799: END validate_row;
800: ---------------------------------------------------------
801: -- PL/SQL TBL validate_row for:OKS_INST_HIST_DETAILS_V --
802: ---------------------------------------------------------
803: PROCEDURE validate_row(
804: p_api_version IN NUMBER,
805: p_init_msg_list IN VARCHAR2,

Line 897: -- PL/SQL TBL validate_row for:OKS_INST_HIST_DETAILS_V --

893: );
894: END validate_row;
895:
896: ---------------------------------------------------------
897: -- PL/SQL TBL validate_row for:OKS_INST_HIST_DETAILS_V --
898: ---------------------------------------------------------
899: PROCEDURE validate_row(
900: p_api_version IN NUMBER,
901: p_init_msg_list IN VARCHAR2,

Line 1130: -- insert_row for :OKS_INST_HIST_DETAILS_V --

1126: '_PVT'
1127: );
1128: END insert_row;
1129: ---------------------------------------------
1130: -- insert_row for :OKS_INST_HIST_DETAILS_V --
1131: ---------------------------------------------
1132: PROCEDURE insert_row(
1133: p_api_version IN NUMBER,
1134: p_init_msg_list IN VARCHAR2,

Line 1164: -- Set_Attributes for:OKS_INST_HIST_DETAILS_V --

1160: l_ihdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1161: RETURN(l_ihdv_rec);
1162: END fill_who_columns;
1163: ------------------------------------------------
1164: -- Set_Attributes for:OKS_INST_HIST_DETAILS_V --
1165: ------------------------------------------------
1166: FUNCTION Set_Attributes (
1167: p_ihdv_rec IN ihdv_rec_type,
1168: x_ihdv_rec OUT NOCOPY ihdv_rec_type

Line 1549: -- lock_row for: OKS_INST_HIST_DETAILS_V --

1545: '_PVT'
1546: );
1547: END lock_row;
1548: -------------------------------------------
1549: -- lock_row for: OKS_INST_HIST_DETAILS_V --
1550: -------------------------------------------
1551: PROCEDURE lock_row(
1552: p_api_version IN NUMBER,
1553: p_init_msg_list IN VARCHAR2,

Line 2105: -- update_row for:OKS_INST_HIST_DETAILS_V --

2101: '_PVT'
2102: );
2103: END update_row;
2104: --------------------------------------------
2105: -- update_row for:OKS_INST_HIST_DETAILS_V --
2106: --------------------------------------------
2107: PROCEDURE update_row(
2108: p_api_version IN NUMBER,
2109: p_init_msg_list IN VARCHAR2,

Line 2321: -- Set_Attributes for:OKS_INST_HIST_DETAILS_V --

2317: END IF;
2318: RETURN(l_return_status);
2319: END populate_new_record;
2320: ------------------------------------------------
2321: -- Set_Attributes for:OKS_INST_HIST_DETAILS_V --
2322: ------------------------------------------------
2323: FUNCTION Set_Attributes (
2324: p_ihdv_rec IN ihdv_rec_type,
2325: x_ihdv_rec OUT NOCOPY ihdv_rec_type

Line 2678: -- delete_row for:OKS_INST_HIST_DETAILS_V --

2674: '_PVT'
2675: );
2676: END delete_row;
2677: --------------------------------------------
2678: -- delete_row for:OKS_INST_HIST_DETAILS_V --
2679: --------------------------------------------
2680: PROCEDURE delete_row(
2681: p_api_version IN NUMBER,
2682: p_init_msg_list IN VARCHAR2,

Line 2760: -- PL/SQL TBL delete_row for:OKS_INST_HIST_DETAILS_V --

2756: '_PVT'
2757: );
2758: END delete_row;
2759: -------------------------------------------------------
2760: -- PL/SQL TBL delete_row for:OKS_INST_HIST_DETAILS_V --
2761: -------------------------------------------------------
2762: PROCEDURE delete_row(
2763: p_api_version IN NUMBER,
2764: p_init_msg_list IN VARCHAR2,

Line 2856: -- PL/SQL TBL delete_row for:OKS_INST_HIST_DETAILS_V --

2852: );
2853: END delete_row;
2854:
2855: -------------------------------------------------------
2856: -- PL/SQL TBL delete_row for:OKS_INST_HIST_DETAILS_V --
2857: -------------------------------------------------------
2858: PROCEDURE delete_row(
2859: p_api_version IN NUMBER,
2860: p_init_msg_list IN VARCHAR2,