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 FND_API

Line 104: SELECT Decode(x_RULE_ID, FND_API.G_MISS_NUM, NULL,

100: L_ORG_ID NUMBER;
101:
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,

Line 108: SELECT Decode(x_RULESET_ID, FND_API.G_MISS_NUM, NULL,

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;
111:
112: SELECT Decode(x_PACKAGE_ID, FND_API.G_MISS_NUM, NULL,

Line 112: SELECT Decode(x_PACKAGE_ID, FND_API.G_MISS_NUM, NULL,

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;
115:
116: SELECT Decode(x_REVENUE_CLASS_ID, FND_API.G_MISS_NUM, NULL,

Line 116: SELECT Decode(x_REVENUE_CLASS_ID, FND_API.G_MISS_NUM, NULL,

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;
119:
120: SELECT Decode(x_expense_ccid, FND_API.G_MISS_NUM, NULL,

Line 120: SELECT Decode(x_expense_ccid, FND_API.G_MISS_NUM, NULL,

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;
123:
124: SELECT Decode(x_liability_ccid, FND_API.G_MISS_NUM, NULL,

Line 124: SELECT Decode(x_liability_ccid, FND_API.G_MISS_NUM, NULL,

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;
127:
128: SELECT Decode(x_NAME, FND_API.G_MISS_CHAR, NULL,

Line 128: SELECT Decode(x_NAME, FND_API.G_MISS_CHAR, NULL,

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;
131:
132: SELECT Decode(x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,

Line 132: SELECT Decode(x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,

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;
135:
136: SELECT Decode(x_CREATED_BY, FND_API.G_MISS_NUM, NULL,

Line 136: SELECT Decode(x_CREATED_BY, FND_API.G_MISS_NUM, NULL,

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;
139:
140: SELECT Decode(x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,

Line 140: SELECT Decode(x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,

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;
143:
144: SELECT Decode(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,

Line 144: SELECT Decode(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,

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;
147:
148: SELECT Decode(x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,

Line 148: SELECT Decode(x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,

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;
151:
152: SELECT Decode(x_ORG_ID, FND_API.G_MISS_NUM, NULL,

Line 152: SELECT Decode(x_ORG_ID, FND_API.G_MISS_NUM, NULL,

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;
155:
156: insert into CN_RULES_ALL_B

Line 644: p_init_msg_list => fnd_api.g_true,

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,
647: x_return_status => l_return_status,
648: x_msg_count => l_msg_count,

Line 645: p_commit => FND_API.G_FALSE,

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,
647: x_return_status => l_return_status,
648: x_msg_count => l_msg_count,
649: x_msg_data => l_msg_data,

Line 646: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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,
647: x_return_status => l_return_status,
648: x_msg_count => l_msg_count,
649: x_msg_data => l_msg_data,
650: x_loading_status => l_loading_status,

Line 654: IF(l_return_status = FND_API.g_ret_sts_success) THEN

650: x_loading_status => l_loading_status,
651: p_ruleset_rec => l_ruleset_rec);
652:
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

Line 705: p_init_msg_list => fnd_api.g_true,

701: l_rule_rec.revenue_class_name := k.revenue_class_name;
702:
703: cn_rule_pub.create_rule
704: ( p_api_version => 1.0,
705: p_init_msg_list => fnd_api.g_true,
706: p_commit => FND_API.G_FALSE,
707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
708: x_return_status => l_return_status,
709: x_msg_count => l_msg_count,

Line 706: p_commit => FND_API.G_FALSE,

702:
703: cn_rule_pub.create_rule
704: ( p_api_version => 1.0,
705: p_init_msg_list => fnd_api.g_true,
706: p_commit => FND_API.G_FALSE,
707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
708: x_return_status => l_return_status,
709: x_msg_count => l_msg_count,
710: x_msg_data => l_msg_data,

Line 707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

703: cn_rule_pub.create_rule
704: ( p_api_version => 1.0,
705: p_init_msg_list => fnd_api.g_true,
706: p_commit => FND_API.G_FALSE,
707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
708: x_return_status => l_return_status,
709: x_msg_count => l_msg_count,
710: x_msg_data => l_msg_data,
711: x_loading_status => l_loading_status,

Line 715: IF(l_return_status = FND_API.g_ret_sts_success) THEN

711: x_loading_status => l_loading_status,
712: p_rule_rec => l_rule_rec);
713:
714:
715: IF(l_return_status = FND_API.g_ret_sts_success) THEN
716:
717: UPDATE cn_clrl_api
718: SET loading_status = 'CN_RULE_INSERTED'
719: WHERE ruleset_name = i.ruleset_name

Line 785: p_init_msg_list => fnd_api.g_true,

781: l_ruleattribute_rec.data_flag := l.data_flag;
782:
783: cn_ruleattribute_pub.create_ruleattribute
784: ( p_api_version => 1.0,
785: p_init_msg_list => fnd_api.g_true,
786: p_commit => FND_API.G_FALSE,
787: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
788: x_return_status => l_return_status,
789: x_msg_count => l_msg_count,

Line 786: p_commit => FND_API.G_FALSE,

782:
783: cn_ruleattribute_pub.create_ruleattribute
784: ( p_api_version => 1.0,
785: p_init_msg_list => fnd_api.g_true,
786: p_commit => FND_API.G_FALSE,
787: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
788: x_return_status => l_return_status,
789: x_msg_count => l_msg_count,
790: x_msg_data => l_msg_data,

Line 787: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

783: cn_ruleattribute_pub.create_ruleattribute
784: ( p_api_version => 1.0,
785: p_init_msg_list => fnd_api.g_true,
786: p_commit => FND_API.G_FALSE,
787: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
788: x_return_status => l_return_status,
789: x_msg_count => l_msg_count,
790: x_msg_data => l_msg_data,
791: x_loading_status => l_loading_status,

Line 795: IF(l_return_status = FND_API.g_ret_sts_success) THEN

791: x_loading_status => l_loading_status,
792: p_ruleattribute_rec=> l_ruleattribute_rec);
793:
794:
795: IF(l_return_status = FND_API.g_ret_sts_success) THEN
796:
797: UPDATE cn_clrl_api
798: SET loading_status = 'CN_INSERTED'
799: WHERE ruleset_name = i.ruleset_name

Line 852: (p_msg_index => fnd_msg_pub.G_LAST,p_encoded => FND_API.G_FALSE);

848: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_OK');
849: FND_MSG_PUB.Add;
850: errbuf :=
851: FND_MSG_PUB.get
852: (p_msg_index => fnd_msg_pub.G_LAST,p_encoded => FND_API.G_FALSE);
853: ELSIF retcode = 1 THEN
854: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_WARN');
855: FND_MSG_PUB.Add;
856: errbuf :=

Line 858: (p_msg_index => fnd_msg_pub.G_LAST,p_encoded => FND_API.G_FALSE);

854: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_WARN');
855: FND_MSG_PUB.Add;
856: errbuf :=
857: FND_MSG_PUB.get
858: (p_msg_index => fnd_msg_pub.G_LAST,p_encoded => FND_API.G_FALSE);
859: ELSE
860: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_FAIL');
861: FND_MSG_PUB.Add;
862: errbuf :=

Line 864: (p_msg_index => fnd_msg_pub.G_LAST,p_encoded => FND_API.G_FALSE);

860: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_FAIL');
861: FND_MSG_PUB.Add;
862: errbuf :=
863: FND_MSG_PUB.get
864: (p_msg_index => fnd_msg_pub.G_LAST,p_encoded => FND_API.G_FALSE);
865: END IF;
866: */
867: null;
868: END upload;