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_PKG dependencies on CN_SCA_RULE_ATTRIBUTES_ALL_TL

Line 573: insert into CN_SCA_RULE_ATTRIBUTES_ALL_TL (

569: X_LAST_UPDATED_BY,
570: X_LAST_UPDATE_LOGIN
571: );
572:
573: insert into CN_SCA_RULE_ATTRIBUTES_ALL_TL (
574: ORG_ID, -- MOAC Change
575: SCA_RULE_ATTRIBUTE_ID,
576: USER_COLUMN_NAME,
577: CREATED_BY,

Line 601: from CN_SCA_RULE_ATTRIBUTES_ALL_TL T

597: from FND_LANGUAGES L
598: where L.INSTALLED_FLAG in ('I', 'B')
599: and not exists
600: (select NULL
601: from CN_SCA_RULE_ATTRIBUTES_ALL_TL T
602: where T.SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
603: and T.LANGUAGE = L.LANGUAGE_CODE
604: and T.ORG_ID = X_ORG_ID);
605:

Line 679: from CN_SCA_RULE_ATTRIBUTES_ALL_TL

675:
676: cursor c1 is select
677: USER_COLUMN_NAME,
678: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
679: from CN_SCA_RULE_ATTRIBUTES_ALL_TL
680: where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
681: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
682: and ORG_ID = X_ORG_ID
683: for update of SCA_RULE_ATTRIBUTE_ID nowait;

Line 827: update CN_SCA_RULE_ATTRIBUTES_ALL_TL set

823: if (sql%notfound) then
824: raise no_data_found;
825: end if;
826:
827: update CN_SCA_RULE_ATTRIBUTES_ALL_TL set
828: USER_COLUMN_NAME = X_USER_COLUMN_NAME,
829: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
830: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
831: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 847: delete from CN_SCA_RULE_ATTRIBUTES_ALL_TL

843: X_ORG_ID in NUMBER, -- MOAC Change
844: X_SCA_RULE_ATTRIBUTE_ID in NUMBER
845: ) is
846: begin
847: delete from CN_SCA_RULE_ATTRIBUTES_ALL_TL
848: where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
849: and ORG_ID = X_ORG_ID; -- MOAC Change
850:
851: if (sql%notfound) then

Line 867: delete from CN_SCA_RULE_ATTRIBUTES_ALL_TL T

863:
864: procedure ADD_LANGUAGE
865: is
866: begin
867: delete from CN_SCA_RULE_ATTRIBUTES_ALL_TL T
868: where not exists
869: (select NULL
870: from CN_SCA_RULE_ATTRIBUTES_ALL_B B
871: where B.SCA_RULE_ATTRIBUTE_ID = T.SCA_RULE_ATTRIBUTE_ID

Line 875: update CN_SCA_RULE_ATTRIBUTES_ALL_TL T set (

871: where B.SCA_RULE_ATTRIBUTE_ID = T.SCA_RULE_ATTRIBUTE_ID
872: and B.ORG_ID = T.ORG_ID -- MOAC Change
873: );
874:
875: update CN_SCA_RULE_ATTRIBUTES_ALL_TL T set (
876: USER_COLUMN_NAME
877: ) = (select
878: B.USER_COLUMN_NAME
879: from CN_SCA_RULE_ATTRIBUTES_ALL_TL B

Line 879: from CN_SCA_RULE_ATTRIBUTES_ALL_TL B

875: update CN_SCA_RULE_ATTRIBUTES_ALL_TL T set (
876: USER_COLUMN_NAME
877: ) = (select
878: B.USER_COLUMN_NAME
879: from CN_SCA_RULE_ATTRIBUTES_ALL_TL B
880: where B.SCA_RULE_ATTRIBUTE_ID = T.SCA_RULE_ATTRIBUTE_ID
881: and B.LANGUAGE = T.SOURCE_LANG
882: and B.ORG_ID = T.ORG_ID -- MOAC Change
883: )

Line 890: from CN_SCA_RULE_ATTRIBUTES_ALL_TL SUBB, CN_SCA_RULE_ATTRIBUTES_ALL_TL SUBT

886: T.LANGUAGE
887: ) in (select
888: SUBT.SCA_RULE_ATTRIBUTE_ID,
889: SUBT.LANGUAGE
890: from CN_SCA_RULE_ATTRIBUTES_ALL_TL SUBB, CN_SCA_RULE_ATTRIBUTES_ALL_TL SUBT
891: where SUBB.SCA_RULE_ATTRIBUTE_ID = SUBT.SCA_RULE_ATTRIBUTE_ID
892: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
893: and SUBB.ORG_ID = SUBT.ORG_ID -- MOAC Change
894: and (SUBB.USER_COLUMN_NAME <> SUBT.USER_COLUMN_NAME

Line 897: insert into CN_SCA_RULE_ATTRIBUTES_ALL_TL (

893: and SUBB.ORG_ID = SUBT.ORG_ID -- MOAC Change
894: and (SUBB.USER_COLUMN_NAME <> SUBT.USER_COLUMN_NAME
895: ));
896:
897: insert into CN_SCA_RULE_ATTRIBUTES_ALL_TL (
898: ORG_ID, -- MOAC Change
899: SCA_RULE_ATTRIBUTE_ID,
900: USER_COLUMN_NAME,
901: CREATED_BY,

Line 921: from CN_SCA_RULE_ATTRIBUTES_ALL_TL B, FND_LANGUAGES L

917: B.LAST_UPDATE_LOGIN,
918: B.SECURITY_GROUP_ID,
919: L.LANGUAGE_CODE,
920: B.SOURCE_LANG
921: from CN_SCA_RULE_ATTRIBUTES_ALL_TL B, FND_LANGUAGES L
922: where L.INSTALLED_FLAG in ('I', 'B')
923: and B.LANGUAGE = userenv('LANG')
924: and not exists
925: (select NULL

Line 926: from CN_SCA_RULE_ATTRIBUTES_ALL_TL T

922: where L.INSTALLED_FLAG in ('I', 'B')
923: and B.LANGUAGE = userenv('LANG')
924: and not exists
925: (select NULL
926: from CN_SCA_RULE_ATTRIBUTES_ALL_TL T
927: where T.SCA_RULE_ATTRIBUTE_ID = B.SCA_RULE_ATTRIBUTE_ID
928: and T.LANGUAGE = L.LANGUAGE_CODE
929: and B.ORG_ID = T.ORG_ID -- MOAC Change
930: );

Line 1003: UPDATE cn_sca_rule_attributes_all_tl SET

999: x_org_id
1000: );
1001: END IF;
1002: -- Load The record to _TL table
1003: UPDATE cn_sca_rule_attributes_all_tl SET
1004: USER_COLUMN_NAME = X_USER_COLUMN_NAME,
1005: last_update_date = sysdate,
1006: last_updated_by = user_id,
1007: last_update_login = 0,

Line 1014: INSERT INTO cn_sca_rule_attributes_all_tl

1010: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1011:
1012: IF (SQL%NOTFOUND) THEN
1013: -- Insert new record to _TL table
1014: INSERT INTO cn_sca_rule_attributes_all_tl
1015: (sca_rule_attribute_id,
1016: USER_COLUMN_NAME,
1017: creation_date,
1018: created_by,

Line 1038: FROM cn_sca_rule_attributes_all_tl t

1034: FROM fnd_languages l
1035: WHERE l.installed_flag IN ('I', 'B')
1036: AND NOT EXISTS
1037: (SELECT NULL
1038: FROM cn_sca_rule_attributes_all_tl t
1039: WHERE t.sca_rule_attribute_id = x_sca_rule_attribute_id
1040: AND t.language = l.language_code);
1041: END IF;
1042: << end_load_row >>

Line 1068: UPDATE cn_sca_rule_attributes_all_tl SET

1064: ELSE
1065: user_id := 0;
1066: END IF;
1067: -- Update the translation
1068: UPDATE cn_sca_rule_attributes_all_tl SET
1069: USER_COLUMN_NAME = X_USER_COLUMN_NAME,
1070: last_update_date = sysdate,
1071: last_updated_by = user_id,
1072: last_update_login = 0,