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_SCA_CRRULEATTR_PVT dependencies on CN_SCA_RULE_ATTRIBUTES

Line 20: -- p_search_uname IN cn_sca_rule_attributes.user_column_name%TYPE := '%',

16: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: -- p_start_record IN NUMBER := -1,
19: -- p_fetch_size IN NUMBER := -1,
20: -- p_search_uname IN cn_sca_rule_attributes.user_column_name%TYPE := '%',
21: -- p_search_trx_source IN cn_sca_rule_attributes.transaction_source%TYPE,
22: -- x_credit_rule_attr OUT NOCOPY credit_rule_attr_tbl_type ,
23: -- x_total_record OUT NOCOPY NUMBER,
24: -- x_return_status OUT NOCOPY VARCHAR2,

Line 21: -- p_search_trx_source IN cn_sca_rule_attributes.transaction_source%TYPE,

17: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: -- p_start_record IN NUMBER := -1,
19: -- p_fetch_size IN NUMBER := -1,
20: -- p_search_uname IN cn_sca_rule_attributes.user_column_name%TYPE := '%',
21: -- p_search_trx_source IN cn_sca_rule_attributes.transaction_source%TYPE,
22: -- x_credit_rule_attr OUT NOCOPY credit_rule_attr_tbl_type ,
23: -- x_total_record OUT NOCOPY NUMBER,
24: -- x_return_status OUT NOCOPY VARCHAR2,
25: -- x_msg_count OUT NOCOPY NUMBER,

Line 70: -- FROM cn_sca_rule_attributes WHERE ((upper(user_column_name) like upper(p_search_uname)

66: -- attribute13,
67: -- attribute14,
68: -- attribute15,
69: -- object_version_number
70: -- FROM cn_sca_rule_attributes WHERE ((upper(user_column_name) like upper(p_search_uname)
71: -- and (transaction_source like p_search_trx_source)) )
72: -- ORDER BY TO_NUMBER(substr(src_column_name,10));
73: -- CURSOR l_credit_rule_attr_cr IS
74: -- SELECT transaction_source,

Line 98: -- FROM cn_sca_rule_attributes WHERE ((upper(user_column_name) like upper(p_search_uname)

94: -- attribute13,
95: -- attribute14,
96: -- attribute15,
97: -- object_version_number
98: -- FROM cn_sca_rule_attributes WHERE ((upper(user_column_name) like upper(p_search_uname)
99: -- and (transaction_source like p_search_trx_source))
100: -- OR ( transaction_source = p_search_trx_source ))
101: -- ORDER BY TO_NUMBER(substr(src_column_name,10));
102: --

Line 260: p_org_id IN cn_sca_rule_attributes.org_id%TYPE, -- MOAC Change

256: PROCEDURE Create_Credit_RuleAttr( p_api_version IN NUMBER,
257: p_init_msg_list IN VARCHAR2 ,
258: p_commit IN VARCHAR2,
259: p_valdiation_level IN VARCHAR2,
260: p_org_id IN cn_sca_rule_attributes.org_id%TYPE, -- MOAC Change
261: p_credit_rule_attr_rec IN credit_rule_attr_rec,
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2

Line 284: l_sca_rule_attribute_id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE :=0;

280: L_PROGRAM_TYPE VARCHAR2(30);
281: L_SECURITY_GROUP_ID NUMBER ;
282: l_credit_rule_attr_rec credit_rule_attr_rec;
283: l_value_set_id NUMBER;
284: l_sca_rule_attribute_id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE :=0;
285:
286:
287: /*-- CURSOR get_value_set_id IS
288: -- SELECT nvl(flex_value_set_id,0)

Line 348: SELECT count(*) into l_count from cn_sca_rule_attributes where

344: THEN
345: l_credit_rule_attr_rec.enable_flag := 'N';
346: END IF;
347:
348: SELECT count(*) into l_count from cn_sca_rule_attributes where
349: TRANSACTION_SOURCE = l_credit_rule_attr_rec.transaction_source
350: and ORG_ID = p_org_id -- MOAC Change
351: and ( SRC_COLUMN_NAME = l_credit_rule_attr_rec.destination_column OR upper(USER_COLUMN_NAME) = upper(trim(l_credit_rule_attr_rec.user_name)));
352:

Line 365: SELECT cn_sca_rule_attributes_s.nextval INTO l_sca_rule_attribute_id FROM sys.dual;

361:
362: RAISE FND_API.G_EXC_ERROR;
363: END IF ;
364:
365: SELECT cn_sca_rule_attributes_s.nextval INTO l_sca_rule_attribute_id FROM sys.dual;
366: -- API body
367:
368:
369: CN_SCA_CRRULEATTR_PKG.INSERT_ROW(

Line 440: fnd_message.set_name('CN', 'CN_SCA_RULE_ATTRIBUTES_UNIQUE');

436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO Create_Credit_RuleAttr;
438: IF SQLCODE = '-1'
439: THEN
440: fnd_message.set_name('CN', 'CN_SCA_RULE_ATTRIBUTES_UNIQUE');
441: fnd_msg_pub.ADD;
442: RAISE fnd_api.g_exc_error;
443: END IF;
444: --x_loading_status := 'UNEXPECTED_ERR';

Line 480: p_org_id IN cn_sca_rule_attributes.org_id%TYPE, -- MOAC Change

476: p_api_version IN NUMBER,
477: p_init_msg_list IN VARCHAR2 ,
478: p_commit IN VARCHAR2,
479: p_valdiation_level IN VARCHAR2,
480: p_org_id IN cn_sca_rule_attributes.org_id%TYPE, -- MOAC Change
481: p_credit_rule_attr_rec IN credit_rule_attr_rec,
482: -- p_old_credit_rule_attr_rec IN credit_rule_attr_rec,
483: x_return_status OUT NOCOPY VARCHAR2,
484: x_msg_count OUT NOCOPY NUMBER,

Line 511: -- l_sca_rule_attribute_id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE;

507: l_end_date DATE;
508: l_null_date CONSTANT DATE := to_date('31-12-3000','DD-MM-YYYY');
509: l_dummy NUMBER;
510: l_old_ovn NUMBER;
511: -- l_sca_rule_attribute_id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE;
512: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
513: l_trx_source_column cn_sca_rule_attributes.trx_src_column_name%TYPE;
514:
515: -- CURSOR get_value_set_id IS

Line 513: l_trx_source_column cn_sca_rule_attributes.trx_src_column_name%TYPE;

509: l_dummy NUMBER;
510: l_old_ovn NUMBER;
511: -- l_sca_rule_attribute_id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE;
512: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
513: l_trx_source_column cn_sca_rule_attributes.trx_src_column_name%TYPE;
514:
515: -- CURSOR get_value_set_id IS
516: -- SELECT flex_value_set_id
517: -- FROM fnd_flex_value_Sets

Line 550: FROM cn_sca_rule_attributes

546:
547:
548: SELECT object_version_number -- ,sca_rule_attribute_id
549: INTO l_old_ovn -- ,l_sca_rule_attribute_id
550: FROM cn_sca_rule_attributes
551: WHERE SCA_RULE_ATTRIBUTE_ID = l_credit_rule_attr_rec.sca_rule_attribute_id
552: AND ORG_ID = p_org_id; -- MOAC Change
553: -- TRANSACTION_SOURCE = p_old_credit_rule_attr_rec.transaction_source
554: -- and SRC_COLUMN_NAME = p_old_credit_rule_attr_rec.destination_column ;

Line 619: SELECT count(sca_rule_attribute_id) into l_count from cn_sca_rule_attributes where

615: l_credit_rule_attr_rec.user_name := l_credit_rule_attr_rec.destination_column;
616: END IF;
617:
618: --IF l_credit_rule_attr_rec.user_name <> p_old_credit_rule_attr_rec.user_name THEN
619: SELECT count(sca_rule_attribute_id) into l_count from cn_sca_rule_attributes where
620: TRANSACTION_SOURCE = l_credit_rule_attr_rec.transaction_source
621: and org_id = p_org_id -- MOAC Change
622: and upper(USER_COLUMN_NAME) = upper(trim(l_credit_rule_attr_rec.user_name));
623:

Line 646: from cn_sca_rule_attributes

642:
643: -- Changing the UNCYNC update checking condition to retrieve the existing source column
644: select trx_src_column_name
645: into l_trx_source_column
646: from cn_sca_rule_attributes
647: where sca_rule_attribute_id = l_credit_rule_attr_rec.sca_rule_attribute_id
648: and org_id = p_org_id; -- MOAC Change
649:
650: CN_SCA_CRRULEATTR_PKG.UPDATE_ROW(

Line 815: FROM CN_SCA_RULE_ATTRIBUTES

811: -- x_loading_status := 'CN_UPDATED';
812:
813: -- API body
814: SELECT count(*) into l_count
815: FROM CN_SCA_RULE_ATTRIBUTES
816: WHERE TRANSACTION_SOURCE='CN'
817: AND ORG_ID = p_org_id; -- MOAC Change
818:
819: IF l_count = 0 THEN