APPS.OKC_AAL_PVT dependencies on OKC_ACTION_ATT_LOOKUPS_V

Line 86: -- FUNCTION get_rec for: OKC_ACTION_ATT_LOOKUPS_V

82: BEGIN
83: RETURN(get_rec(p_aal_rec, l_row_notfound));
84: END get_rec;
85: ---------------------------------------------------------------------------
86: -- FUNCTION get_rec for: OKC_ACTION_ATT_LOOKUPS_V
87: ---------------------------------------------------------------------------
88: FUNCTION get_rec (
89: p_aalv_rec IN aalv_rec_type,
90: x_no_data_found OUT NOCOPY BOOLEAN

Line 103: FROM Okc_Action_Att_Lookups_V

99: CREATION_DATE,
100: LAST_UPDATED_BY,
101: LAST_UPDATE_DATE,
102: LAST_UPDATE_LOGIN
103: FROM Okc_Action_Att_Lookups_V
104: WHERE okc_action_att_lookups_v.id = p_id;
105: l_okc_aalv_pk okc_aalv_pk_csr%ROWTYPE;
106: l_aalv_rec aalv_rec_type;
107: BEGIN

Line 104: WHERE okc_action_att_lookups_v.id = p_id;

100: LAST_UPDATED_BY,
101: LAST_UPDATE_DATE,
102: LAST_UPDATE_LOGIN
103: FROM Okc_Action_Att_Lookups_V
104: WHERE okc_action_att_lookups_v.id = p_id;
105: l_okc_aalv_pk okc_aalv_pk_csr%ROWTYPE;
106: l_aalv_rec aalv_rec_type;
107: BEGIN
108: x_no_data_found := TRUE;

Line 135: -- FUNCTION null_out_defaults for: OKC_ACTION_ATT_LOOKUPS_V --

131: RETURN(get_rec(p_aalv_rec, l_row_notfound));
132: END get_rec;
133:
134: --------------------------------------------------------------
135: -- FUNCTION null_out_defaults for: OKC_ACTION_ATT_LOOKUPS_V --
136: --------------------------------------------------------------
137: FUNCTION null_out_defaults (
138: p_aalv_rec IN aalv_rec_type
139: ) RETURN aalv_rec_type IS

Line 241: SELECT id FROM OKC_ACTION_ATT_LOOKUPS_V

237: ,p_aalv_rec IN aalv_rec_type)
238: IS
239:
240: CURSOR l_unq_cur(p_object_name VARCHAR2) IS
241: SELECT id FROM OKC_ACTION_ATT_LOOKUPS_V
242: WHERE object_name = p_object_name;
243:
244: l_id NUMBER := OKC_API.G_MISS_NUM;
245: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 274: OKC_UTIL.CHECK_UNIQUE(p_view_name => 'OKC_ACTION_ATT_LOOKUPS_V'

270: p_msg_name => 'OKC_DUP_OBJECT_NAME');
271: END IF;
272:
273: /*
274: OKC_UTIL.CHECK_UNIQUE(p_view_name => 'OKC_ACTION_ATT_LOOKUPS_V'
275: ,p_col_name => 'object_name'
276: ,p_col_value => p_aalv_rec.object_name
277: ,p_id => p_aalv_rec.id
278: ,x_return_status => l_return_status);

Line 366: -- Validate_Attributes for:OKC_ACTION_ATT_LOOKUPS_V --

362: ---------------------------------------------------------------------------
363: -- PROCEDURE Validate_Attributes
364: ---------------------------------------------------------------------------
365: ------------------------------------------------------
366: -- Validate_Attributes for:OKC_ACTION_ATT_LOOKUPS_V --
367: ------------------------------------------------------
368: /* commenting out nocopy generated code in favor of hand written code
369: FUNCTION Validate_Attributes (
370: p_aalv_rec IN aalv_rec_type

Line 496: -- Validate_Record for:OKC_ACTION_ATT_LOOKUPS_V --

492: ---------------------------------------------------------------------------
493: -- PROCEDURE Validate_Record
494: ---------------------------------------------------------------------------
495: --------------------------------------------------
496: -- Validate_Record for:OKC_ACTION_ATT_LOOKUPS_V --
497: --------------------------------------------------
498: FUNCTION Validate_Record (
499: p_aalv_rec IN aalv_rec_type
500: ) RETURN VARCHAR2 IS

Line 545: -- validate_row for:OKC_ACTION_ATT_LOOKUPS_V --

541: ---------------------------------------------------------------------------
542: -- PROCEDURE validate_row
543: ---------------------------------------------------------------------------
544: -----------------------------------------------
545: -- validate_row for:OKC_ACTION_ATT_LOOKUPS_V --
546: -----------------------------------------------
547: PROCEDURE validate_row(
548: p_api_version IN NUMBER,
549: p_init_msg_list IN VARCHAR2 ,

Line 792: -- insert_row for:OKC_ACTION_ATT_LOOKUPS_V --

788: '_PVT'
789: );
790: END insert_row;
791: ---------------------------------------------
792: -- insert_row for:OKC_ACTION_ATT_LOOKUPS_V --
793: ---------------------------------------------
794: PROCEDURE insert_row(
795: p_api_version IN NUMBER,
796: p_init_msg_list IN VARCHAR2 ,

Line 826: -- Set_Attributes for:OKC_ACTION_ATT_LOOKUPS_V --

822: l_aalv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
823: RETURN(l_aalv_rec);
824: END fill_who_columns;
825: -------------------------------------------------
826: -- Set_Attributes for:OKC_ACTION_ATT_LOOKUPS_V --
827: -------------------------------------------------
828: FUNCTION Set_Attributes (
829: p_aalv_rec IN aalv_rec_type,
830: x_aalv_rec OUT NOCOPY aalv_rec_type

Line 1112: -- lock_row for:OKC_ACTION_ATT_LOOKUPS_V --

1108: '_PVT'
1109: );
1110: END lock_row;
1111: -------------------------------------------
1112: -- lock_row for:OKC_ACTION_ATT_LOOKUPS_V --
1113: -------------------------------------------
1114: PROCEDURE lock_row(
1115: p_api_version IN NUMBER,
1116: p_init_msg_list IN VARCHAR2 ,

Line 1415: -- update_row for:OKC_ACTION_ATT_LOOKUPS_V --

1411: '_PVT'
1412: );
1413: END update_row;
1414: ---------------------------------------------
1415: -- update_row for:OKC_ACTION_ATT_LOOKUPS_V --
1416: ---------------------------------------------
1417: PROCEDURE update_row(
1418: p_api_version IN NUMBER,
1419: p_init_msg_list IN VARCHAR2 ,

Line 1502: -- Set_Attributes for:OKC_ACTION_ATT_LOOKUPS_V --

1498: END IF;
1499: RETURN(l_return_status);
1500: END populate_new_record;
1501: -------------------------------------------------
1502: -- Set_Attributes for:OKC_ACTION_ATT_LOOKUPS_V --
1503: -------------------------------------------------
1504: FUNCTION Set_Attributes (
1505: p_aalv_rec IN aalv_rec_type,
1506: x_aalv_rec OUT NOCOPY aalv_rec_type

Line 1746: -- delete_row for:OKC_ACTION_ATT_LOOKUPS_V --

1742: '_PVT'
1743: );
1744: END delete_row;
1745: ---------------------------------------------
1746: -- delete_row for:OKC_ACTION_ATT_LOOKUPS_V --
1747: ---------------------------------------------
1748: PROCEDURE delete_row(
1749: p_api_version IN NUMBER,
1750: p_init_msg_list IN VARCHAR2 ,