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 CN_RULES

Line 50: insert_row_into_cn_rules_only(

46: x_sequence_number number,
47: x_org_id number) IS
48: l_rowid ROWID;
49: BEGIN
50: insert_row_into_cn_rules_only(
51: x_rowid => l_rowid,
52: x_rule_id => x_rule_id,
53: x_name => x_name,
54: x_ruleset_id => x_ruleset_id,

Line 60: INSERT INTO cn_rules_hierarchy

56: x_expense_ccid => x_expense_ccid,
57: x_liability_ccid => x_liability_ccid,
58: x_org_id =>x_org_id);
59:
60: INSERT INTO cn_rules_hierarchy
61: (rule_id, parent_rule_id, sequence_number, ruleset_id,org_id)
62: VALUES (x_rule_id, x_parent_rule_id, x_sequence_number, x_ruleset_id, x_org_id);
63:
64: unsync_ruleset(x_ruleset_id,x_org_id);

Line 68: procedure insert_row_into_cn_rules_only

64: unsync_ruleset(x_ruleset_id,x_org_id);
65: END Insert_Row;
66:
67:
68: procedure insert_row_into_cn_rules_only
69: (
70: X_ROWID in out nocopy VARCHAR2,
71: X_RULE_ID in NUMBER,
72: X_RULESET_ID in NUMBER,

Line 94: L_NAME cn_rules.name%TYPE;

90: L_PACKAGE_ID NUMBER;
91: L_REVENUE_CLASS_ID NUMBER;
92: l_expense_ccid NUMBER;
93: l_liability_ccid NUMBER;
94: L_NAME cn_rules.name%TYPE;
95: L_CREATION_DATE DATE;
96: L_CREATED_BY NUMBER;
97: L_LAST_UPDATE_DATE DATE;
98: L_LAST_UPDATED_BY NUMBER;

Line 156: insert into CN_RULES_ALL_B

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,
159: RULE_ID,
160: RULESET_ID,

Line 186: insert into CN_RULES_ALL_TL (

182: L_LAST_UPDATE_LOGIN,
183: L_ORG_ID
184: );
185:
186: insert into CN_RULES_ALL_TL (
187: NAME,
188: LAST_UPDATE_DATE,
189: LAST_UPDATED_BY,
190: LAST_UPDATE_LOGIN,

Line 214: from CN_RULES_ALL_TL T

210: from FND_LANGUAGES L
211: where L.INSTALLED_FLAG in ('I', 'B')
212: and not exists
213: (select NULL
214: from CN_RULES_ALL_TL T
215: where T.RULE_ID = L_RULE_ID
216: and T.RULESET_ID = L_RULESET_ID --RC 06-APR-99 Added code
217: and T.LANGUAGE = L.language_code AND
218: T.ORG_ID=L_ORG_ID);

Line 221: end INSERT_ROW_into_cn_rules_only;

217: and T.LANGUAGE = L.language_code AND
218: T.ORG_ID=L_ORG_ID);
219:
220:
221: end INSERT_ROW_into_cn_rules_only;
222:
223:
224: -- Procedure Name
225: -- unsync_ruleset

Line 231: UPDATE cn_rulesets_all_b

227: -- 17-Feb-99 Renu Chintalapati Created
228:
229: PROCEDURE unsync_ruleset (x_ruleset_id number, x_org_id number) IS
230: BEGIN
231: UPDATE cn_rulesets_all_b
232: SET ruleset_status = 'UNSYNC'
233: WHERE ruleset_id = x_ruleset_id
234: and ORG_ID= x_org_id ;
235: END unsync_ruleset;

Line 256: update CN_RULES_ALL_B set

252: X_OBJECT_VERSION_NO IN OUT NOCOPY NUMBER
253: ) is
254: begin
255: X_OBJECT_VERSION_NO:=X_OBJECT_VERSION_NO+1;
256: update CN_RULES_ALL_B set
257: PACKAGE_ID = X_PACKAGE_ID,
258: REVENUE_CLASS_ID = X_REVENUE_CLASS_ID,
259: expense_ccid = x_expense_ccid,
260: liability_ccid = x_liability_ccid,

Line 273: update CN_RULES_ALL_TL set

269: if (sql%notfound) then
270: raise no_data_found;
271: end if;
272:
273: update CN_RULES_ALL_TL set
274: NAME = X_NAME,
275: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
276: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
277: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 294: FROM cn_rules_hierarchy

290: procedure DELETE_ROW (X_RULE_ID in NUMBER,
291: X_RULESET_ID in NUMBER,
292: X_ORG_ID IN NUMBER) IS --RC 2/25/99 Added ruleset id
293: Cursor Cascade IS (SELECT rule_id
294: FROM cn_rules_hierarchy
295: WHERE parent_rule_id = x_rule_id
296: AND ruleset_id = x_ruleset_id AND
297: ORG_ID=X_ORG_ID);
298: BEGIN

Line 304: DELETE cn_rules_hierarchy

300: DELETE cn_attribute_rules
301: WHERE rule_id = x_rule_id
302: AND ruleset_id = x_ruleset_id ;
303:
304: DELETE cn_rules_hierarchy
305: WHERE rule_id = x_rule_id
306: AND ruleset_id = x_ruleset_id;
307:
308: delete from CN_RULES_ALL_TL

Line 308: delete from CN_RULES_ALL_TL

304: DELETE cn_rules_hierarchy
305: WHERE rule_id = x_rule_id
306: AND ruleset_id = x_ruleset_id;
307:
308: delete from CN_RULES_ALL_TL
309: where RULE_ID = X_RULE_ID
310: and ruleset_id = x_ruleset_id
311: and ORG_ID=X_ORG_ID;
312:

Line 317: delete from CN_RULES_ALL_B

313: if (sql%notfound) then
314: raise no_data_found;
315: end if;
316:
317: delete from CN_RULES_ALL_B
318: where RULE_ID = X_RULE_ID
319: and ruleset_id = x_ruleset_id AND
320: ORG_ID=X_ORG_ID;
321:

Line 332: DELETE cn_rules_hierarchy

328: FOR C in Cascade LOOP
329: Delete_Row(C.rule_id, x_ruleset_id,X_ORG_ID);
330: END Loop;
331:
332: DELETE cn_rules_hierarchy
333: WHERE parent_rule_id = x_rule_id
334: AND ruleset_id = x_ruleset_id AND
335: ORG_ID=X_ORG_ID;
336:

Line 344: delete from CN_RULES_ALL_TL T

340:
341: procedure ADD_LANGUAGE
342: is
343: begin
344: delete from CN_RULES_ALL_TL T
345: where not exists
346: (select NULL
347: from CN_RULES_ALL_B B
348: where B.RULE_ID = T.RULE_ID

Line 347: from CN_RULES_ALL_B B

343: begin
344: delete from CN_RULES_ALL_TL T
345: where not exists
346: (select NULL
347: from CN_RULES_ALL_B B
348: where B.RULE_ID = T.RULE_ID
349: and B.RULESET_ID = T.ruleset_id
350: and B.ORG_ID= T.ORG_ID
351: );

Line 353: update CN_RULES_ALL_TL T set (

349: and B.RULESET_ID = T.ruleset_id
350: and B.ORG_ID= T.ORG_ID
351: );
352:
353: update CN_RULES_ALL_TL T set (
354: NAME
355: ) = (select
356: B.NAME
357: from CN_RULES_ALL_TL B

Line 357: from CN_RULES_ALL_TL B

353: update CN_RULES_ALL_TL T set (
354: NAME
355: ) = (select
356: B.NAME
357: from CN_RULES_ALL_TL B
358: where B.RULE_ID = T.RULE_ID
359: and B.RULESET_ID = T.RULESET_ID
360: and B.LANGUAGE = T.source_lang
361: and B.ORG_ID= T.ORG_ID)

Line 370: from CN_RULES_ALL_TL SUBB, CN_RULES_ALL_TL SUBT

366: ) in (select
367: SUBT.RULE_ID,
368: SUBT.RULESET_ID,
369: SUBT.LANGUAGE
370: from CN_RULES_ALL_TL SUBB, CN_RULES_ALL_TL SUBT
371: where SUBB.RULE_ID = SUBT.RULE_ID
372: and SUBB.RULESET_ID = SUBT.RULESET_ID
373: and SUBB.LANGUAGE = SUBT.source_lang
374: and SUBB.ORG_ID=SUBT.ORG_ID

Line 381: insert into CN_RULES_ALL_TL (

377: or (SUBB.NAME is null and SUBT.NAME is not null)
378: or (SUBB.NAME is not null and SUBT.NAME is null)
379: ));
380:
381: insert into CN_RULES_ALL_TL (
382: NAME,
383: LAST_UPDATE_DATE,
384: LAST_UPDATED_BY,
385: LAST_UPDATE_LOGIN,

Line 405: from CN_RULES_ALL_TL B, FND_LANGUAGES L

401: B.RULE_ID,
402: L.LANGUAGE_CODE,
403: B.SOURCE_LANG,
404: B.ORG_ID
405: from CN_RULES_ALL_TL B, FND_LANGUAGES L
406: where L.INSTALLED_FLAG in ('I', 'B')
407: and B.LANGUAGE = userenv('LANG')
408: and not exists
409: (select NULL

Line 410: from CN_RULES_ALL_TL T

406: where L.INSTALLED_FLAG in ('I', 'B')
407: and B.LANGUAGE = userenv('LANG')
408: and not exists
409: (select NULL
410: from CN_RULES_ALL_TL T
411: where T.RULE_ID = B.RULE_ID
412: and T.RULESET_ID = B.RULESET_ID
413: and T.LANGUAGE = L.language_code AND
414: T.ORG_ID=B.ORG_ID);

Line 604: l_ruleset_rec cn_ruleset_pub.ruleset_rec_type;

600: l_loading_status VARCHAR2(30);
601: l_loaded_counter NUMBER := 0;
602: l_total_counter NUMBER := 0;
603: l_proc_audit_id NUMBER(15);
604: l_ruleset_rec cn_ruleset_pub.ruleset_rec_type;
605: l_rule_rec cn_rule_pub.rule_rec_type;
606: l_ruleattribute_rec cn_ruleattribute_pub.ruleattribute_rec_type;
607: l_count NUMBER;
608:

Line 629: FROM cn_rulesets

625: FOR i IN rulesets
626: LOOP
627: SELECT COUNT(1)
628: INTO l_count
629: FROM cn_rulesets
630: WHERE name = i.ruleset_name
631: AND start_date = i.start_date
632: AND end_date = i.end_date;
633:

Line 642: cn_ruleset_pub.create_ruleset

638: l_ruleset_rec.end_date := i.end_date;
639:
640:
641: -- Need to refactor public package
642: cn_ruleset_pub.create_ruleset
643: ( p_api_version => 1.0,
644: p_init_msg_list => fnd_api.g_true,
645: p_commit => FND_API.G_FALSE,
646: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 657: SET loading_status = 'CN_RULESET_INSERTED'

653:
654: IF(l_return_status = FND_API.g_ret_sts_success) THEN
655:
656: UPDATE cn_clrl_api
657: SET loading_status = 'CN_RULESET_INSERTED'
658: WHERE ruleset_name = i.ruleset_name
659: AND start_date = i.start_date
660: AND end_date = i.end_date
661: AND (loading_status <> 'CN_INSERTED' OR loading_status IS NULL);

Line 898: UPDATE cn_rules_all_b SET

894: ELSE
895: user_id := 0;
896: END IF;
897: -- Load The record to _B table
898: UPDATE cn_rules_all_b SET
899: ruleset_id = x_ruleset_id,
900: revenue_class_id = x_revenue_class_id,
901: package_id = x_package_id,
902: last_update_date = sysdate,

Line 910: INSERT INTO cn_rules_all_b

906: WHERE rule_id = x_rule_id AND ruleset_id = x_ruleset_id AND ORG_ID=x_org_id;
907:
908: IF (SQL%NOTFOUND) THEN
909: -- Insert new record to _B table
910: INSERT INTO cn_rules_all_b
911: (rule_id,
912: ruleset_id,
913: revenue_class_id,
914: package_id,

Line 935: UPDATE cn_rules_all_tl SET

931: x_org_id
932: );
933: END IF;
934: -- Load The record to _TL table
935: UPDATE cn_rules_all_tl SET
936: ruleset_id = x_ruleset_id,
937: name = x_name,
938: last_update_date = sysdate,
939: last_updated_by = user_id,

Line 948: INSERT INTO cn_rules_all_tl

944: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
945:
946: IF (SQL%NOTFOUND) THEN
947: -- Insert new record to _TL table
948: INSERT INTO cn_rules_all_tl
949: (rule_id,
950: ruleset_id,
951: name,
952: creation_date,

Line 976: FROM cn_rules_all_tl t

972: FROM fnd_languages l
973: WHERE l.installed_flag IN ('I', 'B')
974: AND NOT EXISTS
975: (SELECT NULL
976: FROM cn_rules_all_tl t
977: WHERE t.rule_id = x_rule_id and t.org_id=x_org_id
978: AND t.language = l.language_code);
979: END IF;
980: << end_load_row >>

Line 1009: UPDATE cn_rules_all_tl SET

1005: ELSE
1006: user_id := 0;
1007: END IF;
1008: -- Update the translation
1009: UPDATE cn_rules_all_tl SET
1010: name = x_name,
1011: last_update_date = sysdate,
1012: last_updated_by = user_id,
1013: last_update_login = 0,