APPS.IBC_ASSOCIATION_TYPES_PKG dependencies on IBC_ASSOCIATION_TYPES_B

Line 30: CURSOR c IS SELECT ROWID FROM ibc_association_types_b

26: ,p_last_updated_by IN NUMBER --DEFAULT NULL
27: ,p_last_update_login IN NUMBER --DEFAULT NULL
28: ,x_rowid OUT NOCOPY VARCHAR2
29: ) IS
30: CURSOR c IS SELECT ROWID FROM ibc_association_types_b
31: WHERE association_type_code = p_association_type_code
32: ;
33: BEGIN
34: INSERT INTO ibc_association_types_b (

Line 34: INSERT INTO ibc_association_types_b (

30: CURSOR c IS SELECT ROWID FROM ibc_association_types_b
31: WHERE association_type_code = p_association_type_code
32: ;
33: BEGIN
34: INSERT INTO ibc_association_types_b (
35: association_type_code
36: ,search_page
37: ,object_version_number
38: ,call_back_pkg

Line 106: FROM ibc_association_types_b

102: ) IS
103: CURSOR c IS SELECT
104: search_page,
105: object_version_number
106: FROM ibc_association_types_b
107: WHERE association_type_code = p_association_type_code
108: FOR UPDATE OF association_type_code NOWAIT;
109: recinfo c%ROWTYPE;
110:

Line 167: UPDATE ibc_association_types_b SET

163: ,p_search_page IN VARCHAR2 --DEFAULT NULL
164: )
165: IS
166: BEGIN
167: UPDATE ibc_association_types_b SET
168: search_page = DECODE(p_search_page,FND_API.G_MISS_CHAR,NULL,NULL,search_page,p_search_page)
169: ,object_version_number = NVL(object_version_number,0) + 1
170: ,call_back_pkg = DECODE(p_call_back_pkg,FND_API.G_MISS_CHAR,NULL,NULL,call_back_pkg,p_call_back_pkg)
171: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

Line 212: DELETE FROM ibc_association_types_b

208: IF (SQL%NOTFOUND) THEN
209: RAISE NO_DATA_FOUND;
210: END IF;
211:
212: DELETE FROM ibc_association_types_b
213: WHERE association_type_code = p_association_type_code;
214:
215: IF (SQL%NOTFOUND) THEN
216: RAISE NO_DATA_FOUND;

Line 226: FROM ibc_association_types_b b

222: BEGIN
223: DELETE FROM ibc_association_types_tl t
224: WHERE NOT EXISTS
225: (SELECT NULL
226: FROM ibc_association_types_b b
227: WHERE b.association_type_code = t.association_type_code
228: );
229:
230: UPDATE ibc_association_types_tl t SET (

Line 345: FROM ibc_association_types_b

341: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
342:
343: -- get updatedby and update_date values if existing in db
344: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
345: FROM ibc_association_types_b
346: WHERE association_type_code = p_association_type_code;
347:
348: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
349: db_user_id, db_last_update_date, p_upload_mode )) THEN

Line 448: cursor C is select ROWID from IBC_ASSOCIATION_TYPES_B

444: X_LAST_UPDATED_BY in NUMBER,
445: X_LAST_UPDATE_LOGIN in NUMBER,
446: X_SECURITY_GROUP_ID in NUMBER
447: ) IS
448: cursor C is select ROWID from IBC_ASSOCIATION_TYPES_B
449: where ASSOCIATION_TYPE_CODE = X_ASSOCIATION_TYPE_CODE
450: ;
451: begin
452: insert into IBC_ASSOCIATION_TYPES_B (

Line 452: insert into IBC_ASSOCIATION_TYPES_B (

448: cursor C is select ROWID from IBC_ASSOCIATION_TYPES_B
449: where ASSOCIATION_TYPE_CODE = X_ASSOCIATION_TYPE_CODE
450: ;
451: begin
452: insert into IBC_ASSOCIATION_TYPES_B (
453: ASSOCIATION_TYPE_CODE,
454: CALL_BACK_PKG,
455: SEARCH_PAGE,
456: OBJECT_VERSION_NUMBER,

Line 531: from IBC_ASSOCIATION_TYPES_B

527: cursor c is select
528: CALL_BACK_PKG,
529: SEARCH_PAGE,
530: OBJECT_VERSION_NUMBER
531: from IBC_ASSOCIATION_TYPES_B
532: where ASSOCIATION_TYPE_CODE = X_ASSOCIATION_TYPE_CODE
533: for update of ASSOCIATION_TYPE_CODE nowait;
534: recinfo c%rowtype;
535:

Line 594: update IBC_ASSOCIATION_TYPES_B set

590: X_LAST_UPDATE_LOGIN in NUMBER,
591: X_SECURITY_GROUP_ID in NUMBER
592: ) is
593: begin
594: update IBC_ASSOCIATION_TYPES_B set
595: CALL_BACK_PKG = X_CALL_BACK_PKG,
596: SEARCH_PAGE = X_SEARCH_PAGE,
597: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
598: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 635: delete from IBC_ASSOCIATION_TYPES_B

631: if (sql%notfound) then
632: raise no_data_found;
633: end if;
634:
635: delete from IBC_ASSOCIATION_TYPES_B
636: where ASSOCIATION_TYPE_CODE = X_ASSOCIATION_TYPE_CODE;
637:
638: if (sql%notfound) then
639: raise no_data_found;