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_RULESET_PVT dependencies on CN_RULES

Line 1: PACKAGE BODY CN_Ruleset_PVT AS

1: PACKAGE BODY CN_Ruleset_PVT AS
2: --$Header: cnvrsetb.pls 120.7 2005/12/27 04:04:37 hanaraya ship $
3:
4: --Global Variables
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_Ruleset_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_Ruleset_PVT';

1: PACKAGE BODY CN_Ruleset_PVT AS
2: --$Header: cnvrsetb.pls 120.7 2005/12/27 04:04:37 hanaraya ship $
3:
4: --Global Variables
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_Ruleset_PVT';
6: G_LAST_UPDATE_DATE DATE := Sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := Sysdate;
9: G_CREATED_BY NUMBER := fnd_global.user_id;

Line 27: FROM cn_rules cr

23: l_api_name CONSTANT VARCHAR2(30) := 'check_sync_allowed';
24:
25: CURSOR no_attribute_curs IS
26: SELECT name
27: FROM cn_rules cr
28: WHERE cr.rule_id <> -1002
29: AND cr.ruleset_id = p_ruleset_id
30: AND cr.org_id=p_org_id
31: AND NOT EXISTS (SELECT 1

Line 46: FROM cn_rules cr, cn_attribute_rules attr, cn_objects col

42: attr.low_value,
43: cr.name rule_name,
44: col.user_name,
45: attr.org_id
46: FROM cn_rules cr, cn_attribute_rules attr, cn_objects col
47: WHERE cr.rule_id <> -1002
48: and col.object_id = attr.column_id
49: and col.table_id = -11803
50: AND cr.ruleset_id = p_ruleset_id

Line 149: ( p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,

145: -- Check Update Allowed.
146: --=========================================================================
147:
148: FUNCTION check_update_allowed
149: ( p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
150: p_module_type In cn_rulesets.module_type%TYPE,
151: p_loading_status IN VARCHAR2,
152: x_loading_status OUT NOCOPY VARCHAR2,
153: x_org_id IN cn_rulesets.org_id%TYPE

Line 150: p_module_type In cn_rulesets.module_type%TYPE,

146: --=========================================================================
147:
148: FUNCTION check_update_allowed
149: ( p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
150: p_module_type In cn_rulesets.module_type%TYPE,
151: p_loading_status IN VARCHAR2,
152: x_loading_status OUT NOCOPY VARCHAR2,
153: x_org_id IN cn_rulesets.org_id%TYPE
154: ) RETURN VARCHAR2 IS

Line 153: x_org_id IN cn_rulesets.org_id%TYPE

149: ( p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
150: p_module_type In cn_rulesets.module_type%TYPE,
151: p_loading_status IN VARCHAR2,
152: x_loading_status OUT NOCOPY VARCHAR2,
153: x_org_id IN cn_rulesets.org_id%TYPE
154: ) RETURN VARCHAR2 IS
155:
156: l_api_name CONSTANT VARCHAR2(30) := 'check_update_allowed';
157:

Line 162: FROM cn_rules_all_b

158: l_env_org_id NUMBER;
159:
160: CURSOR record_exists IS
161: SELECT count(1) cnt
162: FROM cn_rules_all_b
163: WHERE ruleset_id = p_ruleset_id
164: AND rule_id <> -1002
165: AND org_id = l_env_org_id;
166:

Line 169: FROM cn_rulesets

165: AND org_id = l_env_org_id;
166:
167: CURSOR get_module_type IS
168: SELECT module_type
169: FROM cn_rulesets
170: WHERE ruleset_id = p_ruleset_id;
171:
172: l_module_type cn_rulesets.module_type%TYPE;
173: l_total_record NUMBER;

Line 172: l_module_type cn_rulesets.module_type%TYPE;

168: SELECT module_type
169: FROM cn_rulesets
170: WHERE ruleset_id = p_ruleset_id;
171:
172: l_module_type cn_rulesets.module_type%TYPE;
173: l_total_record NUMBER;
174:
175: BEGIN
176:

Line 232: (p_start_date IN cn_rulesets.start_date%TYPE,

228: -- Desc : Validate the start and end dates for the ruleset
229: --
230: --=========================================================================
231: FUNCTION check_ruleset_dates
232: (p_start_date IN cn_rulesets.start_date%TYPE,
233: p_end_date IN cn_rulesets.end_date%TYPE,
234: p_module_type IN cn_rulesets.module_type%TYPE,
235: p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
236: p_org_id IN cn_rulesets.org_id%TYPE,

Line 233: p_end_date IN cn_rulesets.end_date%TYPE,

229: --
230: --=========================================================================
231: FUNCTION check_ruleset_dates
232: (p_start_date IN cn_rulesets.start_date%TYPE,
233: p_end_date IN cn_rulesets.end_date%TYPE,
234: p_module_type IN cn_rulesets.module_type%TYPE,
235: p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
236: p_org_id IN cn_rulesets.org_id%TYPE,
237: p_loading_status IN VARCHAR2,

Line 234: p_module_type IN cn_rulesets.module_type%TYPE,

230: --=========================================================================
231: FUNCTION check_ruleset_dates
232: (p_start_date IN cn_rulesets.start_date%TYPE,
233: p_end_date IN cn_rulesets.end_date%TYPE,
234: p_module_type IN cn_rulesets.module_type%TYPE,
235: p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
236: p_org_id IN cn_rulesets.org_id%TYPE,
237: p_loading_status IN VARCHAR2,
238: x_loading_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS

Line 235: p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,

231: FUNCTION check_ruleset_dates
232: (p_start_date IN cn_rulesets.start_date%TYPE,
233: p_end_date IN cn_rulesets.end_date%TYPE,
234: p_module_type IN cn_rulesets.module_type%TYPE,
235: p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
236: p_org_id IN cn_rulesets.org_id%TYPE,
237: p_loading_status IN VARCHAR2,
238: x_loading_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
239:

Line 236: p_org_id IN cn_rulesets.org_id%TYPE,

232: (p_start_date IN cn_rulesets.start_date%TYPE,
233: p_end_date IN cn_rulesets.end_date%TYPE,
234: p_module_type IN cn_rulesets.module_type%TYPE,
235: p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
236: p_org_id IN cn_rulesets.org_id%TYPE,
237: p_loading_status IN VARCHAR2,
238: x_loading_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
239:
240: l_api_name CONSTANT VARCHAR2(30) := 'check_ruleset_dates';

Line 244: FROM cn_rulesets cnr

240: l_api_name CONSTANT VARCHAR2(30) := 'check_ruleset_dates';
241:
242: CURSOR overlap_check1 (p_date DATE) IS
243: SELECT count(*) cnt
244: FROM cn_rulesets cnr
245: WHERE p_date BETWEEN cnr.start_date AND cnr.end_date
246: AND nvl(module_type,'X') = nvl(p_module_type,'X')
247: AND ruleset_id <> p_ruleset_id
248: AND org_id=p_org_id;

Line 255: FROM cn_rulesets cnr

251: CURSOR overlap_check2
252: (p_start_date DATE,
253: p_end_date DATE) IS
254: SELECT count(*) cnt
255: FROM cn_rulesets cnr
256: WHERE cnr.start_date BETWEEN p_start_date AND p_end_date
257: AND cnr.end_date BETWEEN p_start_date AND p_end_date
258: AND nvl(module_type,'X') = nvl(p_module_type,'X')
259: AND ruleset_id <> p_ruleset_id and

Line 374: -- CN_Ruleset_PVT.ruleset_rec_type

370: -- Default = FND_API.G_FALSE
371: -- p_validation_level IN NUMBER Optional
372: -- Default = FND_API.G_VALID_LEVEL_FULL
373: -- p_ruleset_rec IN
374: -- CN_Ruleset_PVT.ruleset_rec_type
375: --
376: -- OUT : x_return_status OUT VARCHAR2(1)
377: -- x_msg_count OUT NUMBER
378: -- x_msg_data OUT VARCHAR2(2000)

Line 401: p_ruleset_rec IN CN_Ruleset_PVT.ruleset_rec_type

397: x_msg_count OUT NOCOPY NUMBER,
398: x_msg_data OUT NOCOPY VARCHAR2,
399: x_loading_status OUT NOCOPY VARCHAR2,
400: x_ruleset_id OUT NOCOPY NUMBER,
401: p_ruleset_rec IN CN_Ruleset_PVT.ruleset_rec_type
402: )
403: IS
404:
405: l_api_name CONSTANT VARCHAR2(30) := 'Create_Ruleset';

Line 413: l_ruleset_id cn_rulesets.ruleset_id%TYPE;

409: l_error_parameter VARCHAR2(30);
410: l_rowid VARCHAR2(4000);
411: l_sequence_number NUMBER;
412: l_count NUMBER;
413: l_ruleset_id cn_rulesets.ruleset_id%TYPE;
414: l_org_id cn_rulesets.org_id%TYPE;
415:
416: BEGIN
417:

Line 414: l_org_id cn_rulesets.org_id%TYPE;

410: l_rowid VARCHAR2(4000);
411: l_sequence_number NUMBER;
412: l_count NUMBER;
413: l_ruleset_id cn_rulesets.ruleset_id%TYPE;
414: l_org_id cn_rulesets.org_id%TYPE;
415:
416: BEGIN
417:
418: -- Standard Start of API savepoint

Line 482: --else use cn_rulesets_s.nextval

478: END IF;
479:
480: --Now check if the ruleset exists.
481: --If it does, then raise error
482: --else use cn_rulesets_s.nextval
483: SELECT count(1)
484: INTO l_count
485: FROM cn_rulesets
486: WHERE name = p_ruleset_rec.ruleset_name

Line 485: FROM cn_rulesets

481: --If it does, then raise error
482: --else use cn_rulesets_s.nextval
483: SELECT count(1)
484: INTO l_count
485: FROM cn_rulesets
486: WHERE name = p_ruleset_rec.ruleset_name
487: AND module_type = p_ruleset_rec.module_type
488: AND start_date = p_ruleset_rec.start_date
489: AND end_date = p_ruleset_rec.end_date and

Line 497: fnd_message.set_name('CN', 'CN_RULESET_EXISTS');

493: THEN
494: --Error condition
495: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
496: THEN
497: fnd_message.set_name('CN', 'CN_RULESET_EXISTS');
498: fnd_msg_pub.add;
499: END IF;
500:
501: x_loading_status := 'CN_RULESET_EXISTS';

Line 501: x_loading_status := 'CN_RULESET_EXISTS';

497: fnd_message.set_name('CN', 'CN_RULESET_EXISTS');
498: fnd_msg_pub.add;
499: END IF;
500:
501: x_loading_status := 'CN_RULESET_EXISTS';
502: RAISE FND_API.G_EXC_ERROR;
503:
504: END IF;
505:

Line 506: SELECT Decode(p_ruleset_rec.ruleset_id, NULL, cn_rulesets_s.NEXTVAL,

502: RAISE FND_API.G_EXC_ERROR;
503:
504: END IF;
505:
506: SELECT Decode(p_ruleset_rec.ruleset_id, NULL, cn_rulesets_s.NEXTVAL,
507: p_ruleset_rec.ruleset_id)
508: INTO l_ruleset_id
509: FROM dual;
510:

Line 625: -- CN_Ruleset_PVT.ruleset_rec_type

621: -- Default = FND_API.G_FALSE
622: -- p_validation_level IN NUMBER Optional
623: -- Default = FND_API.G_VALID_LEVEL_FULL
624: -- p_ruleset_rec_type IN
625: -- CN_Ruleset_PVT.ruleset_rec_type
626: --
627: -- OUT : x_return_status OUT VARCHAR2(1)
628: -- x_msg_count OUT NUMBER
629: -- x_msg_data OUT VARCHAR2(2000)

Line 652: p_old_ruleset_rec IN OUT NOCOPY CN_Ruleset_PVT.ruleset_rec_type,

648: x_return_status OUT NOCOPY VARCHAR2,
649: x_msg_count OUT NOCOPY NUMBER,
650: x_msg_data OUT NOCOPY VARCHAR2,
651: x_loading_status OUT NOCOPY VARCHAR2,
652: p_old_ruleset_rec IN OUT NOCOPY CN_Ruleset_PVT.ruleset_rec_type,
653: p_ruleset_rec IN OUT NOCOPY CN_Ruleset_PVT.ruleset_rec_type
654: ) IS
655:
656:

Line 653: p_ruleset_rec IN OUT NOCOPY CN_Ruleset_PVT.ruleset_rec_type

649: x_msg_count OUT NOCOPY NUMBER,
650: x_msg_data OUT NOCOPY VARCHAR2,
651: x_loading_status OUT NOCOPY VARCHAR2,
652: p_old_ruleset_rec IN OUT NOCOPY CN_Ruleset_PVT.ruleset_rec_type,
653: p_ruleset_rec IN OUT NOCOPY CN_Ruleset_PVT.ruleset_rec_type
654: ) IS
655:
656:
657: CURSOR l_ovn_csr IS

Line 659: FROM cn_rulesets

655:
656:
657: CURSOR l_ovn_csr IS
658: SELECT nvl(object_version_number,1)
659: FROM cn_rulesets
660: WHERE ruleset_id = p_old_ruleset_rec.ruleset_id AND
661: ORG_ID=p_old_ruleset_rec.org_id;
662:
663: l_env_org_id NUMBER;

Line 667: FROM cn_rules_all_b

663: l_env_org_id NUMBER;
664:
665: CURSOR rules IS
666: SELECT count(1)
667: FROM cn_rules_all_b
668: WHERE ruleset_id = p_old_ruleset_rec.ruleset_id
669: and rule_id <> -1002 and
670: org_id = p_old_ruleset_rec.org_id;
671:

Line 686: FROM cn_rulesets

682:
683:
684: CURSOR get_ruleset_data ( l_ruleset_id NUMBER,l_org_id Number) IS
685: SELECT *
686: FROM cn_rulesets
687: WHERE ruleset_id = l_ruleset_id and
688: org_id=l_org_id;
689:
690: l_get_ruleset_data_rec get_ruleset_data%ROWTYPE;

Line 733: from cn_rulesets

729: into p_old_ruleset_rec.ruleset_name,
730: p_old_ruleset_rec.start_date,
731: p_old_ruleset_rec.end_date,
732: p_old_ruleset_rec.module_type
733: from cn_rulesets
734: where ruleset_id = p_ruleset_rec.ruleset_id and
735: org_id=p_ruleset_rec.org_id;
736:
737: -- API body

Line 789: --else use cn_rulesets_s.nextval

785:
786:
787: --Now check if the ruleset exists.
788: --If it does, then raise error
789: --else use cn_rulesets_s.nextval
790: SELECT count(1)
791: INTO l_count
792: FROM cn_rulesets
793: WHERE ruleset_id = p_old_ruleset_rec.ruleset_id and

Line 792: FROM cn_rulesets

788: --If it does, then raise error
789: --else use cn_rulesets_s.nextval
790: SELECT count(1)
791: INTO l_count
792: FROM cn_rulesets
793: WHERE ruleset_id = p_old_ruleset_rec.ruleset_id and
794: org_id=p_old_ruleset_rec.org_id;
795:
796: IF l_count = 0

Line 933: cn_rulesets_pkg.sync_ruleset(p_ruleset_rec.ruleset_id,l_ruleset_status,l_env_org_id);

929: THEN
930: RAISE fnd_api.g_exc_error;
931: END IF;
932:
933: cn_rulesets_pkg.sync_ruleset(p_ruleset_rec.ruleset_id,l_ruleset_status,l_env_org_id);
934:
935: -- Kumar
936: -- changed from GENERATED to INSTINPG ( Install in Process )
937: -- Date : 11/07/2001

Line 1033: END CN_Ruleset_PVT;

1029: );
1030:
1031: END;
1032:
1033: END CN_Ruleset_PVT;