APPS.CN_LEDGER_BAL_TYPES_ALL_PKG dependencies on CN_LEDGER_BAL_TYPES_ALL_B

Line 20: cursor C is select ROWID from CN_LEDGER_BAL_TYPES_ALL_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from CN_LEDGER_BAL_TYPES_ALL_B
21: where BALANCE_ID = X_BALANCE_ID
22: ;
23: begin
24: insert into CN_LEDGER_BAL_TYPES_ALL_B (

Line 24: insert into CN_LEDGER_BAL_TYPES_ALL_B (

20: cursor C is select ROWID from CN_LEDGER_BAL_TYPES_ALL_B
21: where BALANCE_ID = X_BALANCE_ID
22: ;
23: begin
24: insert into CN_LEDGER_BAL_TYPES_ALL_B (
25: -- CREDIT_TYPE_ID,
26: -- INCENTIVE_TYPE_ID,
27: STATISTICAL_TYPE,
28: PAYMENT_TYPE,

Line 112: from CN_LEDGER_BAL_TYPES_ALL_B

108: PAYMENT_TYPE,
109: COLUMN_NAME,
110: BALANCE_TYPE,
111: SCREEN_SEQUENCE
112: from CN_LEDGER_BAL_TYPES_ALL_B
113: where BALANCE_ID = x_balance_id AND
114: NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
115: for update of BALANCE_ID nowait;
116: recinfo c%rowtype;

Line 185: update CN_LEDGER_BAL_TYPES_ALL_B set

181: X_LAST_UPDATED_BY in NUMBER,
182: X_LAST_UPDATE_LOGIN in NUMBER
183: ) is
184: begin
185: update CN_LEDGER_BAL_TYPES_ALL_B set
186: -- CREDIT_TYPE_ID = X_CREDIT_TYPE_ID,
187: -- INCENTIVE_TYPE_ID = X_INCENTIVE_TYPE_ID,
188: STATISTICAL_TYPE = X_STATISTICAL_TYPE,
189: PAYMENT_TYPE = X_PAYMENT_TYPE,

Line 230: delete from CN_LEDGER_BAL_TYPES_ALL_B

226: if (sql%notfound) then
227: raise no_data_found;
228: end if;
229:
230: delete from CN_LEDGER_BAL_TYPES_ALL_B
231: where BALANCE_ID = X_BALANCE_ID AND
232: NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99);
233:
234: if (sql%notfound) then

Line 245: from CN_LEDGER_BAL_TYPES_ALL_B B

241: begin
242: delete from CN_LEDGER_BAL_TYPES_ALL_TL T
243: where not exists
244: (select NULL
245: from CN_LEDGER_BAL_TYPES_ALL_B B
246: where B.BALANCE_ID = T.balance_id
247: and NVL(B.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
248: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =
249: NVL(T.ORG_ID, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',

Line 349: UPDATE cn_ledger_bal_types_all_b SET

345: ELSE
346: user_id := 0;
347: END IF;
348: -- Load The record to _B table
349: UPDATE cn_ledger_bal_types_all_b SET
350: -- CREDIT_TYPE_ID = X_CREDIT_TYPE_ID,
351: -- INCENTIVE_TYPE_ID = X_INCENTIVE_TYPE_ID,
352: STATISTICAL_TYPE = X_STATISTICAL_TYPE,
353: PAYMENT_TYPE = X_PAYMENT_TYPE,

Line 363: INSERT INTO cn_ledger_bal_types_all_b

359: LAST_UPDATE_LOGIN = 0
360: WHERE BALANCE_ID = X_BALANCE_ID;
361: IF (SQL%NOTFOUND) THEN
362: -- Insert new record to _B table
363: INSERT INTO cn_ledger_bal_types_all_b
364: (-- CREDIT_TYPE_ID,
365: -- INCENTIVE_TYPE_ID,
366: BALANCE_ID,
367: STATISTICAL_TYPE,