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.PER_CUSTOMIZED_RESTR_PKG dependencies on PAY_CUSTOMIZED_RESTRICTIONS

Line 45: from PAY_CUSTOMIZED_RESTRICTIONS pcr

41: from fnd_application
42: where application_short_name = upper(P_APPLICATION_SHORT_NAME);
43: CURSOR C1 (c1_p_appl_id number) IS
44: select 1
45: from PAY_CUSTOMIZED_RESTRICTIONS pcr
46: where pcr.application_id = c1_p_appl_id
47: and pcr.form_name = P_FORM_NAME
48: and pcr.name = P_NAME
49: and pcr.legislation_code = P_LEGISLATION_CODE

Line 89: cursor C is select ROWID from PAY_CUSTOMIZED_RESTRICTIONS

85: X_LAST_UPDATE_DATE in DATE,
86: X_LAST_UPDATED_BY in NUMBER,
87: X_LAST_UPDATE_LOGIN in NUMBER
88: ) is
89: cursor C is select ROWID from PAY_CUSTOMIZED_RESTRICTIONS
90: where CUSTOMIZED_RESTRICTION_ID = X_CUSTOMIZED_RESTRICTION_ID;
91:
92: cursor C_NEXTVAL is select PAY_CUSTOMIZED_RESTRICTIONS_S.NEXTVAL from SYS.DUAL;
93:

Line 92: cursor C_NEXTVAL is select PAY_CUSTOMIZED_RESTRICTIONS_S.NEXTVAL from SYS.DUAL;

88: ) is
89: cursor C is select ROWID from PAY_CUSTOMIZED_RESTRICTIONS
90: where CUSTOMIZED_RESTRICTION_ID = X_CUSTOMIZED_RESTRICTION_ID;
91:
92: cursor C_NEXTVAL is select PAY_CUSTOMIZED_RESTRICTIONS_S.NEXTVAL from SYS.DUAL;
93:
94: begin
95:
96:

Line 102: insert into PAY_CUSTOMIZED_RESTRICTIONS (

98: FETCH C_NEXTVAL INTO X_CUSTOMIZED_RESTRICTION_ID;
99: CLOSE C_NEXTVAL;
100:
101:
102: insert into PAY_CUSTOMIZED_RESTRICTIONS (
103: CUSTOMIZED_RESTRICTION_ID,
104: BUSINESS_GROUP_ID,
105: LEGISLATION_CODE,
106: APPLICATION_ID,

Line 202: from PAY_CUSTOMIZED_RESTRICTIONS

198: ENABLED_FLAG,
199: NAME,
200: COMMENTS,
201: LEGISLATION_SUBGROUP
202: from PAY_CUSTOMIZED_RESTRICTIONS
203: where CUSTOMIZED_RESTRICTION_ID = X_CUSTOMIZED_RESTRICTION_ID
204: for update of CUSTOMIZED_RESTRICTION_ID nowait;
205: recinfo c%rowtype;
206:

Line 275: update PAY_CUSTOMIZED_RESTRICTIONS set

271: X_LAST_UPDATED_BY in NUMBER,
272: X_LAST_UPDATE_LOGIN in NUMBER
273: ) is
274: begin
275: update PAY_CUSTOMIZED_RESTRICTIONS set
276: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
277: LEGISLATION_CODE = X_LEGISLATION_CODE,
278: APPLICATION_ID = X_APPLICATION_ID,
279: FORM_NAME = X_FORM_NAME,

Line 349: delete from PAY_CUSTOMIZED_RESTRICTIONS

345: if (sql%notfound) then
346: raise no_data_found;
347: end if;
348:
349: delete from PAY_CUSTOMIZED_RESTRICTIONS
350: where CUSTOMIZED_RESTRICTION_ID = X_CUSTOMIZED_RESTRICTION_ID;
351:
352: if (sql%notfound) then
353: raise no_data_found;

Line 373: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;

369: )
370: is
371: l_proc VARCHAR2(61) := 'PER_CUSTOMIZED_RESTR_PKG.LOAD_ROW';
372: l_rowid rowid;
373: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;
374: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
375: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
376: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
377: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;

Line 374: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;

370: is
371: l_proc VARCHAR2(61) := 'PER_CUSTOMIZED_RESTR_PKG.LOAD_ROW';
372: l_rowid rowid;
373: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;
374: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
375: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
376: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
377: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
378: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;

Line 375: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;

371: l_proc VARCHAR2(61) := 'PER_CUSTOMIZED_RESTR_PKG.LOAD_ROW';
372: l_rowid rowid;
373: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;
374: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
375: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
376: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
377: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
378: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
379: l_comments PAY_CUSTOMIZED_RESTRICTIONS.comments%TYPE ;

Line 376: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;

372: l_rowid rowid;
373: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;
374: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
375: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
376: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
377: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
378: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
379: l_comments PAY_CUSTOMIZED_RESTRICTIONS.comments%TYPE ;
380: l_business_group_id PAY_CUSTOMIZED_RESTRICTIONS.business_group_id%TYPE;

Line 377: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;

373: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;
374: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
375: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
376: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
377: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
378: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
379: l_comments PAY_CUSTOMIZED_RESTRICTIONS.comments%TYPE ;
380: l_business_group_id PAY_CUSTOMIZED_RESTRICTIONS.business_group_id%TYPE;
381: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;

Line 378: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;

374: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
375: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
376: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
377: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
378: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
379: l_comments PAY_CUSTOMIZED_RESTRICTIONS.comments%TYPE ;
380: l_business_group_id PAY_CUSTOMIZED_RESTRICTIONS.business_group_id%TYPE;
381: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;
382:

Line 379: l_comments PAY_CUSTOMIZED_RESTRICTIONS.comments%TYPE ;

375: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
376: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
377: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
378: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
379: l_comments PAY_CUSTOMIZED_RESTRICTIONS.comments%TYPE ;
380: l_business_group_id PAY_CUSTOMIZED_RESTRICTIONS.business_group_id%TYPE;
381: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;
382:
383: CURSOR C_APPL IS

Line 380: l_business_group_id PAY_CUSTOMIZED_RESTRICTIONS.business_group_id%TYPE;

376: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
377: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
378: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
379: l_comments PAY_CUSTOMIZED_RESTRICTIONS.comments%TYPE ;
380: l_business_group_id PAY_CUSTOMIZED_RESTRICTIONS.business_group_id%TYPE;
381: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;
382:
383: CURSOR C_APPL IS
384: select application_id

Line 381: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;

377: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
378: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
379: l_comments PAY_CUSTOMIZED_RESTRICTIONS.comments%TYPE ;
380: l_business_group_id PAY_CUSTOMIZED_RESTRICTIONS.business_group_id%TYPE;
381: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;
382:
383: CURSOR C_APPL IS
384: select application_id
385: from fnd_application

Line 390: from PAY_CUSTOMIZED_RESTRICTIONS pcr

386: where application_short_name = upper(X_APPLICATION_SHORT_NAME);
387:
388: CURSOR C1 IS
389: select customized_restriction_id , comments , business_group_id
390: from PAY_CUSTOMIZED_RESTRICTIONS pcr
391: where pcr.application_id = l_appl_id
392: and pcr.form_name = X_FORM_NAME
393: and pcr.name = X_NAME
394: and nvl(pcr.legislation_code,'XXX') = nvl(X_LEGISLATION_CODE,'XXX') ;

Line 477: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;

473: X_STANDARD_FORM_TITLE in VARCHAR2,
474: X_OWNER in varchar2
475: )
476: is
477: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;
478: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
479:
480: CURSOR C_APPL IS
481: select application_id

Line 478: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;

474: X_OWNER in varchar2
475: )
476: is
477: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;
478: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
479:
480: CURSOR C_APPL IS
481: select application_id
482: from fnd_application

Line 487: from PAY_CUSTOMIZED_RESTRICTIONS pcr

483: where application_short_name = upper(X_APPLICATION_SHORT_NAME);
484:
485: CURSOR C1 IS
486: select customized_restriction_id
487: from PAY_CUSTOMIZED_RESTRICTIONS pcr
488: where pcr.application_id = l_appl_id
489: and pcr.form_name = X_FORM_NAME
490: and pcr.name = X_NAME
491: and nvl(pcr.legislation_code,'XXX') = nvl(X_LEGISLATION_CODE,'XXX') ;

Line 526: from PAY_CUSTOMIZED_RESTRICTIONS B

522: begin
523: delete from PAY_CUSTOM_RESTRICTIONS_TL T
524: where not exists
525: (select NULL
526: from PAY_CUSTOMIZED_RESTRICTIONS B
527: where B.CUSTOMIZED_RESTRICTION_ID = T.CUSTOMIZED_RESTRICTION_ID
528: );
529:
530: update PAY_CUSTOM_RESTRICTIONS_TL T set (