DBA Data[Home] [Help]

APPS.PAY_CUST_RESTRICTIONS_PKG dependencies on STANDARD

Line 36: X_STANDARD_FORM_TITLE VARCHAR2

32: X_COMMENTS VARCHAR2,
33: X_LEGISLATION_SUBGROUP VARCHAR2,
34: X_OWNER VARCHAR2,
35: X_QUERY_FORM_TITLE VARCHAR2,
36: X_STANDARD_FORM_TITLE VARCHAR2
37: )
38: is
39: l_proc VARCHAR2(61) := 'PAY_CUST_RESTRICTIONS_PKG.LOAD_ROW';
40: l_rowid rowid;

Line 98: ,X_STANDARD_FORM_TITLE => X_STANDARD_FORM_TITLE

94: ,X_BUSINESS_GROUP_ID => null
95: ,X_LEGISLATION_CODE => X_LEGISLATION_CODE
96: ,X_ENABLED_FLAG => X_ENABLED_FLAG
97: ,X_QUERY_FORM_TITLE => X_QUERY_FORM_TITLE
98: ,X_STANDARD_FORM_TITLE => X_STANDARD_FORM_TITLE
99: ,X_COMMENTS => X_COMMENTS
100: ,X_LEGISLATION_SUBGROUP => nvl(X_LEGISLATION_SUBGROUP,l_legislation_subgroup)
101: ,X_LAST_UPDATE_DATE => l_last_update_date
102: ,X_LAST_UPDATED_BY => l_last_updated_by

Line 123: ,X_STANDARD_FORM_TITLE => X_STANDARD_FORM_TITLE

119: ,X_BUSINESS_GROUP_ID => null
120: ,X_LEGISLATION_CODE => X_LEGISLATION_CODE
121: ,X_ENABLED_FLAG => X_ENABLED_FLAG
122: ,X_QUERY_FORM_TITLE => X_QUERY_FORM_TITLE
123: ,X_STANDARD_FORM_TITLE => X_STANDARD_FORM_TITLE
124: ,X_COMMENTS => X_COMMENTS
125: ,X_LEGISLATION_SUBGROUP => X_LEGISLATION_SUBGROUP
126: ,X_CREATED_BY => l_created_by
127: ,X_CREATION_DATE => l_creation_date

Line 141: X_STANDARD_FORM_TITLE VARCHAR2 )

137: X_FORM_NAME VARCHAR2,
138: X_NAME VARCHAR2,
139: X_OWNER VARCHAR2,
140: X_QUERY_FORM_TITLE VARCHAR2,
141: X_STANDARD_FORM_TITLE VARCHAR2 )
142: is
143:
144: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
145:

Line 163: STANDARD_FORM_TITLE=nvl(X_STANDARD_FORM_TITLE,STANDARD_FORM_TITLE),

159: FETCH C1 INTO l_cust_rest_id ;
160: if C1%FOUND then
161: UPDATE PAY_CUSTOM_RESTRICTIONS_TL
162: SET QUERY_FORM_TITLE=nvl(X_QUERY_FORM_TITLE,QUERY_FORM_TITLE),
163: STANDARD_FORM_TITLE=nvl(X_STANDARD_FORM_TITLE,STANDARD_FORM_TITLE),
164: last_update_date = SYSDATE,
165: last_updated_by = decode(x_owner,'SEED',1,0),
166: last_update_login = 0,
167: SOURCE_LANG = userenv('LANG')