eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SYIN_RULES_PKG dependencies on DUAL

Line 106: INTO l_RULE_ID FROM sys.dual;

102: BEGIN
103:
104: SELECT Decode(x_RULE_ID, FND_API.G_MISS_NUM, NULL,
105: Ltrim(Rtrim(x_RULE_ID)))
106: INTO l_RULE_ID FROM sys.dual;
107:
108: SELECT Decode(x_RULESET_ID, FND_API.G_MISS_NUM, NULL,
109: Ltrim(Rtrim(x_RULESET_ID)))
110: INTO l_RULESET_ID FROM sys.dual;

Line 110: INTO l_RULESET_ID FROM sys.dual;

106: INTO l_RULE_ID FROM sys.dual;
107:
108: SELECT Decode(x_RULESET_ID, FND_API.G_MISS_NUM, NULL,
109: Ltrim(Rtrim(x_RULESET_ID)))
110: INTO l_RULESET_ID FROM sys.dual;
111:
112: SELECT Decode(x_PACKAGE_ID, FND_API.G_MISS_NUM, NULL,
113: Ltrim(Rtrim(x_PACKAGE_ID)))
114: INTO l_PACKAGE_ID FROM sys.dual;

Line 114: INTO l_PACKAGE_ID FROM sys.dual;

110: INTO l_RULESET_ID FROM sys.dual;
111:
112: SELECT Decode(x_PACKAGE_ID, FND_API.G_MISS_NUM, NULL,
113: Ltrim(Rtrim(x_PACKAGE_ID)))
114: INTO l_PACKAGE_ID FROM sys.dual;
115:
116: SELECT Decode(x_REVENUE_CLASS_ID, FND_API.G_MISS_NUM, NULL,
117: Ltrim(Rtrim(x_REVENUE_CLASS_ID)))
118: INTO l_REVENUE_CLASS_ID FROM sys.dual;

Line 118: INTO l_REVENUE_CLASS_ID FROM sys.dual;

114: INTO l_PACKAGE_ID FROM sys.dual;
115:
116: SELECT Decode(x_REVENUE_CLASS_ID, FND_API.G_MISS_NUM, NULL,
117: Ltrim(Rtrim(x_REVENUE_CLASS_ID)))
118: INTO l_REVENUE_CLASS_ID FROM sys.dual;
119:
120: SELECT Decode(x_expense_ccid, FND_API.G_MISS_NUM, NULL,
121: Ltrim(Rtrim(x_expense_ccid)))
122: INTO l_expense_ccid FROM sys.dual;

Line 122: INTO l_expense_ccid FROM sys.dual;

118: INTO l_REVENUE_CLASS_ID FROM sys.dual;
119:
120: SELECT Decode(x_expense_ccid, FND_API.G_MISS_NUM, NULL,
121: Ltrim(Rtrim(x_expense_ccid)))
122: INTO l_expense_ccid FROM sys.dual;
123:
124: SELECT Decode(x_liability_ccid, FND_API.G_MISS_NUM, NULL,
125: Ltrim(Rtrim(x_liability_ccid)))
126: INTO l_liability_ccid FROM sys.dual;

Line 126: INTO l_liability_ccid FROM sys.dual;

122: INTO l_expense_ccid FROM sys.dual;
123:
124: SELECT Decode(x_liability_ccid, FND_API.G_MISS_NUM, NULL,
125: Ltrim(Rtrim(x_liability_ccid)))
126: INTO l_liability_ccid FROM sys.dual;
127:
128: SELECT Decode(x_NAME, FND_API.G_MISS_CHAR, NULL,
129: Ltrim(Rtrim(x_NAME)))
130: INTO l_NAME FROM sys.dual;

Line 130: INTO l_NAME FROM sys.dual;

126: INTO l_liability_ccid FROM sys.dual;
127:
128: SELECT Decode(x_NAME, FND_API.G_MISS_CHAR, NULL,
129: Ltrim(Rtrim(x_NAME)))
130: INTO l_NAME FROM sys.dual;
131:
132: SELECT Decode(x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,
133: Ltrim(Rtrim(x_CREATION_DATE)))
134: INTO l_CREATION_DATE FROM sys.dual;

Line 134: INTO l_CREATION_DATE FROM sys.dual;

130: INTO l_NAME FROM sys.dual;
131:
132: SELECT Decode(x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,
133: Ltrim(Rtrim(x_CREATION_DATE)))
134: INTO l_CREATION_DATE FROM sys.dual;
135:
136: SELECT Decode(x_CREATED_BY, FND_API.G_MISS_NUM, NULL,
137: Ltrim(Rtrim(x_CREATED_BY)))
138: INTO l_CREATED_BY FROM sys.dual;

Line 138: INTO l_CREATED_BY FROM sys.dual;

134: INTO l_CREATION_DATE FROM sys.dual;
135:
136: SELECT Decode(x_CREATED_BY, FND_API.G_MISS_NUM, NULL,
137: Ltrim(Rtrim(x_CREATED_BY)))
138: INTO l_CREATED_BY FROM sys.dual;
139:
140: SELECT Decode(x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,
141: Ltrim(Rtrim(x_LAST_UPDATE_DATE)))
142: INTO l_LAST_UPDATE_DATE FROM sys.dual;

Line 142: INTO l_LAST_UPDATE_DATE FROM sys.dual;

138: INTO l_CREATED_BY FROM sys.dual;
139:
140: SELECT Decode(x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,
141: Ltrim(Rtrim(x_LAST_UPDATE_DATE)))
142: INTO l_LAST_UPDATE_DATE FROM sys.dual;
143:
144: SELECT Decode(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,
145: Ltrim(Rtrim(x_LAST_UPDATED_BY)))
146: INTO l_LAST_UPDATED_BY FROM sys.dual;

Line 146: INTO l_LAST_UPDATED_BY FROM sys.dual;

142: INTO l_LAST_UPDATE_DATE FROM sys.dual;
143:
144: SELECT Decode(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,
145: Ltrim(Rtrim(x_LAST_UPDATED_BY)))
146: INTO l_LAST_UPDATED_BY FROM sys.dual;
147:
148: SELECT Decode(x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,
149: Ltrim(Rtrim(x_LAST_UPDATE_LOGIN)))
150: INTO l_LAST_UPDATE_LOGIN FROM sys.dual;

Line 150: INTO l_LAST_UPDATE_LOGIN FROM sys.dual;

146: INTO l_LAST_UPDATED_BY FROM sys.dual;
147:
148: SELECT Decode(x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,
149: Ltrim(Rtrim(x_LAST_UPDATE_LOGIN)))
150: INTO l_LAST_UPDATE_LOGIN FROM sys.dual;
151:
152: SELECT Decode(x_ORG_ID, FND_API.G_MISS_NUM, NULL,
153: Ltrim(Rtrim(x_ORG_ID)))
154: INTO l_ORG_ID FROM sys.dual;

Line 154: INTO l_ORG_ID FROM sys.dual;

150: INTO l_LAST_UPDATE_LOGIN FROM sys.dual;
151:
152: SELECT Decode(x_ORG_ID, FND_API.G_MISS_NUM, NULL,
153: Ltrim(Rtrim(x_ORG_ID)))
154: INTO l_ORG_ID FROM sys.dual;
155:
156: insert into CN_RULES_ALL_B
157: (
158: PACKAGE_ID,

Line 477: FROM dual;

473: FOR i IN cnclrl_cur
474: LOOP
475: SELECT cn_clrl_api_s.NEXTVAL
476: INTO l_api_id
477: FROM dual;
478:
479: cnclrl_tbl(j).clrl_api_id := l_api_id;
480: cnclrl_tbl(j).ruleset_name := i.ruleset_name;
481: cnclrl_tbl(j).start_date := i.start_date;