APPS.AR_CONS_BILL_CYCLE_PKG dependencies on AR_CONS_BILL_CYCLES_TL

Line 182: insert into AR_CONS_BILL_CYCLES_TL (

178: X_LAST_UPDATED_BY,
179: X_OBJECT_VERSION_NUMBER
180: );
181:
182: insert into AR_CONS_BILL_CYCLES_TL (
183: BILLING_CYCLE_ID,
184: DESCRIPTION,
185: CYCLE_NAME,
186: LAST_UPDATE_DATE,

Line 208: from AR_CONS_BILL_CYCLES_TL T

204: from FND_LANGUAGES L
205: where L.INSTALLED_FLAG in ('I', 'B')
206: and not exists
207: (select NULL
208: from AR_CONS_BILL_CYCLES_TL T
209: where T.BILLING_CYCLE_ID = X_BILLING_CYCLE_ID
210: and T.LANGUAGE = L.LANGUAGE_CODE);
211:
212: OPEN C;

Line 342: UPDATE AR_CONS_BILL_CYCLES_TL SET

338: X_object_version_number:= X_object_version_number-1;
339: Raise NO_DATA_FOUND;
340: END IF;
341:
342: UPDATE AR_CONS_BILL_CYCLES_TL SET
343: DESCRIPTION = X_DESCRIPTION,
344: CYCLE_NAME = X_CYCLE_NAME,
345: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
346: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 361: delete from AR_CONS_BILL_CYCLES_TL

357: procedure DELETE_ROW (
358: X_BILLING_CYCLE_ID IN NUMBER
359: ) IS
360: BEGIN
361: delete from AR_CONS_BILL_CYCLES_TL
362: where BILLING_CYCLE_ID = X_billing_cycle_id;
363:
364: if (sql%notfound) then
365: raise no_data_found;

Line 446: FROM AR_CONS_BILL_CYCLES_TL

442: Recinfo c%rowtype;
443: CURSOR c1 is select
444: DESCRIPTION, CYCLE_NAME,
445: decode(LANGUAGE,userenv('LANG'),'Y','N') BASELANG
446: FROM AR_CONS_BILL_CYCLES_TL
447: WHERE BILLING_CYCLE_ID = X_billing_cycle_id
448: FOR UPDATE Of BILLING_CYCLE_ID nowait;
449:
450: BEGIN

Line 589: delete from AR_CONS_BILL_CYCLES_TL T

585:
586: procedure ADD_LANGUAGE
587: is
588: begin
589: delete from AR_CONS_BILL_CYCLES_TL T
590: where not exists
591: (select NULL
592: from AR_CONS_BILL_CYCLES_B B
593: where B.BILLING_CYCLE_ID = T.BILLING_CYCLE_ID

Line 596: update AR_CONS_BILL_CYCLES_TL T set (

592: from AR_CONS_BILL_CYCLES_B B
593: where B.BILLING_CYCLE_ID = T.BILLING_CYCLE_ID
594: );
595:
596: update AR_CONS_BILL_CYCLES_TL T set (
597: CYCLE_NAME,DESCRIPTION
598: ) = (select
599: B.CYCLE_NAME,B.DESCRIPTION
600: from AR_CONS_BILL_CYCLES_TL B

Line 600: from AR_CONS_BILL_CYCLES_TL B

596: update AR_CONS_BILL_CYCLES_TL T set (
597: CYCLE_NAME,DESCRIPTION
598: ) = (select
599: B.CYCLE_NAME,B.DESCRIPTION
600: from AR_CONS_BILL_CYCLES_TL B
601: where B.BILLING_CYCLE_ID = T.BILLING_CYCLE_ID
602: and B.LANGUAGE = T.SOURCE_LANG)
603: where (
604: T.BILLING_CYCLE_ID,

Line 609: from AR_CONS_BILL_CYCLES_TL SUBB, AR_CONS_BILL_CYCLES_TL SUBT

605: T.LANGUAGE
606: ) in (select
607: SUBT.BILLING_CYCLE_ID,
608: SUBT.LANGUAGE
609: from AR_CONS_BILL_CYCLES_TL SUBB, AR_CONS_BILL_CYCLES_TL SUBT
610: where SUBB.BILLING_CYCLE_ID = SUBT.BILLING_CYCLE_ID
611: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
612: and (SUBB.CYCLE_NAME <> SUBT.CYCLE_NAME
613: ));

Line 614: insert into AR_CONS_BILL_CYCLES_TL (

610: where SUBB.BILLING_CYCLE_ID = SUBT.BILLING_CYCLE_ID
611: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
612: and (SUBB.CYCLE_NAME <> SUBT.CYCLE_NAME
613: ));
614: insert into AR_CONS_BILL_CYCLES_TL (
615: BILLING_CYCLE_ID,
616: CYCLE_NAME,
617: CREATED_BY,
618: CREATION_DATE,

Line 634: from AR_CONS_BILL_CYCLES_TL B, FND_LANGUAGES L

630: B.LAST_UPDATE_DATE,
631: B.LAST_UPDATE_LOGIN,
632: L.LANGUAGE_CODE,
633: B.SOURCE_LANG
634: from AR_CONS_BILL_CYCLES_TL B, FND_LANGUAGES L
635: where L.INSTALLED_FLAG in ('I', 'B')
636: and B.LANGUAGE = userenv('LANG')
637: and not exists
638: (select NULL

Line 639: from AR_CONS_BILL_CYCLES_TL T

635: where L.INSTALLED_FLAG in ('I', 'B')
636: and B.LANGUAGE = userenv('LANG')
637: and not exists
638: (select NULL
639: from AR_CONS_BILL_CYCLES_TL T
640: where T.BILLING_CYCLE_ID = B.BILLING_CYCLE_ID
641: and T.LANGUAGE = L.LANGUAGE_CODE);
642: end ADD_LANGUAGE;
643:

Line 651: update AR_CONS_BILL_CYCLES_TL

647: X_DESCRIPTION in VARCHAR2,
648: X_OWNER in VARCHAR2
649: ) IS
650: Begin
651: update AR_CONS_BILL_CYCLES_TL
652: set CYCLE_NAME = X_CYCLE_NAME,
653: DESCRIPTION = X_DESCRIPTION,
654: source_lang = userenv('LANG'),
655: last_update_date = sysdate,