APPS.JL_BR_AR_OCC_DOCS_DIS_N_OTHER dependencies on FND_NUMBER

Line 50: AND fnd_number.canonical_to_number(NVL(:new.global_attribute3,'0')) <> 0)

46:
47: IF NVL(:old.global_attribute5,'X') <> NVL(:new.global_attribute5,'X')
48: OR NVL(:old.global_attribute1,'X') <> NVL(:new.global_attribute1, 'X')
49: OR ((NVL(:old.global_attribute3,'X') <> NVL(:new.global_attribute3,'X'))
50: AND fnd_number.canonical_to_number(NVL(:new.global_attribute3,'0')) <> 0)
51: OR ((NVL(:old.global_attribute2,'X') <> NVL(:new.global_attribute2,'X'))
52: AND fnd_number.canonical_to_number(NVL(:new.global_attribute2,'0')) <> 0)
53: THEN
54:

Line 52: AND fnd_number.canonical_to_number(NVL(:new.global_attribute2,'0')) <> 0)

48: OR NVL(:old.global_attribute1,'X') <> NVL(:new.global_attribute1, 'X')
49: OR ((NVL(:old.global_attribute3,'X') <> NVL(:new.global_attribute3,'X'))
50: AND fnd_number.canonical_to_number(NVL(:new.global_attribute3,'0')) <> 0)
51: OR ((NVL(:old.global_attribute2,'X') <> NVL(:new.global_attribute2,'X'))
52: AND fnd_number.canonical_to_number(NVL(:new.global_attribute2,'0')) <> 0)
53: THEN
54:
55: IF NVL(:old.global_attribute5,'X') <> NVL(:new.global_attribute5,'X')
56: THEN

Line 57: X_global_attribute5 := fnd_number.canonical_to_number(:new.global_attribute5);

53: THEN
54:
55: IF NVL(:old.global_attribute5,'X') <> NVL(:new.global_attribute5,'X')
56: THEN
57: X_global_attribute5 := fnd_number.canonical_to_number(:new.global_attribute5);
58: END IF;
59:
60: IF NVL(:old.global_attribute1, 'X') <> NVL(:new.global_attribute1, 'X')
61: THEN

Line 67: X_global_attribute3 := fnd_number.canonical_to_number(:new.global_attribute3);

63: END IF;
64:
65: IF NVL(:old.global_attribute3,'X') <> NVL(:new.global_attribute3,'X')
66: THEN
67: X_global_attribute3 := fnd_number.canonical_to_number(:new.global_attribute3);
68: END IF;
69:
70: IF NVL(:old.global_attribute2,'X') <> NVL(:new.global_attribute2,'X')
71: AND fnd_number.canonical_to_number(NVL(:new.global_attribute2,'0')) <> 0

Line 71: AND fnd_number.canonical_to_number(NVL(:new.global_attribute2,'0')) <> 0

67: X_global_attribute3 := fnd_number.canonical_to_number(:new.global_attribute3);
68: END IF;
69:
70: IF NVL(:old.global_attribute2,'X') <> NVL(:new.global_attribute2,'X')
71: AND fnd_number.canonical_to_number(NVL(:new.global_attribute2,'0')) <> 0
72: THEN
73: X_global_attribute2 := fnd_number.canonical_to_number(:new.global_attribute2);
74: END IF;
75:

Line 73: X_global_attribute2 := fnd_number.canonical_to_number(:new.global_attribute2);

69:
70: IF NVL(:old.global_attribute2,'X') <> NVL(:new.global_attribute2,'X')
71: AND fnd_number.canonical_to_number(NVL(:new.global_attribute2,'0')) <> 0
72: THEN
73: X_global_attribute2 := fnd_number.canonical_to_number(:new.global_attribute2);
74: END IF;
75:
76: FOR c_ps IN ps (:new.customer_trx_id)
77: LOOP

Line 216: IF fnd_number.canonical_to_number(NVL(:new.global_attribute2,'0')) = 0

212: END IF;
213:
214: IF NVL(:new.global_attribute2,'X') <> NVL(:old.global_attribute2,'X')
215: THEN
216: IF fnd_number.canonical_to_number(NVL(:new.global_attribute2,'0')) = 0
217: THEN
218: FOR c_ps IN ps (:new.customer_trx_id)
219: LOOP
220: SELECT doc.document_id,