APPS.AS_MC_REPORTING_CURR_PKG dependencies on FND_API

Line 30: If (px_SETUP_CURRENCY_ID IS NULL) OR (px_SETUP_CURRENCY_ID = FND_API.G_MISS_NUM) then

26:
27: IS
28: CURSOR C2 IS SELECT AS_MC_REPORTING_CURR_S.nextval FROM sys.dual;
29: BEGIN
30: If (px_SETUP_CURRENCY_ID IS NULL) OR (px_SETUP_CURRENCY_ID = FND_API.G_MISS_NUM) then
31: OPEN C2;
32: FETCH C2 INTO px_SETUP_CURRENCY_ID;
33: CLOSE C2;
34: End If;

Line 49: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

45: START_DATE_ACTIVE
46: -- SECURITY_GROUP_ID
47: ) VALUES (
48: px_SETUP_CURRENCY_ID,
49: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
50: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
51: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
52: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
53: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

Line 50: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

46: -- SECURITY_GROUP_ID
47: ) VALUES (
48: px_SETUP_CURRENCY_ID,
49: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
50: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
51: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
52: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
53: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
54: decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_FROM_CURRENCY),

Line 51: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

47: ) VALUES (
48: px_SETUP_CURRENCY_ID,
49: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
50: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
51: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
52: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
53: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
54: decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_FROM_CURRENCY),
55: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),

Line 52: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

48: px_SETUP_CURRENCY_ID,
49: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
50: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
51: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
52: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
53: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
54: decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_FROM_CURRENCY),
55: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
56: decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_REPORTING_CURRENCY),

Line 53: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

49: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
50: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
51: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
52: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
53: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
54: decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_FROM_CURRENCY),
55: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
56: decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_REPORTING_CURRENCY),
57: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE));

Line 54: decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_FROM_CURRENCY),

50: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
51: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
52: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
53: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
54: decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_FROM_CURRENCY),
55: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
56: decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_REPORTING_CURRENCY),
57: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE));
58: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID));

Line 55: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),

51: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
52: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
53: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
54: decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_FROM_CURRENCY),
55: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
56: decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_REPORTING_CURRENCY),
57: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE));
58: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID));
59: End Insert_Row;

Line 56: decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_REPORTING_CURRENCY),

52: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
53: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
54: decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_FROM_CURRENCY),
55: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
56: decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_REPORTING_CURRENCY),
57: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE));
58: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID));
59: End Insert_Row;
60:

Line 57: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE));

53: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
54: decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_FROM_CURRENCY),
55: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
56: decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_REPORTING_CURRENCY),
57: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE));
58: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID));
59: End Insert_Row;
60:
61: PROCEDURE Update_Row(

Line 58: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID));

54: decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_FROM_CURRENCY),
55: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
56: decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, NULL, p_REPORTING_CURRENCY),
57: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE));
58: -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID));
59: End Insert_Row;
60:
61: PROCEDURE Update_Row(
62: p_CREATED_BY NUMBER,

Line 78: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

74: IS
75: BEGIN
76: Update AS_MC_REPORTING_CURR
77: SET
78: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
79: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
80: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
81: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
82: FROM_CURRENCY = decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, FROM_CURRENCY, p_FROM_CURRENCY),

Line 79: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

75: BEGIN
76: Update AS_MC_REPORTING_CURR
77: SET
78: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
79: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
80: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
81: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
82: FROM_CURRENCY = decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, FROM_CURRENCY, p_FROM_CURRENCY),
83: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),

Line 80: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

76: Update AS_MC_REPORTING_CURR
77: SET
78: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
79: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
80: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
81: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
82: FROM_CURRENCY = decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, FROM_CURRENCY, p_FROM_CURRENCY),
83: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
84: REPORTING_CURRENCY = decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, REPORTING_CURRENCY, p_REPORTING_CURRENCY),

Line 81: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

77: SET
78: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
79: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
80: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
81: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
82: FROM_CURRENCY = decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, FROM_CURRENCY, p_FROM_CURRENCY),
83: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
84: REPORTING_CURRENCY = decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, REPORTING_CURRENCY, p_REPORTING_CURRENCY),
85: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),

Line 82: FROM_CURRENCY = decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, FROM_CURRENCY, p_FROM_CURRENCY),

78: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
79: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
80: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
81: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
82: FROM_CURRENCY = decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, FROM_CURRENCY, p_FROM_CURRENCY),
83: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
84: REPORTING_CURRENCY = decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, REPORTING_CURRENCY, p_REPORTING_CURRENCY),
85: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
86: SETUP_CURRENCY_ID = decode( p_SETUP_CURRENCY_ID, FND_API.G_MISS_NUM, SETUP_CURRENCY_ID, p_SETUP_CURRENCY_ID)

Line 83: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),

79: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
80: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
81: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
82: FROM_CURRENCY = decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, FROM_CURRENCY, p_FROM_CURRENCY),
83: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
84: REPORTING_CURRENCY = decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, REPORTING_CURRENCY, p_REPORTING_CURRENCY),
85: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
86: SETUP_CURRENCY_ID = decode( p_SETUP_CURRENCY_ID, FND_API.G_MISS_NUM, SETUP_CURRENCY_ID, p_SETUP_CURRENCY_ID)
87: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)

Line 84: REPORTING_CURRENCY = decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, REPORTING_CURRENCY, p_REPORTING_CURRENCY),

80: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
81: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
82: FROM_CURRENCY = decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, FROM_CURRENCY, p_FROM_CURRENCY),
83: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
84: REPORTING_CURRENCY = decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, REPORTING_CURRENCY, p_REPORTING_CURRENCY),
85: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
86: SETUP_CURRENCY_ID = decode( p_SETUP_CURRENCY_ID, FND_API.G_MISS_NUM, SETUP_CURRENCY_ID, p_SETUP_CURRENCY_ID)
87: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)
88: where SETUP_CURRENCY_ID = p_SETUP_CURRENCY_ID;

Line 85: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),

81: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
82: FROM_CURRENCY = decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, FROM_CURRENCY, p_FROM_CURRENCY),
83: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
84: REPORTING_CURRENCY = decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, REPORTING_CURRENCY, p_REPORTING_CURRENCY),
85: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
86: SETUP_CURRENCY_ID = decode( p_SETUP_CURRENCY_ID, FND_API.G_MISS_NUM, SETUP_CURRENCY_ID, p_SETUP_CURRENCY_ID)
87: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)
88: where SETUP_CURRENCY_ID = p_SETUP_CURRENCY_ID;
89:

Line 86: SETUP_CURRENCY_ID = decode( p_SETUP_CURRENCY_ID, FND_API.G_MISS_NUM, SETUP_CURRENCY_ID, p_SETUP_CURRENCY_ID)

82: FROM_CURRENCY = decode( p_FROM_CURRENCY, FND_API.G_MISS_CHAR, FROM_CURRENCY, p_FROM_CURRENCY),
83: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
84: REPORTING_CURRENCY = decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, REPORTING_CURRENCY, p_REPORTING_CURRENCY),
85: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
86: SETUP_CURRENCY_ID = decode( p_SETUP_CURRENCY_ID, FND_API.G_MISS_NUM, SETUP_CURRENCY_ID, p_SETUP_CURRENCY_ID)
87: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)
88: where SETUP_CURRENCY_ID = p_SETUP_CURRENCY_ID;
89:
90: If (SQL%NOTFOUND) then

Line 87: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)

83: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
84: REPORTING_CURRENCY = decode( p_REPORTING_CURRENCY, FND_API.G_MISS_CHAR, REPORTING_CURRENCY, p_REPORTING_CURRENCY),
85: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
86: SETUP_CURRENCY_ID = decode( p_SETUP_CURRENCY_ID, FND_API.G_MISS_NUM, SETUP_CURRENCY_ID, p_SETUP_CURRENCY_ID)
87: -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)
88: where SETUP_CURRENCY_ID = p_SETUP_CURRENCY_ID;
89:
90: If (SQL%NOTFOUND) then
91: RAISE NO_DATA_FOUND;