APPS.AR_CONS_BILL_CYCLE_PKG dependencies on AR_CONS_BILL_CYCLES_B

Line 63: cursor C is select ROWID from AR_CONS_BILL_CYCLES_B

59: X_LAST_UPDATE_DATE IN DATE,
60: X_LAST_UPDATED_BY IN NUMBER,
61: X_OBJECT_VERSION_NUMBER IN NUMBER
62: ) IS
63: cursor C is select ROWID from AR_CONS_BILL_CYCLES_B
64: where BILLING_CYCLE_ID = X_BILLING_CYCLE_ID;
65:
66: Begin
67:

Line 68: INSERT INTO AR_CONS_BILL_CYCLES_B(

64: where BILLING_CYCLE_ID = X_BILLING_CYCLE_ID;
65:
66: Begin
67:
68: INSERT INTO AR_CONS_BILL_CYCLES_B(
69: BILLING_CYCLE_ID,
70: BILL_CYCLE_TYPE,
71: CYCLE_FREQUENCY,
72: START_DATE,

Line 281: UPDATE AR_CONS_BILL_CYCLES_B SET

277: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
278: ) IS
279: Begin
280:
281: UPDATE AR_CONS_BILL_CYCLES_B SET
282: cycle_frequency = X_cycle_frequency,
283: BILL_CYCLE_TYPE = X_BILL_CYCLE_TYPE,
284: START_DATE = X_START_DATE,
285: --CYCLE_FREQUENCY = X_cycle_frequency,

Line 368: delete from AR_CONS_BILL_CYCLES_B

364: if (sql%notfound) then
365: raise no_data_found;
366: end if;
367:
368: delete from AR_CONS_BILL_CYCLES_B
369: where BILLING_CYCLE_ID = X_billing_cycle_id;
370:
371: if (sql%notfound) then
372: raise no_data_found;

Line 437: FROM AR_CONS_BILL_CYCLES_B

433: DAY_21, DAY_22, DAY_23, DAY_24, DAY_25, DAY_26, DAY_27, DAY_28, DAY_29, DAY_30, DAY_31, DAY_MONDAY, DAY_TUESDAY,
434: DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY, DAY_SUNDAY,
435: SKIP_WEEKENDS, SKIP_HOLIDAYS, REPEAT_DAILY, REPEAT_WEEKLY,
436: REPEAT_MONTHLY, DAY_TYPE
437: FROM AR_CONS_BILL_CYCLES_B
438: WHERE BILLING_CYCLE_ID = X_billing_cycle_id
439: FOR update of BILLING_CYCLE_ID nowait;
440:
441:

Line 592: from AR_CONS_BILL_CYCLES_B B

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
594: );
595:
596: update AR_CONS_BILL_CYCLES_TL T set (