APPS.CN_CREDIT_TYPES_PKG dependencies on CN_CREDIT_TYPES_ALL_B

Line 35: cursor C is select ROWID from CN_CREDIT_TYPES_ALL_B

31: X_LAST_UPDATE_LOGIN in NUMBER,
32: X_PRECISION in NUMBER,
33: X_EXTENDED_PRECISION in NUMBER
34: ) is
35: cursor C is select ROWID from CN_CREDIT_TYPES_ALL_B
36: where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID
37: ;
38: begin
39: insert into CN_CREDIT_TYPES_ALL_B (

Line 39: insert into CN_CREDIT_TYPES_ALL_B (

35: cursor C is select ROWID from CN_CREDIT_TYPES_ALL_B
36: where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID
37: ;
38: begin
39: insert into CN_CREDIT_TYPES_ALL_B (
40: CREDIT_TYPE_ID,
41: ORG_ID,
42: DESCRIPTION,
43: MONETARY_FLAG,

Line 184: from CN_CREDIT_TYPES_ALL_B

180: ATTRIBUTE14,
181: ATTRIBUTE15,
182: PRECISION,
183: EXTENDED_PRECISION
184: from CN_CREDIT_TYPES_ALL_B
185: where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID AND
186: 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)
187: for update of CREDIT_TYPE_ID nowait;
188: recinfo c%rowtype;

Line 299: update CN_CREDIT_TYPES_ALL_B set

295: X_PRECISION in NUMBER,
296: X_EXTENDED_PRECISION in NUMBER
297: ) is
298: begin
299: update CN_CREDIT_TYPES_ALL_B set
300: DESCRIPTION = X_DESCRIPTION,
301: MONETARY_FLAG = X_MONETARY_FLAG,
302: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
303: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 359: delete from CN_CREDIT_TYPES_ALL_B

355: if (sql%notfound) then
356: raise no_data_found;
357: end if;
358:
359: delete from CN_CREDIT_TYPES_ALL_B
360: where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID AND
361: ORG_ID = X_ORG_ID;
362:
363: if (sql%notfound) then

Line 375: from CN_CREDIT_TYPES_ALL_B B

371: begin
372: delete from CN_CREDIT_TYPES_ALL_TL T
373: where not exists
374: (select NULL
375: from CN_CREDIT_TYPES_ALL_B B
376: where B.CREDIT_TYPE_ID = T.credit_type_id
377: and B.org_id = T.org_id
378: );
379:

Line 482: UPDATE cn_credit_types_all_b SET

478: user_id := 0;
479: END IF;
480:
481: -- Load The record to _B table
482: UPDATE cn_credit_types_all_b SET
483: DESCRIPTION = X_DESCRIPTION,
484: MONETARY_FLAG = X_MONETARY_FLAG,
485: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
486: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 510: INSERT INTO cn_credit_types_all_b

506: WHERE credit_type_id = x_credit_type_id;
507:
508: IF (SQL%NOTFOUND) THEN
509: -- Insert new record to _B table
510: INSERT INTO cn_credit_types_all_b
511: (
512: CREDIT_TYPE_ID,
513: ORG_ID,
514: DESCRIPTION,