DBA Data[Home] [Help]

APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on STANDARD

Line 4: -- Standard WHO columns to be used across all the package

1: PACKAGE BODY igs_uc_exp_applicant_dtls AS
2: /* $Header: IGSUC44B.pls 120.6 2006/08/30 03:36:37 jbaber ship $ */
3:
4: -- Standard WHO columns to be used across all the package
5: g_created_by NUMBER := fnd_global.user_id;
6: g_last_updated_by NUMBER := g_created_by;
7: g_last_update_login NUMBER := fnd_global.login_id;
8:

Line 2816: -- This gets the US standard country code

2812: /* Derive Country Code */
2813: l_country_code := NULL ;
2814: IF p_ucas_country_code IS NOT NULL THEN
2815:
2816: -- This gets the US standard country code
2817: OPEN cur_map('UCAS_OSS_COUNTRY_ASSOC', p_ucas_country_code);
2818: FETCH cur_map INTO l_country_code;
2819: CLOSE cur_map;
2820: