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_SRP_CUSTOMIZE_PUB dependencies on CN_SRP_QUOTA_ASSIGNS

Line 26: l_customized_flag_old CN_SRP_QUOTA_ASSIGNS.customized_flag%TYPE;

22:
23: l_api_name CONSTANT VARCHAR2(30) := 'Update_srp_quota_assign';
24: l_api_version CONSTANT NUMBER := 1.0;
25:
26: l_customized_flag_old CN_SRP_QUOTA_ASSIGNS.customized_flag%TYPE;
27: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;
28: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;
29: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;
30: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;

Line 27: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;

23: l_api_name CONSTANT VARCHAR2(30) := 'Update_srp_quota_assign';
24: l_api_version CONSTANT NUMBER := 1.0;
25:
26: l_customized_flag_old CN_SRP_QUOTA_ASSIGNS.customized_flag%TYPE;
27: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;
28: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;
29: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;
30: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;
31: l_performance_goal_old CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE;

Line 28: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;

24: l_api_version CONSTANT NUMBER := 1.0;
25:
26: l_customized_flag_old CN_SRP_QUOTA_ASSIGNS.customized_flag%TYPE;
27: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;
28: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;
29: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;
30: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;
31: l_performance_goal_old CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE;
32: l_quota_id NUMBER;

Line 29: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;

25:
26: l_customized_flag_old CN_SRP_QUOTA_ASSIGNS.customized_flag%TYPE;
27: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;
28: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;
29: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;
30: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;
31: l_performance_goal_old CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE;
32: l_quota_id NUMBER;
33: l_org_id NUMBER;

Line 30: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;

26: l_customized_flag_old CN_SRP_QUOTA_ASSIGNS.customized_flag%TYPE;
27: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;
28: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;
29: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;
30: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;
31: l_performance_goal_old CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE;
32: l_quota_id NUMBER;
33: l_org_id NUMBER;
34: l_status VARCHAR2(1);

Line 31: l_performance_goal_old CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE;

27: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;
28: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;
29: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;
30: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;
31: l_performance_goal_old CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE;
32: l_quota_id NUMBER;
33: l_org_id NUMBER;
34: l_status VARCHAR2(1);
35:

Line 84: from cn_srp_quota_assigns_all

80: ,l_payment_amount_old
81: ,l_performance_goal_old
82: ,l_quota_id
83: ,l_org_id
84: from cn_srp_quota_assigns_all
85: where srp_quota_assign_id = p_srp_quota_assign_id;
86:
87: -- validate org ID
88: mo_global.validate_orgid_pub_api

Line 99: cn_srp_quota_assigns_pkg.update_record(

95: 'Validated org_id = ' || l_org_id || ' status = ' || l_status);
96: end if;
97:
98:
99: cn_srp_quota_assigns_pkg.update_record(
100: p_srp_quota_assign_id
101: ,p_quota
102: ,l_target_old
103: ,null --x_start_period_id

Line 188: l_customized_flag_old CN_SRP_QUOTA_ASSIGNS.customized_flag%TYPE;

184: ) IS
185:
186: l_api_name CONSTANT VARCHAR2(30) := 'Change_srp_quota_custom_flag';
187: l_api_version CONSTANT NUMBER := 1.0;
188: l_customized_flag_old CN_SRP_QUOTA_ASSIGNS.customized_flag%TYPE;
189: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;
190: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;
191: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;
192: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;

Line 189: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;

185:
186: l_api_name CONSTANT VARCHAR2(30) := 'Change_srp_quota_custom_flag';
187: l_api_version CONSTANT NUMBER := 1.0;
188: l_customized_flag_old CN_SRP_QUOTA_ASSIGNS.customized_flag%TYPE;
189: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;
190: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;
191: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;
192: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;
193: l_performance_goal_old CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE;

Line 190: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;

186: l_api_name CONSTANT VARCHAR2(30) := 'Change_srp_quota_custom_flag';
187: l_api_version CONSTANT NUMBER := 1.0;
188: l_customized_flag_old CN_SRP_QUOTA_ASSIGNS.customized_flag%TYPE;
189: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;
190: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;
191: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;
192: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;
193: l_performance_goal_old CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE;
194:

Line 191: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;

187: l_api_version CONSTANT NUMBER := 1.0;
188: l_customized_flag_old CN_SRP_QUOTA_ASSIGNS.customized_flag%TYPE;
189: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;
190: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;
191: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;
192: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;
193: l_performance_goal_old CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE;
194:
195: l_quota_id CN_QUOTAS.quota_id%TYPE;

Line 192: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;

188: l_customized_flag_old CN_SRP_QUOTA_ASSIGNS.customized_flag%TYPE;
189: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;
190: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;
191: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;
192: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;
193: l_performance_goal_old CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE;
194:
195: l_quota_id CN_QUOTAS.quota_id%TYPE;
196: l_org_id NUMBER;

Line 193: l_performance_goal_old CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE;

189: l_target_old CN_SRP_QUOTA_ASSIGNS.target%TYPE;
190: l_ptdr_code_old CN_SRP_QUOTA_ASSIGNS.period_target_dist_rule_code%TYPE;
191: l_ptu_code_old CN_SRP_QUOTA_ASSIGNS.period_target_unit_code%TYPE;
192: l_payment_amount_old CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE;
193: l_performance_goal_old CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE;
194:
195: l_quota_id CN_QUOTAS.quota_id%TYPE;
196: l_org_id NUMBER;
197: l_status VARCHAR2(1);

Line 249: from cn_srp_quota_assigns_all

245: ,l_ptu_code_old
246: ,l_payment_amount_old
247: ,l_performance_goal_old
248: ,l_org_id
249: from cn_srp_quota_assigns_all
250: where srp_quota_assign_id = p_srp_quota_assign_id;
251:
252: -- validate org ID
253: mo_global.validate_orgid_pub_api

Line 263: cn_srp_quota_assigns_pkg.update_record(

259: 'cn.plsql.cn_srp_customize_pub.change_srp_quota_custom_flag.org_validate',
260: 'Validated org_id = ' || l_org_id || ' status = ' || l_status);
261: end if;
262:
263: cn_srp_quota_assigns_pkg.update_record(
264: p_srp_quota_assign_id
265: ,nvl(l_target_old,0)
266: ,nvl(l_target_old,0)
267: ,null --x_start_period_id