DBA Data[Home] [Help]

APPS.HR_KI_INTEGRATIONS_API dependencies on STANDARD

Line 21: ,p_standard_code in varchar2 default null

17: ,p_party_name in varchar2 default null
18: ,p_party_site_name in varchar2 default null
19: ,p_transaction_type in varchar2 default null
20: ,p_transaction_subtype in varchar2 default null
21: ,p_standard_code in varchar2 default null
22: ,p_ext_trans_type in varchar2 default null
23: ,p_ext_trans_subtype in varchar2 default null
24: ,p_trans_direction in varchar2 default null
25: ,p_url in varchar2 default null

Line 92: ,p_standard_code => p_standard_code

88: ,p_party_name => p_party_name
89: ,p_party_site_name => p_party_site_name
90: ,p_transaction_type => p_transaction_type
91: ,p_transaction_subtype => p_transaction_subtype
92: ,p_standard_code => p_standard_code
93: ,p_ext_trans_type => p_ext_trans_type
94: ,p_ext_trans_subtype => p_ext_trans_subtype
95: ,p_trans_direction => p_trans_direction
96: ,p_url => p_url

Line 146: ,p_standard_code => p_standard_code

142: ,p_party_name => p_party_name
143: ,p_party_site_name => p_party_site_name
144: ,p_transaction_type => p_transaction_type
145: ,p_transaction_subtype => p_transaction_subtype
146: ,p_standard_code => p_standard_code
147: ,p_ext_trans_type => p_ext_trans_type
148: ,p_ext_trans_subtype => p_ext_trans_subtype
149: ,p_trans_direction => p_trans_direction
150: ,p_url => p_url

Line 204: ,p_standard_code => p_standard_code

200: ,p_party_name => p_party_name
201: ,p_party_site_name => p_party_site_name
202: ,p_transaction_type => p_transaction_type
203: ,p_transaction_subtype => p_transaction_subtype
204: ,p_standard_code => p_standard_code
205: ,p_ext_trans_type => p_ext_trans_type
206: ,p_ext_trans_subtype => p_ext_trans_subtype
207: ,p_trans_direction => p_trans_direction
208: ,p_url => p_url

Line 316: ,cur_standard_code in varchar2

312: ,cur_party_name in varchar2
313: ,cur_party_site_name in varchar2
314: ,cur_transaction_type in varchar2
315: ,cur_transaction_subtype in varchar2
316: ,cur_standard_code in varchar2
317: ,cur_ext_trans_type in varchar2
318: ,cur_ext_trans_subtype in varchar2
319: ,cur_trans_direction in varchar2
320: )

Line 330: and d.standard_code=cur_standard_code

326: and h.party_name=cur_party_name
327: and h.party_site_name=cur_party_site_name
328: and d.transaction_type=cur_transaction_type
329: and d.transaction_subtype=cur_transaction_subtype
330: and d.standard_code=cur_standard_code
331: and d.ext_type=cur_ext_trans_type
332: and d.ext_subtype=cur_ext_trans_subtype
333: and d.transaction_direction=cur_trans_direction;
334: l_key_ecx varchar2(1) ;

Line 343: ,STANDARD_CODE

339: ,PARTY_NAME
340: ,PARTY_SITE_NAME
341: ,TRANSACTION_TYPE
342: ,TRANSACTION_SUBTYPE
343: ,STANDARD_CODE
344: ,EXT_TRANS_TYPE
345: ,EXT_TRANS_SUBTYPE
346: ,TRANS_DIRECTION
347: ,URL

Line 385: l_standard_code varchar2(30);

381: l_party_name varchar2(360);
382: l_party_site_name varchar2(904);
383: l_transaction_type varchar2(100);
384: l_transaction_sub_type varchar2(100);
385: l_standard_code varchar2(30);
386: l_ext_trans_type varchar2(100);
387: l_ext_trans_sub_type varchar2(100);
388: l_trans_direction varchar2(20);
389: l_url varchar2(2000);

Line 456: l_standard_code,l_ext_trans_type,l_ext_trans_sub_type,

452: hr_utility.set_location('Start:'|| l_proc, 20);
453: OPEN csr_name;
454: FETCH csr_name INTO l_synched,l_party_type,l_party_name,
455: l_party_site_name,l_transaction_type,l_transaction_sub_type,
456: l_standard_code,l_ext_trans_type,l_ext_trans_sub_type,
457: l_trans_direction,l_url,l_ext_application_id,l_app_code,
458: l_apptype,l_appurl,l_logout_url,l_userfld,l_pwdfld,l_authused,
459: l_fname1,l_fval1,l_fname2,l_fval2,l_fname3,l_fval3,l_fname4,l_fval4,
460: l_fname5,l_fval5,l_fname6,l_fval6,l_fname7,l_fval7,l_fname8,

Line 600: and l_transaction_sub_type is not null and l_standard_code is not null

596: --if it is ECX integration then validate against ECX schema
597:
598: elsif(l_party_type is not null and l_party_name is not null
599: and l_party_site_name is not null and l_transaction_type is not null
600: and l_transaction_sub_type is not null and l_standard_code is not null
601: and l_ext_trans_type is not null and l_ext_trans_sub_type is not null
602: and l_trans_direction is not null
603: ) then
604:

Line 608: l_transaction_type,l_transaction_sub_type,l_standard_code,

604:
605: hr_utility.set_location('Validate against ECX:'|| l_proc, 60);
606:
607: open csr_ecx(l_party_type,l_party_name,l_party_site_name,
608: l_transaction_type,l_transaction_sub_type,l_standard_code,
609: l_ext_trans_type,l_ext_trans_sub_type,l_trans_direction
610: );
611: fetch csr_ecx into l_key_ecx;
612: if (csr_ecx%notfound)

Line 715: ,p_standard_code in varchar2 default hr_api.g_varchar2

711: ,p_party_name in varchar2 default hr_api.g_varchar2
712: ,p_party_site_name in varchar2 default hr_api.g_varchar2
713: ,p_transaction_type in varchar2 default hr_api.g_varchar2
714: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
715: ,p_standard_code in varchar2 default hr_api.g_varchar2
716: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
717: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
718: ,p_trans_direction in varchar2 default hr_api.g_varchar2
719: ,p_url in varchar2 default hr_api.g_varchar2

Line 819: l_standard_code varchar2(30) := p_standard_code;

815: l_party_name varchar2(360) := p_party_name;
816: l_party_site_name varchar2(904) := p_party_site_name;
817: l_transaction_type varchar2(100) := p_transaction_type;
818: l_transaction_sub_type varchar2(100) := p_transaction_subtype;
819: l_standard_code varchar2(30) := p_standard_code;
820: l_ext_trans_type varchar2(100) := p_ext_trans_type;
821: l_ext_trans_sub_type varchar2(100) := p_ext_trans_subtype;
822: l_trans_direction varchar2(20) := p_trans_direction;
823:

Line 852: ,p_standard_code => p_standard_code

848: ,p_party_name => p_party_name
849: ,p_party_site_name => p_party_site_name
850: ,p_transaction_type => p_transaction_type
851: ,p_transaction_subtype => p_transaction_subtype
852: ,p_standard_code => p_standard_code
853: ,p_ext_trans_type => p_ext_trans_type
854: ,p_ext_trans_subtype => p_ext_trans_subtype
855: ,p_trans_direction => p_trans_direction
856: ,p_url => p_url

Line 1113: l_standard_code := null;

1109: l_party_name := null;
1110: l_party_site_name := null;
1111: l_transaction_type := null;
1112: l_transaction_sub_type := null;
1113: l_standard_code := null;
1114: l_ext_trans_type := null;
1115: l_ext_trans_sub_type := null;
1116: l_trans_direction := null;
1117: end if;

Line 1168: ,p_standard_code => l_standard_code

1164: ,p_party_name => l_party_name
1165: ,p_party_site_name => l_party_site_name
1166: ,p_transaction_type => l_transaction_type
1167: ,p_transaction_subtype => l_transaction_sub_type
1168: ,p_standard_code => l_standard_code
1169: ,p_ext_trans_type => l_ext_trans_type
1170: ,p_ext_trans_subtype => l_ext_trans_sub_type
1171: ,p_trans_direction => l_trans_direction
1172:

Line 1227: ,p_standard_code => p_standard_code

1223: ,p_party_name => p_party_name
1224: ,p_party_site_name => p_party_site_name
1225: ,p_transaction_type => p_transaction_type
1226: ,p_transaction_subtype => p_transaction_subtype
1227: ,p_standard_code => p_standard_code
1228: ,p_ext_trans_type => p_ext_trans_type
1229: ,p_ext_trans_subtype => p_ext_trans_subtype
1230: ,p_trans_direction => p_trans_direction
1231: ,p_url => p_url