APPS.JL_BR_AR_OCC_DOCS_DIS_N_OTHER dependencies on FND_NUMBER

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

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

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

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

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

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

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

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

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

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

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

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

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

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