DBA Data[Home] [Help]

APPS.PQP_RIW_ENROLL_WRAPPER dependencies on HR_API

Line 31: l_enroll_rec.booking_status_type_id := hr_api.g_number ;

27: ==========================================================================
28: */
29: Hr_Utility.set_location(' One : ', 5);
30:
31: l_enroll_rec.booking_status_type_id := hr_api.g_number ;
32: l_enroll_rec.delegate_person_id := hr_api.g_number ;
33: l_enroll_rec.sponsor_contact_id := hr_api.g_number ;
34: l_enroll_rec.business_group_id := hr_api.g_number ;
35: l_enroll_rec.event_id := hr_api.g_number ;

Line 32: l_enroll_rec.delegate_person_id := hr_api.g_number ;

28: */
29: Hr_Utility.set_location(' One : ', 5);
30:
31: l_enroll_rec.booking_status_type_id := hr_api.g_number ;
32: l_enroll_rec.delegate_person_id := hr_api.g_number ;
33: l_enroll_rec.sponsor_contact_id := hr_api.g_number ;
34: l_enroll_rec.business_group_id := hr_api.g_number ;
35: l_enroll_rec.event_id := hr_api.g_number ;
36: l_enroll_rec.customer_id := hr_api.g_number ;

Line 33: l_enroll_rec.sponsor_contact_id := hr_api.g_number ;

29: Hr_Utility.set_location(' One : ', 5);
30:
31: l_enroll_rec.booking_status_type_id := hr_api.g_number ;
32: l_enroll_rec.delegate_person_id := hr_api.g_number ;
33: l_enroll_rec.sponsor_contact_id := hr_api.g_number ;
34: l_enroll_rec.business_group_id := hr_api.g_number ;
35: l_enroll_rec.event_id := hr_api.g_number ;
36: l_enroll_rec.customer_id := hr_api.g_number ;
37: l_enroll_rec.authorizer_person_id := hr_api.g_number ;

Line 34: l_enroll_rec.business_group_id := hr_api.g_number ;

30:
31: l_enroll_rec.booking_status_type_id := hr_api.g_number ;
32: l_enroll_rec.delegate_person_id := hr_api.g_number ;
33: l_enroll_rec.sponsor_contact_id := hr_api.g_number ;
34: l_enroll_rec.business_group_id := hr_api.g_number ;
35: l_enroll_rec.event_id := hr_api.g_number ;
36: l_enroll_rec.customer_id := hr_api.g_number ;
37: l_enroll_rec.authorizer_person_id := hr_api.g_number ;
38: l_enroll_rec.date_booking_placed := hr_api.g_date ;

Line 35: l_enroll_rec.event_id := hr_api.g_number ;

31: l_enroll_rec.booking_status_type_id := hr_api.g_number ;
32: l_enroll_rec.delegate_person_id := hr_api.g_number ;
33: l_enroll_rec.sponsor_contact_id := hr_api.g_number ;
34: l_enroll_rec.business_group_id := hr_api.g_number ;
35: l_enroll_rec.event_id := hr_api.g_number ;
36: l_enroll_rec.customer_id := hr_api.g_number ;
37: l_enroll_rec.authorizer_person_id := hr_api.g_number ;
38: l_enroll_rec.date_booking_placed := hr_api.g_date ;
39:

Line 36: l_enroll_rec.customer_id := hr_api.g_number ;

32: l_enroll_rec.delegate_person_id := hr_api.g_number ;
33: l_enroll_rec.sponsor_contact_id := hr_api.g_number ;
34: l_enroll_rec.business_group_id := hr_api.g_number ;
35: l_enroll_rec.event_id := hr_api.g_number ;
36: l_enroll_rec.customer_id := hr_api.g_number ;
37: l_enroll_rec.authorizer_person_id := hr_api.g_number ;
38: l_enroll_rec.date_booking_placed := hr_api.g_date ;
39:
40: l_enroll_rec.correspondent := hr_api.g_varchar2 ;

Line 37: l_enroll_rec.authorizer_person_id := hr_api.g_number ;

33: l_enroll_rec.sponsor_contact_id := hr_api.g_number ;
34: l_enroll_rec.business_group_id := hr_api.g_number ;
35: l_enroll_rec.event_id := hr_api.g_number ;
36: l_enroll_rec.customer_id := hr_api.g_number ;
37: l_enroll_rec.authorizer_person_id := hr_api.g_number ;
38: l_enroll_rec.date_booking_placed := hr_api.g_date ;
39:
40: l_enroll_rec.correspondent := hr_api.g_varchar2 ;
41: l_enroll_rec.internal_booking_flag := hr_api.g_varchar2 ;

Line 38: l_enroll_rec.date_booking_placed := hr_api.g_date ;

34: l_enroll_rec.business_group_id := hr_api.g_number ;
35: l_enroll_rec.event_id := hr_api.g_number ;
36: l_enroll_rec.customer_id := hr_api.g_number ;
37: l_enroll_rec.authorizer_person_id := hr_api.g_number ;
38: l_enroll_rec.date_booking_placed := hr_api.g_date ;
39:
40: l_enroll_rec.correspondent := hr_api.g_varchar2 ;
41: l_enroll_rec.internal_booking_flag := hr_api.g_varchar2 ;
42: l_enroll_rec.number_of_places := hr_api.g_number ;

Line 40: l_enroll_rec.correspondent := hr_api.g_varchar2 ;

36: l_enroll_rec.customer_id := hr_api.g_number ;
37: l_enroll_rec.authorizer_person_id := hr_api.g_number ;
38: l_enroll_rec.date_booking_placed := hr_api.g_date ;
39:
40: l_enroll_rec.correspondent := hr_api.g_varchar2 ;
41: l_enroll_rec.internal_booking_flag := hr_api.g_varchar2 ;
42: l_enroll_rec.number_of_places := hr_api.g_number ;
43: l_enroll_rec.administrator := hr_api.g_number ;
44: l_enroll_rec.booking_priority := hr_api.g_varchar2 ;

Line 41: l_enroll_rec.internal_booking_flag := hr_api.g_varchar2 ;

37: l_enroll_rec.authorizer_person_id := hr_api.g_number ;
38: l_enroll_rec.date_booking_placed := hr_api.g_date ;
39:
40: l_enroll_rec.correspondent := hr_api.g_varchar2 ;
41: l_enroll_rec.internal_booking_flag := hr_api.g_varchar2 ;
42: l_enroll_rec.number_of_places := hr_api.g_number ;
43: l_enroll_rec.administrator := hr_api.g_number ;
44: l_enroll_rec.booking_priority := hr_api.g_varchar2 ;
45: l_enroll_rec.comments := hr_api.g_varchar2 ;

Line 42: l_enroll_rec.number_of_places := hr_api.g_number ;

38: l_enroll_rec.date_booking_placed := hr_api.g_date ;
39:
40: l_enroll_rec.correspondent := hr_api.g_varchar2 ;
41: l_enroll_rec.internal_booking_flag := hr_api.g_varchar2 ;
42: l_enroll_rec.number_of_places := hr_api.g_number ;
43: l_enroll_rec.administrator := hr_api.g_number ;
44: l_enroll_rec.booking_priority := hr_api.g_varchar2 ;
45: l_enroll_rec.comments := hr_api.g_varchar2 ;
46: l_enroll_rec.contact_address_id := hr_api.g_number ;

Line 43: l_enroll_rec.administrator := hr_api.g_number ;

39:
40: l_enroll_rec.correspondent := hr_api.g_varchar2 ;
41: l_enroll_rec.internal_booking_flag := hr_api.g_varchar2 ;
42: l_enroll_rec.number_of_places := hr_api.g_number ;
43: l_enroll_rec.administrator := hr_api.g_number ;
44: l_enroll_rec.booking_priority := hr_api.g_varchar2 ;
45: l_enroll_rec.comments := hr_api.g_varchar2 ;
46: l_enroll_rec.contact_address_id := hr_api.g_number ;
47:

Line 44: l_enroll_rec.booking_priority := hr_api.g_varchar2 ;

40: l_enroll_rec.correspondent := hr_api.g_varchar2 ;
41: l_enroll_rec.internal_booking_flag := hr_api.g_varchar2 ;
42: l_enroll_rec.number_of_places := hr_api.g_number ;
43: l_enroll_rec.administrator := hr_api.g_number ;
44: l_enroll_rec.booking_priority := hr_api.g_varchar2 ;
45: l_enroll_rec.comments := hr_api.g_varchar2 ;
46: l_enroll_rec.contact_address_id := hr_api.g_number ;
47:
48: l_enroll_rec.correspondent_phone := hr_api.g_varchar2 ;

Line 45: l_enroll_rec.comments := hr_api.g_varchar2 ;

41: l_enroll_rec.internal_booking_flag := hr_api.g_varchar2 ;
42: l_enroll_rec.number_of_places := hr_api.g_number ;
43: l_enroll_rec.administrator := hr_api.g_number ;
44: l_enroll_rec.booking_priority := hr_api.g_varchar2 ;
45: l_enroll_rec.comments := hr_api.g_varchar2 ;
46: l_enroll_rec.contact_address_id := hr_api.g_number ;
47:
48: l_enroll_rec.correspondent_phone := hr_api.g_varchar2 ;
49: l_enroll_rec.correspondent_fax := hr_api.g_varchar2 ;

Line 46: l_enroll_rec.contact_address_id := hr_api.g_number ;

42: l_enroll_rec.number_of_places := hr_api.g_number ;
43: l_enroll_rec.administrator := hr_api.g_number ;
44: l_enroll_rec.booking_priority := hr_api.g_varchar2 ;
45: l_enroll_rec.comments := hr_api.g_varchar2 ;
46: l_enroll_rec.contact_address_id := hr_api.g_number ;
47:
48: l_enroll_rec.correspondent_phone := hr_api.g_varchar2 ;
49: l_enroll_rec.correspondent_fax := hr_api.g_varchar2 ;
50: l_enroll_rec.third_party_customer_id := hr_api.g_number ;

Line 48: l_enroll_rec.correspondent_phone := hr_api.g_varchar2 ;

44: l_enroll_rec.booking_priority := hr_api.g_varchar2 ;
45: l_enroll_rec.comments := hr_api.g_varchar2 ;
46: l_enroll_rec.contact_address_id := hr_api.g_number ;
47:
48: l_enroll_rec.correspondent_phone := hr_api.g_varchar2 ;
49: l_enroll_rec.correspondent_fax := hr_api.g_varchar2 ;
50: l_enroll_rec.third_party_customer_id := hr_api.g_number ;
51: l_enroll_rec.third_party_contact_id := hr_api.g_number ;
52: l_enroll_rec.third_party_address_id := hr_api.g_number ;

Line 49: l_enroll_rec.correspondent_fax := hr_api.g_varchar2 ;

45: l_enroll_rec.comments := hr_api.g_varchar2 ;
46: l_enroll_rec.contact_address_id := hr_api.g_number ;
47:
48: l_enroll_rec.correspondent_phone := hr_api.g_varchar2 ;
49: l_enroll_rec.correspondent_fax := hr_api.g_varchar2 ;
50: l_enroll_rec.third_party_customer_id := hr_api.g_number ;
51: l_enroll_rec.third_party_contact_id := hr_api.g_number ;
52: l_enroll_rec.third_party_address_id := hr_api.g_number ;
53: l_enroll_rec.third_party_contact_phone := hr_api.g_varchar2 ;

Line 50: l_enroll_rec.third_party_customer_id := hr_api.g_number ;

46: l_enroll_rec.contact_address_id := hr_api.g_number ;
47:
48: l_enroll_rec.correspondent_phone := hr_api.g_varchar2 ;
49: l_enroll_rec.correspondent_fax := hr_api.g_varchar2 ;
50: l_enroll_rec.third_party_customer_id := hr_api.g_number ;
51: l_enroll_rec.third_party_contact_id := hr_api.g_number ;
52: l_enroll_rec.third_party_address_id := hr_api.g_number ;
53: l_enroll_rec.third_party_contact_phone := hr_api.g_varchar2 ;
54: l_enroll_rec.third_party_contact_fax := hr_api.g_varchar2 ;

Line 51: l_enroll_rec.third_party_contact_id := hr_api.g_number ;

47:
48: l_enroll_rec.correspondent_phone := hr_api.g_varchar2 ;
49: l_enroll_rec.correspondent_fax := hr_api.g_varchar2 ;
50: l_enroll_rec.third_party_customer_id := hr_api.g_number ;
51: l_enroll_rec.third_party_contact_id := hr_api.g_number ;
52: l_enroll_rec.third_party_address_id := hr_api.g_number ;
53: l_enroll_rec.third_party_contact_phone := hr_api.g_varchar2 ;
54: l_enroll_rec.third_party_contact_fax := hr_api.g_varchar2 ;
55: l_enroll_rec.date_status_changed := hr_api.g_date ;

Line 52: l_enroll_rec.third_party_address_id := hr_api.g_number ;

48: l_enroll_rec.correspondent_phone := hr_api.g_varchar2 ;
49: l_enroll_rec.correspondent_fax := hr_api.g_varchar2 ;
50: l_enroll_rec.third_party_customer_id := hr_api.g_number ;
51: l_enroll_rec.third_party_contact_id := hr_api.g_number ;
52: l_enroll_rec.third_party_address_id := hr_api.g_number ;
53: l_enroll_rec.third_party_contact_phone := hr_api.g_varchar2 ;
54: l_enroll_rec.third_party_contact_fax := hr_api.g_varchar2 ;
55: l_enroll_rec.date_status_changed := hr_api.g_date ;
56:

Line 53: l_enroll_rec.third_party_contact_phone := hr_api.g_varchar2 ;

49: l_enroll_rec.correspondent_fax := hr_api.g_varchar2 ;
50: l_enroll_rec.third_party_customer_id := hr_api.g_number ;
51: l_enroll_rec.third_party_contact_id := hr_api.g_number ;
52: l_enroll_rec.third_party_address_id := hr_api.g_number ;
53: l_enroll_rec.third_party_contact_phone := hr_api.g_varchar2 ;
54: l_enroll_rec.third_party_contact_fax := hr_api.g_varchar2 ;
55: l_enroll_rec.date_status_changed := hr_api.g_date ;
56:
57: -- l_enroll_rec.status_change_comments := hr_api.g_varchar2 ;

Line 54: l_enroll_rec.third_party_contact_fax := hr_api.g_varchar2 ;

50: l_enroll_rec.third_party_customer_id := hr_api.g_number ;
51: l_enroll_rec.third_party_contact_id := hr_api.g_number ;
52: l_enroll_rec.third_party_address_id := hr_api.g_number ;
53: l_enroll_rec.third_party_contact_phone := hr_api.g_varchar2 ;
54: l_enroll_rec.third_party_contact_fax := hr_api.g_varchar2 ;
55: l_enroll_rec.date_status_changed := hr_api.g_date ;
56:
57: -- l_enroll_rec.status_change_comments := hr_api.g_varchar2 ;
58: l_enroll_rec.failure_reason := hr_api.g_varchar2 ;

Line 55: l_enroll_rec.date_status_changed := hr_api.g_date ;

51: l_enroll_rec.third_party_contact_id := hr_api.g_number ;
52: l_enroll_rec.third_party_address_id := hr_api.g_number ;
53: l_enroll_rec.third_party_contact_phone := hr_api.g_varchar2 ;
54: l_enroll_rec.third_party_contact_fax := hr_api.g_varchar2 ;
55: l_enroll_rec.date_status_changed := hr_api.g_date ;
56:
57: -- l_enroll_rec.status_change_comments := hr_api.g_varchar2 ;
58: l_enroll_rec.failure_reason := hr_api.g_varchar2 ;
59: l_enroll_rec.attendance_result := hr_api.g_varchar2 ;

Line 57: -- l_enroll_rec.status_change_comments := hr_api.g_varchar2 ;

53: l_enroll_rec.third_party_contact_phone := hr_api.g_varchar2 ;
54: l_enroll_rec.third_party_contact_fax := hr_api.g_varchar2 ;
55: l_enroll_rec.date_status_changed := hr_api.g_date ;
56:
57: -- l_enroll_rec.status_change_comments := hr_api.g_varchar2 ;
58: l_enroll_rec.failure_reason := hr_api.g_varchar2 ;
59: l_enroll_rec.attendance_result := hr_api.g_varchar2 ;
60: l_enroll_rec.language_id := hr_api.g_number ;
61: l_enroll_rec.source_of_booking := hr_api.g_varchar2 ;

Line 58: l_enroll_rec.failure_reason := hr_api.g_varchar2 ;

54: l_enroll_rec.third_party_contact_fax := hr_api.g_varchar2 ;
55: l_enroll_rec.date_status_changed := hr_api.g_date ;
56:
57: -- l_enroll_rec.status_change_comments := hr_api.g_varchar2 ;
58: l_enroll_rec.failure_reason := hr_api.g_varchar2 ;
59: l_enroll_rec.attendance_result := hr_api.g_varchar2 ;
60: l_enroll_rec.language_id := hr_api.g_number ;
61: l_enroll_rec.source_of_booking := hr_api.g_varchar2 ;
62: l_enroll_rec.special_booking_instructions := hr_api.g_varchar2 ;

Line 59: l_enroll_rec.attendance_result := hr_api.g_varchar2 ;

55: l_enroll_rec.date_status_changed := hr_api.g_date ;
56:
57: -- l_enroll_rec.status_change_comments := hr_api.g_varchar2 ;
58: l_enroll_rec.failure_reason := hr_api.g_varchar2 ;
59: l_enroll_rec.attendance_result := hr_api.g_varchar2 ;
60: l_enroll_rec.language_id := hr_api.g_number ;
61: l_enroll_rec.source_of_booking := hr_api.g_varchar2 ;
62: l_enroll_rec.special_booking_instructions := hr_api.g_varchar2 ;
63: l_enroll_rec.successful_attendance_flag := hr_api.g_varchar2 ;

Line 60: l_enroll_rec.language_id := hr_api.g_number ;

56:
57: -- l_enroll_rec.status_change_comments := hr_api.g_varchar2 ;
58: l_enroll_rec.failure_reason := hr_api.g_varchar2 ;
59: l_enroll_rec.attendance_result := hr_api.g_varchar2 ;
60: l_enroll_rec.language_id := hr_api.g_number ;
61: l_enroll_rec.source_of_booking := hr_api.g_varchar2 ;
62: l_enroll_rec.special_booking_instructions := hr_api.g_varchar2 ;
63: l_enroll_rec.successful_attendance_flag := hr_api.g_varchar2 ;
64: l_enroll_rec.tdb_information_category := hr_api.g_varchar2 ;

Line 61: l_enroll_rec.source_of_booking := hr_api.g_varchar2 ;

57: -- l_enroll_rec.status_change_comments := hr_api.g_varchar2 ;
58: l_enroll_rec.failure_reason := hr_api.g_varchar2 ;
59: l_enroll_rec.attendance_result := hr_api.g_varchar2 ;
60: l_enroll_rec.language_id := hr_api.g_number ;
61: l_enroll_rec.source_of_booking := hr_api.g_varchar2 ;
62: l_enroll_rec.special_booking_instructions := hr_api.g_varchar2 ;
63: l_enroll_rec.successful_attendance_flag := hr_api.g_varchar2 ;
64: l_enroll_rec.tdb_information_category := hr_api.g_varchar2 ;
65: l_enroll_rec.tdb_information1 := hr_api.g_varchar2 ;

Line 62: l_enroll_rec.special_booking_instructions := hr_api.g_varchar2 ;

58: l_enroll_rec.failure_reason := hr_api.g_varchar2 ;
59: l_enroll_rec.attendance_result := hr_api.g_varchar2 ;
60: l_enroll_rec.language_id := hr_api.g_number ;
61: l_enroll_rec.source_of_booking := hr_api.g_varchar2 ;
62: l_enroll_rec.special_booking_instructions := hr_api.g_varchar2 ;
63: l_enroll_rec.successful_attendance_flag := hr_api.g_varchar2 ;
64: l_enroll_rec.tdb_information_category := hr_api.g_varchar2 ;
65: l_enroll_rec.tdb_information1 := hr_api.g_varchar2 ;
66:

Line 63: l_enroll_rec.successful_attendance_flag := hr_api.g_varchar2 ;

59: l_enroll_rec.attendance_result := hr_api.g_varchar2 ;
60: l_enroll_rec.language_id := hr_api.g_number ;
61: l_enroll_rec.source_of_booking := hr_api.g_varchar2 ;
62: l_enroll_rec.special_booking_instructions := hr_api.g_varchar2 ;
63: l_enroll_rec.successful_attendance_flag := hr_api.g_varchar2 ;
64: l_enroll_rec.tdb_information_category := hr_api.g_varchar2 ;
65: l_enroll_rec.tdb_information1 := hr_api.g_varchar2 ;
66:
67: l_enroll_rec.tdb_information2 := hr_api.g_varchar2 ;

Line 64: l_enroll_rec.tdb_information_category := hr_api.g_varchar2 ;

60: l_enroll_rec.language_id := hr_api.g_number ;
61: l_enroll_rec.source_of_booking := hr_api.g_varchar2 ;
62: l_enroll_rec.special_booking_instructions := hr_api.g_varchar2 ;
63: l_enroll_rec.successful_attendance_flag := hr_api.g_varchar2 ;
64: l_enroll_rec.tdb_information_category := hr_api.g_varchar2 ;
65: l_enroll_rec.tdb_information1 := hr_api.g_varchar2 ;
66:
67: l_enroll_rec.tdb_information2 := hr_api.g_varchar2 ;
68: l_enroll_rec.tdb_information3 := hr_api.g_varchar2 ;

Line 65: l_enroll_rec.tdb_information1 := hr_api.g_varchar2 ;

61: l_enroll_rec.source_of_booking := hr_api.g_varchar2 ;
62: l_enroll_rec.special_booking_instructions := hr_api.g_varchar2 ;
63: l_enroll_rec.successful_attendance_flag := hr_api.g_varchar2 ;
64: l_enroll_rec.tdb_information_category := hr_api.g_varchar2 ;
65: l_enroll_rec.tdb_information1 := hr_api.g_varchar2 ;
66:
67: l_enroll_rec.tdb_information2 := hr_api.g_varchar2 ;
68: l_enroll_rec.tdb_information3 := hr_api.g_varchar2 ;
69: l_enroll_rec.tdb_information4 := hr_api.g_varchar2 ;

Line 67: l_enroll_rec.tdb_information2 := hr_api.g_varchar2 ;

63: l_enroll_rec.successful_attendance_flag := hr_api.g_varchar2 ;
64: l_enroll_rec.tdb_information_category := hr_api.g_varchar2 ;
65: l_enroll_rec.tdb_information1 := hr_api.g_varchar2 ;
66:
67: l_enroll_rec.tdb_information2 := hr_api.g_varchar2 ;
68: l_enroll_rec.tdb_information3 := hr_api.g_varchar2 ;
69: l_enroll_rec.tdb_information4 := hr_api.g_varchar2 ;
70: l_enroll_rec.tdb_information5 := hr_api.g_varchar2 ;
71: l_enroll_rec.tdb_information6 := hr_api.g_varchar2 ;

Line 68: l_enroll_rec.tdb_information3 := hr_api.g_varchar2 ;

64: l_enroll_rec.tdb_information_category := hr_api.g_varchar2 ;
65: l_enroll_rec.tdb_information1 := hr_api.g_varchar2 ;
66:
67: l_enroll_rec.tdb_information2 := hr_api.g_varchar2 ;
68: l_enroll_rec.tdb_information3 := hr_api.g_varchar2 ;
69: l_enroll_rec.tdb_information4 := hr_api.g_varchar2 ;
70: l_enroll_rec.tdb_information5 := hr_api.g_varchar2 ;
71: l_enroll_rec.tdb_information6 := hr_api.g_varchar2 ;
72: l_enroll_rec.tdb_information7 := hr_api.g_varchar2 ;

Line 69: l_enroll_rec.tdb_information4 := hr_api.g_varchar2 ;

65: l_enroll_rec.tdb_information1 := hr_api.g_varchar2 ;
66:
67: l_enroll_rec.tdb_information2 := hr_api.g_varchar2 ;
68: l_enroll_rec.tdb_information3 := hr_api.g_varchar2 ;
69: l_enroll_rec.tdb_information4 := hr_api.g_varchar2 ;
70: l_enroll_rec.tdb_information5 := hr_api.g_varchar2 ;
71: l_enroll_rec.tdb_information6 := hr_api.g_varchar2 ;
72: l_enroll_rec.tdb_information7 := hr_api.g_varchar2 ;
73: l_enroll_rec.tdb_information8 := hr_api.g_varchar2 ;

Line 70: l_enroll_rec.tdb_information5 := hr_api.g_varchar2 ;

66:
67: l_enroll_rec.tdb_information2 := hr_api.g_varchar2 ;
68: l_enroll_rec.tdb_information3 := hr_api.g_varchar2 ;
69: l_enroll_rec.tdb_information4 := hr_api.g_varchar2 ;
70: l_enroll_rec.tdb_information5 := hr_api.g_varchar2 ;
71: l_enroll_rec.tdb_information6 := hr_api.g_varchar2 ;
72: l_enroll_rec.tdb_information7 := hr_api.g_varchar2 ;
73: l_enroll_rec.tdb_information8 := hr_api.g_varchar2 ;
74: l_enroll_rec.tdb_information9 := hr_api.g_varchar2 ;

Line 71: l_enroll_rec.tdb_information6 := hr_api.g_varchar2 ;

67: l_enroll_rec.tdb_information2 := hr_api.g_varchar2 ;
68: l_enroll_rec.tdb_information3 := hr_api.g_varchar2 ;
69: l_enroll_rec.tdb_information4 := hr_api.g_varchar2 ;
70: l_enroll_rec.tdb_information5 := hr_api.g_varchar2 ;
71: l_enroll_rec.tdb_information6 := hr_api.g_varchar2 ;
72: l_enroll_rec.tdb_information7 := hr_api.g_varchar2 ;
73: l_enroll_rec.tdb_information8 := hr_api.g_varchar2 ;
74: l_enroll_rec.tdb_information9 := hr_api.g_varchar2 ;
75: l_enroll_rec.tdb_information10 := hr_api.g_varchar2 ;

Line 72: l_enroll_rec.tdb_information7 := hr_api.g_varchar2 ;

68: l_enroll_rec.tdb_information3 := hr_api.g_varchar2 ;
69: l_enroll_rec.tdb_information4 := hr_api.g_varchar2 ;
70: l_enroll_rec.tdb_information5 := hr_api.g_varchar2 ;
71: l_enroll_rec.tdb_information6 := hr_api.g_varchar2 ;
72: l_enroll_rec.tdb_information7 := hr_api.g_varchar2 ;
73: l_enroll_rec.tdb_information8 := hr_api.g_varchar2 ;
74: l_enroll_rec.tdb_information9 := hr_api.g_varchar2 ;
75: l_enroll_rec.tdb_information10 := hr_api.g_varchar2 ;
76:

Line 73: l_enroll_rec.tdb_information8 := hr_api.g_varchar2 ;

69: l_enroll_rec.tdb_information4 := hr_api.g_varchar2 ;
70: l_enroll_rec.tdb_information5 := hr_api.g_varchar2 ;
71: l_enroll_rec.tdb_information6 := hr_api.g_varchar2 ;
72: l_enroll_rec.tdb_information7 := hr_api.g_varchar2 ;
73: l_enroll_rec.tdb_information8 := hr_api.g_varchar2 ;
74: l_enroll_rec.tdb_information9 := hr_api.g_varchar2 ;
75: l_enroll_rec.tdb_information10 := hr_api.g_varchar2 ;
76:
77: l_enroll_rec.tdb_information11 := hr_api.g_varchar2 ;

Line 74: l_enroll_rec.tdb_information9 := hr_api.g_varchar2 ;

70: l_enroll_rec.tdb_information5 := hr_api.g_varchar2 ;
71: l_enroll_rec.tdb_information6 := hr_api.g_varchar2 ;
72: l_enroll_rec.tdb_information7 := hr_api.g_varchar2 ;
73: l_enroll_rec.tdb_information8 := hr_api.g_varchar2 ;
74: l_enroll_rec.tdb_information9 := hr_api.g_varchar2 ;
75: l_enroll_rec.tdb_information10 := hr_api.g_varchar2 ;
76:
77: l_enroll_rec.tdb_information11 := hr_api.g_varchar2 ;
78: l_enroll_rec.tdb_information12 := hr_api.g_varchar2 ;

Line 75: l_enroll_rec.tdb_information10 := hr_api.g_varchar2 ;

71: l_enroll_rec.tdb_information6 := hr_api.g_varchar2 ;
72: l_enroll_rec.tdb_information7 := hr_api.g_varchar2 ;
73: l_enroll_rec.tdb_information8 := hr_api.g_varchar2 ;
74: l_enroll_rec.tdb_information9 := hr_api.g_varchar2 ;
75: l_enroll_rec.tdb_information10 := hr_api.g_varchar2 ;
76:
77: l_enroll_rec.tdb_information11 := hr_api.g_varchar2 ;
78: l_enroll_rec.tdb_information12 := hr_api.g_varchar2 ;
79: l_enroll_rec.tdb_information13 := hr_api.g_varchar2 ;

Line 77: l_enroll_rec.tdb_information11 := hr_api.g_varchar2 ;

73: l_enroll_rec.tdb_information8 := hr_api.g_varchar2 ;
74: l_enroll_rec.tdb_information9 := hr_api.g_varchar2 ;
75: l_enroll_rec.tdb_information10 := hr_api.g_varchar2 ;
76:
77: l_enroll_rec.tdb_information11 := hr_api.g_varchar2 ;
78: l_enroll_rec.tdb_information12 := hr_api.g_varchar2 ;
79: l_enroll_rec.tdb_information13 := hr_api.g_varchar2 ;
80: l_enroll_rec.tdb_information14 := hr_api.g_varchar2 ;
81: l_enroll_rec.tdb_information15 := hr_api.g_varchar2 ;

Line 78: l_enroll_rec.tdb_information12 := hr_api.g_varchar2 ;

74: l_enroll_rec.tdb_information9 := hr_api.g_varchar2 ;
75: l_enroll_rec.tdb_information10 := hr_api.g_varchar2 ;
76:
77: l_enroll_rec.tdb_information11 := hr_api.g_varchar2 ;
78: l_enroll_rec.tdb_information12 := hr_api.g_varchar2 ;
79: l_enroll_rec.tdb_information13 := hr_api.g_varchar2 ;
80: l_enroll_rec.tdb_information14 := hr_api.g_varchar2 ;
81: l_enroll_rec.tdb_information15 := hr_api.g_varchar2 ;
82: l_enroll_rec.tdb_information16 := hr_api.g_varchar2 ;

Line 79: l_enroll_rec.tdb_information13 := hr_api.g_varchar2 ;

75: l_enroll_rec.tdb_information10 := hr_api.g_varchar2 ;
76:
77: l_enroll_rec.tdb_information11 := hr_api.g_varchar2 ;
78: l_enroll_rec.tdb_information12 := hr_api.g_varchar2 ;
79: l_enroll_rec.tdb_information13 := hr_api.g_varchar2 ;
80: l_enroll_rec.tdb_information14 := hr_api.g_varchar2 ;
81: l_enroll_rec.tdb_information15 := hr_api.g_varchar2 ;
82: l_enroll_rec.tdb_information16 := hr_api.g_varchar2 ;
83: l_enroll_rec.tdb_information17 := hr_api.g_varchar2 ;

Line 80: l_enroll_rec.tdb_information14 := hr_api.g_varchar2 ;

76:
77: l_enroll_rec.tdb_information11 := hr_api.g_varchar2 ;
78: l_enroll_rec.tdb_information12 := hr_api.g_varchar2 ;
79: l_enroll_rec.tdb_information13 := hr_api.g_varchar2 ;
80: l_enroll_rec.tdb_information14 := hr_api.g_varchar2 ;
81: l_enroll_rec.tdb_information15 := hr_api.g_varchar2 ;
82: l_enroll_rec.tdb_information16 := hr_api.g_varchar2 ;
83: l_enroll_rec.tdb_information17 := hr_api.g_varchar2 ;
84: l_enroll_rec.tdb_information18 := hr_api.g_varchar2 ;

Line 81: l_enroll_rec.tdb_information15 := hr_api.g_varchar2 ;

77: l_enroll_rec.tdb_information11 := hr_api.g_varchar2 ;
78: l_enroll_rec.tdb_information12 := hr_api.g_varchar2 ;
79: l_enroll_rec.tdb_information13 := hr_api.g_varchar2 ;
80: l_enroll_rec.tdb_information14 := hr_api.g_varchar2 ;
81: l_enroll_rec.tdb_information15 := hr_api.g_varchar2 ;
82: l_enroll_rec.tdb_information16 := hr_api.g_varchar2 ;
83: l_enroll_rec.tdb_information17 := hr_api.g_varchar2 ;
84: l_enroll_rec.tdb_information18 := hr_api.g_varchar2 ;
85: l_enroll_rec.tdb_information19 := hr_api.g_varchar2 ;

Line 82: l_enroll_rec.tdb_information16 := hr_api.g_varchar2 ;

78: l_enroll_rec.tdb_information12 := hr_api.g_varchar2 ;
79: l_enroll_rec.tdb_information13 := hr_api.g_varchar2 ;
80: l_enroll_rec.tdb_information14 := hr_api.g_varchar2 ;
81: l_enroll_rec.tdb_information15 := hr_api.g_varchar2 ;
82: l_enroll_rec.tdb_information16 := hr_api.g_varchar2 ;
83: l_enroll_rec.tdb_information17 := hr_api.g_varchar2 ;
84: l_enroll_rec.tdb_information18 := hr_api.g_varchar2 ;
85: l_enroll_rec.tdb_information19 := hr_api.g_varchar2 ;
86: l_enroll_rec.tdb_information20 := hr_api.g_varchar2 ;

Line 83: l_enroll_rec.tdb_information17 := hr_api.g_varchar2 ;

79: l_enroll_rec.tdb_information13 := hr_api.g_varchar2 ;
80: l_enroll_rec.tdb_information14 := hr_api.g_varchar2 ;
81: l_enroll_rec.tdb_information15 := hr_api.g_varchar2 ;
82: l_enroll_rec.tdb_information16 := hr_api.g_varchar2 ;
83: l_enroll_rec.tdb_information17 := hr_api.g_varchar2 ;
84: l_enroll_rec.tdb_information18 := hr_api.g_varchar2 ;
85: l_enroll_rec.tdb_information19 := hr_api.g_varchar2 ;
86: l_enroll_rec.tdb_information20 := hr_api.g_varchar2 ;
87: l_enroll_rec.finance_header_id := hr_api.g_number ;

Line 84: l_enroll_rec.tdb_information18 := hr_api.g_varchar2 ;

80: l_enroll_rec.tdb_information14 := hr_api.g_varchar2 ;
81: l_enroll_rec.tdb_information15 := hr_api.g_varchar2 ;
82: l_enroll_rec.tdb_information16 := hr_api.g_varchar2 ;
83: l_enroll_rec.tdb_information17 := hr_api.g_varchar2 ;
84: l_enroll_rec.tdb_information18 := hr_api.g_varchar2 ;
85: l_enroll_rec.tdb_information19 := hr_api.g_varchar2 ;
86: l_enroll_rec.tdb_information20 := hr_api.g_varchar2 ;
87: l_enroll_rec.finance_header_id := hr_api.g_number ;
88:

Line 85: l_enroll_rec.tdb_information19 := hr_api.g_varchar2 ;

81: l_enroll_rec.tdb_information15 := hr_api.g_varchar2 ;
82: l_enroll_rec.tdb_information16 := hr_api.g_varchar2 ;
83: l_enroll_rec.tdb_information17 := hr_api.g_varchar2 ;
84: l_enroll_rec.tdb_information18 := hr_api.g_varchar2 ;
85: l_enroll_rec.tdb_information19 := hr_api.g_varchar2 ;
86: l_enroll_rec.tdb_information20 := hr_api.g_varchar2 ;
87: l_enroll_rec.finance_header_id := hr_api.g_number ;
88:
89: l_enroll_rec.standard_amount := hr_api.g_number ;

Line 86: l_enroll_rec.tdb_information20 := hr_api.g_varchar2 ;

82: l_enroll_rec.tdb_information16 := hr_api.g_varchar2 ;
83: l_enroll_rec.tdb_information17 := hr_api.g_varchar2 ;
84: l_enroll_rec.tdb_information18 := hr_api.g_varchar2 ;
85: l_enroll_rec.tdb_information19 := hr_api.g_varchar2 ;
86: l_enroll_rec.tdb_information20 := hr_api.g_varchar2 ;
87: l_enroll_rec.finance_header_id := hr_api.g_number ;
88:
89: l_enroll_rec.standard_amount := hr_api.g_number ;
90:

Line 87: l_enroll_rec.finance_header_id := hr_api.g_number ;

83: l_enroll_rec.tdb_information17 := hr_api.g_varchar2 ;
84: l_enroll_rec.tdb_information18 := hr_api.g_varchar2 ;
85: l_enroll_rec.tdb_information19 := hr_api.g_varchar2 ;
86: l_enroll_rec.tdb_information20 := hr_api.g_varchar2 ;
87: l_enroll_rec.finance_header_id := hr_api.g_number ;
88:
89: l_enroll_rec.standard_amount := hr_api.g_number ;
90:
91: -- l_enroll_rec.unitary_amount := hr_api.g_number ;

Line 89: l_enroll_rec.standard_amount := hr_api.g_number ;

85: l_enroll_rec.tdb_information19 := hr_api.g_varchar2 ;
86: l_enroll_rec.tdb_information20 := hr_api.g_varchar2 ;
87: l_enroll_rec.finance_header_id := hr_api.g_number ;
88:
89: l_enroll_rec.standard_amount := hr_api.g_number ;
90:
91: -- l_enroll_rec.unitary_amount := hr_api.g_number ;
92:
93: l_enroll_rec.money_amount := hr_api.g_number ;

Line 91: -- l_enroll_rec.unitary_amount := hr_api.g_number ;

87: l_enroll_rec.finance_header_id := hr_api.g_number ;
88:
89: l_enroll_rec.standard_amount := hr_api.g_number ;
90:
91: -- l_enroll_rec.unitary_amount := hr_api.g_number ;
92:
93: l_enroll_rec.money_amount := hr_api.g_number ;
94:
95: l_enroll_rec.currency_code := hr_api.g_varchar2 ;

Line 93: l_enroll_rec.money_amount := hr_api.g_number ;

89: l_enroll_rec.standard_amount := hr_api.g_number ;
90:
91: -- l_enroll_rec.unitary_amount := hr_api.g_number ;
92:
93: l_enroll_rec.money_amount := hr_api.g_number ;
94:
95: l_enroll_rec.currency_code := hr_api.g_varchar2 ;
96:
97: l_enroll_rec.booking_deal_type := hr_api.g_varchar2 ;

Line 95: l_enroll_rec.currency_code := hr_api.g_varchar2 ;

91: -- l_enroll_rec.unitary_amount := hr_api.g_number ;
92:
93: l_enroll_rec.money_amount := hr_api.g_number ;
94:
95: l_enroll_rec.currency_code := hr_api.g_varchar2 ;
96:
97: l_enroll_rec.booking_deal_type := hr_api.g_varchar2 ;
98:
99: l_enroll_rec.booking_deal_id := hr_api.g_number ;

Line 97: l_enroll_rec.booking_deal_type := hr_api.g_varchar2 ;

93: l_enroll_rec.money_amount := hr_api.g_number ;
94:
95: l_enroll_rec.currency_code := hr_api.g_varchar2 ;
96:
97: l_enroll_rec.booking_deal_type := hr_api.g_varchar2 ;
98:
99: l_enroll_rec.booking_deal_id := hr_api.g_number ;
100: Hr_Utility.set_location(' OneThree : ', 5);
101: -- l_enroll_rec.enrollment_type := hr_api.g_varchar2 ;

Line 99: l_enroll_rec.booking_deal_id := hr_api.g_number ;

95: l_enroll_rec.currency_code := hr_api.g_varchar2 ;
96:
97: l_enroll_rec.booking_deal_type := hr_api.g_varchar2 ;
98:
99: l_enroll_rec.booking_deal_id := hr_api.g_number ;
100: Hr_Utility.set_location(' OneThree : ', 5);
101: -- l_enroll_rec.enrollment_type := hr_api.g_varchar2 ;
102: l_enroll_rec.organization_id := hr_api.g_number ;
103: l_enroll_rec.sponsor_person_id := hr_api.g_number ;

Line 101: -- l_enroll_rec.enrollment_type := hr_api.g_varchar2 ;

97: l_enroll_rec.booking_deal_type := hr_api.g_varchar2 ;
98:
99: l_enroll_rec.booking_deal_id := hr_api.g_number ;
100: Hr_Utility.set_location(' OneThree : ', 5);
101: -- l_enroll_rec.enrollment_type := hr_api.g_varchar2 ;
102: l_enroll_rec.organization_id := hr_api.g_number ;
103: l_enroll_rec.sponsor_person_id := hr_api.g_number ;
104: l_enroll_rec.sponsor_assignment_id := hr_api.g_number ;
105: l_enroll_rec.person_address_id := hr_api.g_number ;

Line 102: l_enroll_rec.organization_id := hr_api.g_number ;

98:
99: l_enroll_rec.booking_deal_id := hr_api.g_number ;
100: Hr_Utility.set_location(' OneThree : ', 5);
101: -- l_enroll_rec.enrollment_type := hr_api.g_varchar2 ;
102: l_enroll_rec.organization_id := hr_api.g_number ;
103: l_enroll_rec.sponsor_person_id := hr_api.g_number ;
104: l_enroll_rec.sponsor_assignment_id := hr_api.g_number ;
105: l_enroll_rec.person_address_id := hr_api.g_number ;
106: l_enroll_rec.delegate_assignment_id := hr_api.g_number ;

Line 103: l_enroll_rec.sponsor_person_id := hr_api.g_number ;

99: l_enroll_rec.booking_deal_id := hr_api.g_number ;
100: Hr_Utility.set_location(' OneThree : ', 5);
101: -- l_enroll_rec.enrollment_type := hr_api.g_varchar2 ;
102: l_enroll_rec.organization_id := hr_api.g_number ;
103: l_enroll_rec.sponsor_person_id := hr_api.g_number ;
104: l_enroll_rec.sponsor_assignment_id := hr_api.g_number ;
105: l_enroll_rec.person_address_id := hr_api.g_number ;
106: l_enroll_rec.delegate_assignment_id := hr_api.g_number ;
107: l_enroll_rec.delegate_contact_id := hr_api.g_number ;

Line 104: l_enroll_rec.sponsor_assignment_id := hr_api.g_number ;

100: Hr_Utility.set_location(' OneThree : ', 5);
101: -- l_enroll_rec.enrollment_type := hr_api.g_varchar2 ;
102: l_enroll_rec.organization_id := hr_api.g_number ;
103: l_enroll_rec.sponsor_person_id := hr_api.g_number ;
104: l_enroll_rec.sponsor_assignment_id := hr_api.g_number ;
105: l_enroll_rec.person_address_id := hr_api.g_number ;
106: l_enroll_rec.delegate_assignment_id := hr_api.g_number ;
107: l_enroll_rec.delegate_contact_id := hr_api.g_number ;
108: l_enroll_rec.correspondent_email := hr_api.g_varchar2 ;

Line 105: l_enroll_rec.person_address_id := hr_api.g_number ;

101: -- l_enroll_rec.enrollment_type := hr_api.g_varchar2 ;
102: l_enroll_rec.organization_id := hr_api.g_number ;
103: l_enroll_rec.sponsor_person_id := hr_api.g_number ;
104: l_enroll_rec.sponsor_assignment_id := hr_api.g_number ;
105: l_enroll_rec.person_address_id := hr_api.g_number ;
106: l_enroll_rec.delegate_assignment_id := hr_api.g_number ;
107: l_enroll_rec.delegate_contact_id := hr_api.g_number ;
108: l_enroll_rec.correspondent_email := hr_api.g_varchar2 ;
109: l_enroll_rec.third_party_email := hr_api.g_varchar2 ;

Line 106: l_enroll_rec.delegate_assignment_id := hr_api.g_number ;

102: l_enroll_rec.organization_id := hr_api.g_number ;
103: l_enroll_rec.sponsor_person_id := hr_api.g_number ;
104: l_enroll_rec.sponsor_assignment_id := hr_api.g_number ;
105: l_enroll_rec.person_address_id := hr_api.g_number ;
106: l_enroll_rec.delegate_assignment_id := hr_api.g_number ;
107: l_enroll_rec.delegate_contact_id := hr_api.g_number ;
108: l_enroll_rec.correspondent_email := hr_api.g_varchar2 ;
109: l_enroll_rec.third_party_email := hr_api.g_varchar2 ;
110: l_enroll_rec.correspondent_address_type := hr_api.g_varchar2 ;

Line 107: l_enroll_rec.delegate_contact_id := hr_api.g_number ;

103: l_enroll_rec.sponsor_person_id := hr_api.g_number ;
104: l_enroll_rec.sponsor_assignment_id := hr_api.g_number ;
105: l_enroll_rec.person_address_id := hr_api.g_number ;
106: l_enroll_rec.delegate_assignment_id := hr_api.g_number ;
107: l_enroll_rec.delegate_contact_id := hr_api.g_number ;
108: l_enroll_rec.correspondent_email := hr_api.g_varchar2 ;
109: l_enroll_rec.third_party_email := hr_api.g_varchar2 ;
110: l_enroll_rec.correspondent_address_type := hr_api.g_varchar2 ;
111: l_enroll_rec.line_id := hr_api.g_number ;

Line 108: l_enroll_rec.correspondent_email := hr_api.g_varchar2 ;

104: l_enroll_rec.sponsor_assignment_id := hr_api.g_number ;
105: l_enroll_rec.person_address_id := hr_api.g_number ;
106: l_enroll_rec.delegate_assignment_id := hr_api.g_number ;
107: l_enroll_rec.delegate_contact_id := hr_api.g_number ;
108: l_enroll_rec.correspondent_email := hr_api.g_varchar2 ;
109: l_enroll_rec.third_party_email := hr_api.g_varchar2 ;
110: l_enroll_rec.correspondent_address_type := hr_api.g_varchar2 ;
111: l_enroll_rec.line_id := hr_api.g_number ;
112: Hr_Utility.set_location(' OneFour : ', 5);

Line 109: l_enroll_rec.third_party_email := hr_api.g_varchar2 ;

105: l_enroll_rec.person_address_id := hr_api.g_number ;
106: l_enroll_rec.delegate_assignment_id := hr_api.g_number ;
107: l_enroll_rec.delegate_contact_id := hr_api.g_number ;
108: l_enroll_rec.correspondent_email := hr_api.g_varchar2 ;
109: l_enroll_rec.third_party_email := hr_api.g_varchar2 ;
110: l_enroll_rec.correspondent_address_type := hr_api.g_varchar2 ;
111: l_enroll_rec.line_id := hr_api.g_number ;
112: Hr_Utility.set_location(' OneFour : ', 5);
113: l_enroll_rec.org_id := hr_api.g_number ;

Line 110: l_enroll_rec.correspondent_address_type := hr_api.g_varchar2 ;

106: l_enroll_rec.delegate_assignment_id := hr_api.g_number ;
107: l_enroll_rec.delegate_contact_id := hr_api.g_number ;
108: l_enroll_rec.correspondent_email := hr_api.g_varchar2 ;
109: l_enroll_rec.third_party_email := hr_api.g_varchar2 ;
110: l_enroll_rec.correspondent_address_type := hr_api.g_varchar2 ;
111: l_enroll_rec.line_id := hr_api.g_number ;
112: Hr_Utility.set_location(' OneFour : ', 5);
113: l_enroll_rec.org_id := hr_api.g_number ;
114: Hr_Utility.set_location(' 1 : ', 5);

Line 111: l_enroll_rec.line_id := hr_api.g_number ;

107: l_enroll_rec.delegate_contact_id := hr_api.g_number ;
108: l_enroll_rec.correspondent_email := hr_api.g_varchar2 ;
109: l_enroll_rec.third_party_email := hr_api.g_varchar2 ;
110: l_enroll_rec.correspondent_address_type := hr_api.g_varchar2 ;
111: l_enroll_rec.line_id := hr_api.g_number ;
112: Hr_Utility.set_location(' OneFour : ', 5);
113: l_enroll_rec.org_id := hr_api.g_number ;
114: Hr_Utility.set_location(' 1 : ', 5);
115: -- l_enroll_rec.daemon_flag := hr_api.g_varchar2 ;

Line 113: l_enroll_rec.org_id := hr_api.g_number ;

109: l_enroll_rec.third_party_email := hr_api.g_varchar2 ;
110: l_enroll_rec.correspondent_address_type := hr_api.g_varchar2 ;
111: l_enroll_rec.line_id := hr_api.g_number ;
112: Hr_Utility.set_location(' OneFour : ', 5);
113: l_enroll_rec.org_id := hr_api.g_number ;
114: Hr_Utility.set_location(' 1 : ', 5);
115: -- l_enroll_rec.daemon_flag := hr_api.g_varchar2 ;
116: Hr_Utility.set_location(' 2 : ', 5);
117: -- l_enroll_rec.daemon_type := hr_api.g_varchar2 ;

Line 115: -- l_enroll_rec.daemon_flag := hr_api.g_varchar2 ;

111: l_enroll_rec.line_id := hr_api.g_number ;
112: Hr_Utility.set_location(' OneFour : ', 5);
113: l_enroll_rec.org_id := hr_api.g_number ;
114: Hr_Utility.set_location(' 1 : ', 5);
115: -- l_enroll_rec.daemon_flag := hr_api.g_varchar2 ;
116: Hr_Utility.set_location(' 2 : ', 5);
117: -- l_enroll_rec.daemon_type := hr_api.g_varchar2 ;
118: Hr_Utility.set_location(' 3 : ', 5);
119: l_enroll_rec.old_event_id := hr_api.g_number ;

Line 117: -- l_enroll_rec.daemon_type := hr_api.g_varchar2 ;

113: l_enroll_rec.org_id := hr_api.g_number ;
114: Hr_Utility.set_location(' 1 : ', 5);
115: -- l_enroll_rec.daemon_flag := hr_api.g_varchar2 ;
116: Hr_Utility.set_location(' 2 : ', 5);
117: -- l_enroll_rec.daemon_type := hr_api.g_varchar2 ;
118: Hr_Utility.set_location(' 3 : ', 5);
119: l_enroll_rec.old_event_id := hr_api.g_number ;
120: l_enroll_rec.quote_line_id := hr_api.g_number ;
121: l_enroll_rec.interface_source := hr_api.g_varchar2 ;

Line 119: l_enroll_rec.old_event_id := hr_api.g_number ;

115: -- l_enroll_rec.daemon_flag := hr_api.g_varchar2 ;
116: Hr_Utility.set_location(' 2 : ', 5);
117: -- l_enroll_rec.daemon_type := hr_api.g_varchar2 ;
118: Hr_Utility.set_location(' 3 : ', 5);
119: l_enroll_rec.old_event_id := hr_api.g_number ;
120: l_enroll_rec.quote_line_id := hr_api.g_number ;
121: l_enroll_rec.interface_source := hr_api.g_varchar2 ;
122: Hr_Utility.set_location(' 4 : ', 5);
123: l_enroll_rec.total_training_time := hr_api.g_varchar2 ;

Line 120: l_enroll_rec.quote_line_id := hr_api.g_number ;

116: Hr_Utility.set_location(' 2 : ', 5);
117: -- l_enroll_rec.daemon_type := hr_api.g_varchar2 ;
118: Hr_Utility.set_location(' 3 : ', 5);
119: l_enroll_rec.old_event_id := hr_api.g_number ;
120: l_enroll_rec.quote_line_id := hr_api.g_number ;
121: l_enroll_rec.interface_source := hr_api.g_varchar2 ;
122: Hr_Utility.set_location(' 4 : ', 5);
123: l_enroll_rec.total_training_time := hr_api.g_varchar2 ;
124: Hr_Utility.set_location(' 5 : ', 5);

Line 121: l_enroll_rec.interface_source := hr_api.g_varchar2 ;

117: -- l_enroll_rec.daemon_type := hr_api.g_varchar2 ;
118: Hr_Utility.set_location(' 3 : ', 5);
119: l_enroll_rec.old_event_id := hr_api.g_number ;
120: l_enroll_rec.quote_line_id := hr_api.g_number ;
121: l_enroll_rec.interface_source := hr_api.g_varchar2 ;
122: Hr_Utility.set_location(' 4 : ', 5);
123: l_enroll_rec.total_training_time := hr_api.g_varchar2 ;
124: Hr_Utility.set_location(' 5 : ', 5);
125: l_enroll_rec.content_player_status := hr_api.g_varchar2 ;

Line 123: l_enroll_rec.total_training_time := hr_api.g_varchar2 ;

119: l_enroll_rec.old_event_id := hr_api.g_number ;
120: l_enroll_rec.quote_line_id := hr_api.g_number ;
121: l_enroll_rec.interface_source := hr_api.g_varchar2 ;
122: Hr_Utility.set_location(' 4 : ', 5);
123: l_enroll_rec.total_training_time := hr_api.g_varchar2 ;
124: Hr_Utility.set_location(' 5 : ', 5);
125: l_enroll_rec.content_player_status := hr_api.g_varchar2 ;
126: l_enroll_rec.score := hr_api.g_number ;
127: Hr_Utility.set_location(' OneTwo : ', 5);

Line 125: l_enroll_rec.content_player_status := hr_api.g_varchar2 ;

121: l_enroll_rec.interface_source := hr_api.g_varchar2 ;
122: Hr_Utility.set_location(' 4 : ', 5);
123: l_enroll_rec.total_training_time := hr_api.g_varchar2 ;
124: Hr_Utility.set_location(' 5 : ', 5);
125: l_enroll_rec.content_player_status := hr_api.g_varchar2 ;
126: l_enroll_rec.score := hr_api.g_number ;
127: Hr_Utility.set_location(' OneTwo : ', 5);
128: l_enroll_rec.completed_content := hr_api.g_number ;
129: Hr_Utility.set_location(' OneFive : ', 5);

Line 126: l_enroll_rec.score := hr_api.g_number ;

122: Hr_Utility.set_location(' 4 : ', 5);
123: l_enroll_rec.total_training_time := hr_api.g_varchar2 ;
124: Hr_Utility.set_location(' 5 : ', 5);
125: l_enroll_rec.content_player_status := hr_api.g_varchar2 ;
126: l_enroll_rec.score := hr_api.g_number ;
127: Hr_Utility.set_location(' OneTwo : ', 5);
128: l_enroll_rec.completed_content := hr_api.g_number ;
129: Hr_Utility.set_location(' OneFive : ', 5);
130: l_enroll_rec.total_content := hr_api.g_number ;

Line 128: l_enroll_rec.completed_content := hr_api.g_number ;

124: Hr_Utility.set_location(' 5 : ', 5);
125: l_enroll_rec.content_player_status := hr_api.g_varchar2 ;
126: l_enroll_rec.score := hr_api.g_number ;
127: Hr_Utility.set_location(' OneTwo : ', 5);
128: l_enroll_rec.completed_content := hr_api.g_number ;
129: Hr_Utility.set_location(' OneFive : ', 5);
130: l_enroll_rec.total_content := hr_api.g_number ;
131: l_enroll_rec.booking_justification_id := hr_api.g_number ;
132: -- l_enroll_rec.is_history_flag := hr_api.g_varchar2 ;

Line 130: l_enroll_rec.total_content := hr_api.g_number ;

126: l_enroll_rec.score := hr_api.g_number ;
127: Hr_Utility.set_location(' OneTwo : ', 5);
128: l_enroll_rec.completed_content := hr_api.g_number ;
129: Hr_Utility.set_location(' OneFive : ', 5);
130: l_enroll_rec.total_content := hr_api.g_number ;
131: l_enroll_rec.booking_justification_id := hr_api.g_number ;
132: -- l_enroll_rec.is_history_flag := hr_api.g_varchar2 ;
133:
134:

Line 131: l_enroll_rec.booking_justification_id := hr_api.g_number ;

127: Hr_Utility.set_location(' OneTwo : ', 5);
128: l_enroll_rec.completed_content := hr_api.g_number ;
129: Hr_Utility.set_location(' OneFive : ', 5);
130: l_enroll_rec.total_content := hr_api.g_number ;
131: l_enroll_rec.booking_justification_id := hr_api.g_number ;
132: -- l_enroll_rec.is_history_flag := hr_api.g_varchar2 ;
133:
134:
135: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

Line 132: -- l_enroll_rec.is_history_flag := hr_api.g_varchar2 ;

128: l_enroll_rec.completed_content := hr_api.g_number ;
129: Hr_Utility.set_location(' OneFive : ', 5);
130: l_enroll_rec.total_content := hr_api.g_number ;
131: l_enroll_rec.booking_justification_id := hr_api.g_number ;
132: -- l_enroll_rec.is_history_flag := hr_api.g_varchar2 ;
133:
134:
135: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
136: return l_enroll_rec;

Line 434: ,p_validate in number default hr_api.g_false_num

430: ,p_booking_deal_id in number default null
431: ,p_booking_deal_type in varchar2 default null
432: ,p_finance_line_id in out nocopy number
433: ,p_enrollment_type in varchar2 default null
434: ,p_validate in number default hr_api.g_false_num
435: ,p_organization_id in number default null
436: ,p_sponsor_person_id in number default null
437: ,p_sponsor_assignment_id in number default null
438: ,p_person_address_id in number default null

Line 462: ,p_status_change_comments in varchar2 default hr_api.g_varchar2

458: ,p_is_history_flag in varchar2 default 'N'
459: ,p_override_prerequisites in varchar2 default null
460: ,p_override_learner_access in varchar2 default null
461: ,P_CRT_UPD in varchar2 default null
462: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
463: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
464: ,p_tfl_object_version_number in number default null
465: ) is
466:

Line 463: ,p_update_finance_line in varchar2 default hr_api.g_varchar2

459: ,p_override_prerequisites in varchar2 default null
460: ,p_override_learner_access in varchar2 default null
461: ,P_CRT_UPD in varchar2 default null
462: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
463: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
464: ,p_tfl_object_version_number in number default null
465: ) is
466:
467: --

Line 483: -- p_status_change_comments varchar2(30) default hr_api.g_varchar2;

479: l_create_flag number;
480: l_error_msg varchar2(4000);
481: m_validate number :=0; -- No validation
482:
483: -- p_status_change_comments varchar2(30) default hr_api.g_varchar2;
484: -- p_update_finance_line varchar2(30) default hr_api.g_varchar2;
485: l_tfl_object_version_number number;
486: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
487: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

Line 484: -- p_update_finance_line varchar2(30) default hr_api.g_varchar2;

480: l_error_msg varchar2(4000);
481: m_validate number :=0; -- No validation
482:
483: -- p_status_change_comments varchar2(30) default hr_api.g_varchar2;
484: -- p_update_finance_line varchar2(30) default hr_api.g_varchar2;
485: l_tfl_object_version_number number;
486: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
487: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
488: c_delegate_assignment_id number default null;

Line 1030: ,p_validate in number default hr_api.g_false_num

1026: ,p_booking_deal_id in number default null
1027: ,p_booking_deal_type in varchar2 default null
1028: ,p_finance_line_id in out nocopy number
1029: ,p_enrollment_type in varchar2 default null
1030: ,p_validate in number default hr_api.g_false_num
1031: ,p_organization_id in number default null
1032: ,p_sponsor_person_id in number default null
1033: ,p_sponsor_assignment_id in number default null
1034: ,p_person_address_id in number default null

Line 1086: hr_api.constant_to_boolean

1082: --
1083: -- Convert constant values to their corresponding boolean value
1084: --
1085: l_validate :=
1086: hr_api.constant_to_boolean
1087: (p_constant_value => p_validate);
1088: --
1089: -- Register Surrogate ID or user key values
1090: --

Line 1244: ,p_booking_status_type_id in number default hr_api.g_number

1240:
1241: PROCEDURE update_delegate_booking
1242: (p_effective_date in date default null
1243: ,p_booking_id in number
1244: ,p_booking_status_type_id in number default hr_api.g_number
1245: ,p_delegate_person_id in number default hr_api.g_number
1246: ,p_contact_id in number default hr_api.g_number
1247: ,p_business_group_id in number default hr_api.g_number
1248: ,p_event_id in number default hr_api.g_number

Line 1245: ,p_delegate_person_id in number default hr_api.g_number

1241: PROCEDURE update_delegate_booking
1242: (p_effective_date in date default null
1243: ,p_booking_id in number
1244: ,p_booking_status_type_id in number default hr_api.g_number
1245: ,p_delegate_person_id in number default hr_api.g_number
1246: ,p_contact_id in number default hr_api.g_number
1247: ,p_business_group_id in number default hr_api.g_number
1248: ,p_event_id in number default hr_api.g_number
1249: ,p_customer_id in number default hr_api.g_number

Line 1246: ,p_contact_id in number default hr_api.g_number

1242: (p_effective_date in date default null
1243: ,p_booking_id in number
1244: ,p_booking_status_type_id in number default hr_api.g_number
1245: ,p_delegate_person_id in number default hr_api.g_number
1246: ,p_contact_id in number default hr_api.g_number
1247: ,p_business_group_id in number default hr_api.g_number
1248: ,p_event_id in number default hr_api.g_number
1249: ,p_customer_id in number default hr_api.g_number
1250: ,p_authorizer_person_id in number default hr_api.g_number

Line 1247: ,p_business_group_id in number default hr_api.g_number

1243: ,p_booking_id in number
1244: ,p_booking_status_type_id in number default hr_api.g_number
1245: ,p_delegate_person_id in number default hr_api.g_number
1246: ,p_contact_id in number default hr_api.g_number
1247: ,p_business_group_id in number default hr_api.g_number
1248: ,p_event_id in number default hr_api.g_number
1249: ,p_customer_id in number default hr_api.g_number
1250: ,p_authorizer_person_id in number default hr_api.g_number
1251: ,p_date_booking_placed in date default hr_api.g_date

Line 1248: ,p_event_id in number default hr_api.g_number

1244: ,p_booking_status_type_id in number default hr_api.g_number
1245: ,p_delegate_person_id in number default hr_api.g_number
1246: ,p_contact_id in number default hr_api.g_number
1247: ,p_business_group_id in number default hr_api.g_number
1248: ,p_event_id in number default hr_api.g_number
1249: ,p_customer_id in number default hr_api.g_number
1250: ,p_authorizer_person_id in number default hr_api.g_number
1251: ,p_date_booking_placed in date default hr_api.g_date
1252: ,p_corespondent in varchar2 default hr_api.g_varchar2

Line 1249: ,p_customer_id in number default hr_api.g_number

1245: ,p_delegate_person_id in number default hr_api.g_number
1246: ,p_contact_id in number default hr_api.g_number
1247: ,p_business_group_id in number default hr_api.g_number
1248: ,p_event_id in number default hr_api.g_number
1249: ,p_customer_id in number default hr_api.g_number
1250: ,p_authorizer_person_id in number default hr_api.g_number
1251: ,p_date_booking_placed in date default hr_api.g_date
1252: ,p_corespondent in varchar2 default hr_api.g_varchar2
1253: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2

Line 1250: ,p_authorizer_person_id in number default hr_api.g_number

1246: ,p_contact_id in number default hr_api.g_number
1247: ,p_business_group_id in number default hr_api.g_number
1248: ,p_event_id in number default hr_api.g_number
1249: ,p_customer_id in number default hr_api.g_number
1250: ,p_authorizer_person_id in number default hr_api.g_number
1251: ,p_date_booking_placed in date default hr_api.g_date
1252: ,p_corespondent in varchar2 default hr_api.g_varchar2
1253: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
1254: ,p_number_of_places in number default hr_api.g_number

Line 1251: ,p_date_booking_placed in date default hr_api.g_date

1247: ,p_business_group_id in number default hr_api.g_number
1248: ,p_event_id in number default hr_api.g_number
1249: ,p_customer_id in number default hr_api.g_number
1250: ,p_authorizer_person_id in number default hr_api.g_number
1251: ,p_date_booking_placed in date default hr_api.g_date
1252: ,p_corespondent in varchar2 default hr_api.g_varchar2
1253: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
1254: ,p_number_of_places in number default hr_api.g_number
1255: ,p_object_version_number in out nocopy number

Line 1252: ,p_corespondent in varchar2 default hr_api.g_varchar2

1248: ,p_event_id in number default hr_api.g_number
1249: ,p_customer_id in number default hr_api.g_number
1250: ,p_authorizer_person_id in number default hr_api.g_number
1251: ,p_date_booking_placed in date default hr_api.g_date
1252: ,p_corespondent in varchar2 default hr_api.g_varchar2
1253: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
1254: ,p_number_of_places in number default hr_api.g_number
1255: ,p_object_version_number in out nocopy number
1256: ,p_administrator in number default hr_api.g_number

Line 1253: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2

1249: ,p_customer_id in number default hr_api.g_number
1250: ,p_authorizer_person_id in number default hr_api.g_number
1251: ,p_date_booking_placed in date default hr_api.g_date
1252: ,p_corespondent in varchar2 default hr_api.g_varchar2
1253: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
1254: ,p_number_of_places in number default hr_api.g_number
1255: ,p_object_version_number in out nocopy number
1256: ,p_administrator in number default hr_api.g_number
1257: ,p_booking_priority in varchar2 default hr_api.g_varchar2

Line 1254: ,p_number_of_places in number default hr_api.g_number

1250: ,p_authorizer_person_id in number default hr_api.g_number
1251: ,p_date_booking_placed in date default hr_api.g_date
1252: ,p_corespondent in varchar2 default hr_api.g_varchar2
1253: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
1254: ,p_number_of_places in number default hr_api.g_number
1255: ,p_object_version_number in out nocopy number
1256: ,p_administrator in number default hr_api.g_number
1257: ,p_booking_priority in varchar2 default hr_api.g_varchar2
1258: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1256: ,p_administrator in number default hr_api.g_number

1252: ,p_corespondent in varchar2 default hr_api.g_varchar2
1253: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
1254: ,p_number_of_places in number default hr_api.g_number
1255: ,p_object_version_number in out nocopy number
1256: ,p_administrator in number default hr_api.g_number
1257: ,p_booking_priority in varchar2 default hr_api.g_varchar2
1258: ,p_comments in varchar2 default hr_api.g_varchar2
1259: ,p_contact_address_id in number default hr_api.g_number
1260: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2

Line 1257: ,p_booking_priority in varchar2 default hr_api.g_varchar2

1253: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
1254: ,p_number_of_places in number default hr_api.g_number
1255: ,p_object_version_number in out nocopy number
1256: ,p_administrator in number default hr_api.g_number
1257: ,p_booking_priority in varchar2 default hr_api.g_varchar2
1258: ,p_comments in varchar2 default hr_api.g_varchar2
1259: ,p_contact_address_id in number default hr_api.g_number
1260: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
1261: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2

Line 1258: ,p_comments in varchar2 default hr_api.g_varchar2

1254: ,p_number_of_places in number default hr_api.g_number
1255: ,p_object_version_number in out nocopy number
1256: ,p_administrator in number default hr_api.g_number
1257: ,p_booking_priority in varchar2 default hr_api.g_varchar2
1258: ,p_comments in varchar2 default hr_api.g_varchar2
1259: ,p_contact_address_id in number default hr_api.g_number
1260: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
1261: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
1262: ,p_third_party_customer_id in number default hr_api.g_number

Line 1259: ,p_contact_address_id in number default hr_api.g_number

1255: ,p_object_version_number in out nocopy number
1256: ,p_administrator in number default hr_api.g_number
1257: ,p_booking_priority in varchar2 default hr_api.g_varchar2
1258: ,p_comments in varchar2 default hr_api.g_varchar2
1259: ,p_contact_address_id in number default hr_api.g_number
1260: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
1261: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
1262: ,p_third_party_customer_id in number default hr_api.g_number
1263: ,p_third_party_contact_id in number default hr_api.g_number

Line 1260: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2

1256: ,p_administrator in number default hr_api.g_number
1257: ,p_booking_priority in varchar2 default hr_api.g_varchar2
1258: ,p_comments in varchar2 default hr_api.g_varchar2
1259: ,p_contact_address_id in number default hr_api.g_number
1260: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
1261: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
1262: ,p_third_party_customer_id in number default hr_api.g_number
1263: ,p_third_party_contact_id in number default hr_api.g_number
1264: ,p_third_party_address_id in number default hr_api.g_number

Line 1261: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2

1257: ,p_booking_priority in varchar2 default hr_api.g_varchar2
1258: ,p_comments in varchar2 default hr_api.g_varchar2
1259: ,p_contact_address_id in number default hr_api.g_number
1260: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
1261: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
1262: ,p_third_party_customer_id in number default hr_api.g_number
1263: ,p_third_party_contact_id in number default hr_api.g_number
1264: ,p_third_party_address_id in number default hr_api.g_number
1265: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2

Line 1262: ,p_third_party_customer_id in number default hr_api.g_number

1258: ,p_comments in varchar2 default hr_api.g_varchar2
1259: ,p_contact_address_id in number default hr_api.g_number
1260: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
1261: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
1262: ,p_third_party_customer_id in number default hr_api.g_number
1263: ,p_third_party_contact_id in number default hr_api.g_number
1264: ,p_third_party_address_id in number default hr_api.g_number
1265: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
1266: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2

Line 1263: ,p_third_party_contact_id in number default hr_api.g_number

1259: ,p_contact_address_id in number default hr_api.g_number
1260: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
1261: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
1262: ,p_third_party_customer_id in number default hr_api.g_number
1263: ,p_third_party_contact_id in number default hr_api.g_number
1264: ,p_third_party_address_id in number default hr_api.g_number
1265: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
1266: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
1267: ,p_date_status_changed in date default hr_api.g_date

Line 1264: ,p_third_party_address_id in number default hr_api.g_number

1260: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
1261: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
1262: ,p_third_party_customer_id in number default hr_api.g_number
1263: ,p_third_party_contact_id in number default hr_api.g_number
1264: ,p_third_party_address_id in number default hr_api.g_number
1265: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
1266: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
1267: ,p_date_status_changed in date default hr_api.g_date
1268: ,p_status_change_comments in varchar2 default hr_api.g_varchar2

Line 1265: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2

1261: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
1262: ,p_third_party_customer_id in number default hr_api.g_number
1263: ,p_third_party_contact_id in number default hr_api.g_number
1264: ,p_third_party_address_id in number default hr_api.g_number
1265: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
1266: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
1267: ,p_date_status_changed in date default hr_api.g_date
1268: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
1269: ,p_failure_reason in varchar2 default hr_api.g_varchar2

Line 1266: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2

1262: ,p_third_party_customer_id in number default hr_api.g_number
1263: ,p_third_party_contact_id in number default hr_api.g_number
1264: ,p_third_party_address_id in number default hr_api.g_number
1265: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
1266: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
1267: ,p_date_status_changed in date default hr_api.g_date
1268: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
1269: ,p_failure_reason in varchar2 default hr_api.g_varchar2
1270: ,p_attendance_result in varchar2 default hr_api.g_varchar2

Line 1267: ,p_date_status_changed in date default hr_api.g_date

1263: ,p_third_party_contact_id in number default hr_api.g_number
1264: ,p_third_party_address_id in number default hr_api.g_number
1265: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
1266: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
1267: ,p_date_status_changed in date default hr_api.g_date
1268: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
1269: ,p_failure_reason in varchar2 default hr_api.g_varchar2
1270: ,p_attendance_result in varchar2 default hr_api.g_varchar2
1271: ,p_language_id in number default hr_api.g_number

Line 1268: ,p_status_change_comments in varchar2 default hr_api.g_varchar2

1264: ,p_third_party_address_id in number default hr_api.g_number
1265: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
1266: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
1267: ,p_date_status_changed in date default hr_api.g_date
1268: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
1269: ,p_failure_reason in varchar2 default hr_api.g_varchar2
1270: ,p_attendance_result in varchar2 default hr_api.g_varchar2
1271: ,p_language_id in number default hr_api.g_number
1272: ,p_source_of_booking in varchar2 default hr_api.g_varchar2

Line 1269: ,p_failure_reason in varchar2 default hr_api.g_varchar2

1265: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
1266: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
1267: ,p_date_status_changed in date default hr_api.g_date
1268: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
1269: ,p_failure_reason in varchar2 default hr_api.g_varchar2
1270: ,p_attendance_result in varchar2 default hr_api.g_varchar2
1271: ,p_language_id in number default hr_api.g_number
1272: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
1273: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2

Line 1270: ,p_attendance_result in varchar2 default hr_api.g_varchar2

1266: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
1267: ,p_date_status_changed in date default hr_api.g_date
1268: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
1269: ,p_failure_reason in varchar2 default hr_api.g_varchar2
1270: ,p_attendance_result in varchar2 default hr_api.g_varchar2
1271: ,p_language_id in number default hr_api.g_number
1272: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
1273: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
1274: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2

Line 1271: ,p_language_id in number default hr_api.g_number

1267: ,p_date_status_changed in date default hr_api.g_date
1268: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
1269: ,p_failure_reason in varchar2 default hr_api.g_varchar2
1270: ,p_attendance_result in varchar2 default hr_api.g_varchar2
1271: ,p_language_id in number default hr_api.g_number
1272: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
1273: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
1274: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
1275: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2

Line 1272: ,p_source_of_booking in varchar2 default hr_api.g_varchar2

1268: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
1269: ,p_failure_reason in varchar2 default hr_api.g_varchar2
1270: ,p_attendance_result in varchar2 default hr_api.g_varchar2
1271: ,p_language_id in number default hr_api.g_number
1272: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
1273: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
1274: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
1275: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
1276: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2

Line 1273: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2

1269: ,p_failure_reason in varchar2 default hr_api.g_varchar2
1270: ,p_attendance_result in varchar2 default hr_api.g_varchar2
1271: ,p_language_id in number default hr_api.g_number
1272: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
1273: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
1274: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
1275: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
1276: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
1277: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2

Line 1274: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2

1270: ,p_attendance_result in varchar2 default hr_api.g_varchar2
1271: ,p_language_id in number default hr_api.g_number
1272: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
1273: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
1274: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
1275: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
1276: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
1277: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
1278: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2

Line 1275: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2

1271: ,p_language_id in number default hr_api.g_number
1272: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
1273: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
1274: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
1275: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
1276: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
1277: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
1278: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
1279: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2

Line 1276: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2

1272: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
1273: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
1274: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
1275: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
1276: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
1277: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
1278: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
1279: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
1280: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2

Line 1277: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2

1273: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
1274: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
1275: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
1276: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
1277: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
1278: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
1279: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
1280: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
1281: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2

Line 1278: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2

1274: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
1275: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
1276: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
1277: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
1278: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
1279: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
1280: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
1281: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
1282: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2

Line 1279: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2

1275: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
1276: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
1277: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
1278: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
1279: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
1280: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
1281: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
1282: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
1283: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2

Line 1280: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2

1276: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
1277: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
1278: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
1279: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
1280: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
1281: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
1282: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
1283: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
1284: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2

Line 1281: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2

1277: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
1278: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
1279: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
1280: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
1281: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
1282: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
1283: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
1284: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
1285: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2

Line 1282: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2

1278: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
1279: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
1280: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
1281: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
1282: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
1283: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
1284: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
1285: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
1286: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2

Line 1283: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2

1279: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
1280: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
1281: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
1282: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
1283: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
1284: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
1285: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
1286: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
1287: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2

Line 1284: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2

1280: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
1281: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
1282: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
1283: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
1284: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
1285: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
1286: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
1287: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
1288: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2

Line 1285: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2

1281: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
1282: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
1283: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
1284: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
1285: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
1286: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
1287: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
1288: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
1289: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2

Line 1286: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2

1282: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
1283: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
1284: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
1285: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
1286: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
1287: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
1288: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
1289: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
1290: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2

Line 1287: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2

1283: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
1284: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
1285: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
1286: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
1287: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
1288: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
1289: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
1290: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
1291: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2

Line 1288: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2

1284: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
1285: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
1286: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
1287: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
1288: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
1289: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
1290: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
1291: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
1292: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2

Line 1289: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2

1285: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
1286: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
1287: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
1288: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
1289: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
1290: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
1291: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
1292: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
1293: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2

Line 1290: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2

1286: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
1287: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
1288: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
1289: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
1290: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
1291: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
1292: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
1293: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
1294: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2

Line 1291: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2

1287: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
1288: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
1289: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
1290: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
1291: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
1292: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
1293: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
1294: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
1295: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2

Line 1292: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2

1288: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
1289: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
1290: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
1291: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
1292: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
1293: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
1294: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
1295: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
1296: ,p_update_finance_line in varchar2 default hr_api.g_varchar2

Line 1293: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2

1289: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
1290: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
1291: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
1292: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
1293: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
1294: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
1295: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
1296: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
1297: ,p_tfl_object_version_number in out nocopy number

Line 1294: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2

1290: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
1291: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
1292: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
1293: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
1294: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
1295: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
1296: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
1297: ,p_tfl_object_version_number in out nocopy number
1298: ,p_finance_header_id in number default hr_api.g_number

Line 1295: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2

1291: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
1292: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
1293: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
1294: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
1295: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
1296: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
1297: ,p_tfl_object_version_number in out nocopy number
1298: ,p_finance_header_id in number default hr_api.g_number
1299: ,p_finance_line_id in out nocopy number

Line 1296: ,p_update_finance_line in varchar2 default hr_api.g_varchar2

1292: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
1293: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
1294: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
1295: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
1296: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
1297: ,p_tfl_object_version_number in out nocopy number
1298: ,p_finance_header_id in number default hr_api.g_number
1299: ,p_finance_line_id in out nocopy number
1300: ,p_standard_amount in number default hr_api.g_number

Line 1298: ,p_finance_header_id in number default hr_api.g_number

1294: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
1295: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
1296: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
1297: ,p_tfl_object_version_number in out nocopy number
1298: ,p_finance_header_id in number default hr_api.g_number
1299: ,p_finance_line_id in out nocopy number
1300: ,p_standard_amount in number default hr_api.g_number
1301: ,p_unitary_amount in number default hr_api.g_number
1302: ,p_money_amount in number default hr_api.g_number

Line 1300: ,p_standard_amount in number default hr_api.g_number

1296: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
1297: ,p_tfl_object_version_number in out nocopy number
1298: ,p_finance_header_id in number default hr_api.g_number
1299: ,p_finance_line_id in out nocopy number
1300: ,p_standard_amount in number default hr_api.g_number
1301: ,p_unitary_amount in number default hr_api.g_number
1302: ,p_money_amount in number default hr_api.g_number
1303: ,p_currency_code in varchar2 default hr_api.g_varchar2
1304: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2

Line 1301: ,p_unitary_amount in number default hr_api.g_number

1297: ,p_tfl_object_version_number in out nocopy number
1298: ,p_finance_header_id in number default hr_api.g_number
1299: ,p_finance_line_id in out nocopy number
1300: ,p_standard_amount in number default hr_api.g_number
1301: ,p_unitary_amount in number default hr_api.g_number
1302: ,p_money_amount in number default hr_api.g_number
1303: ,p_currency_code in varchar2 default hr_api.g_varchar2
1304: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
1305: ,p_booking_deal_id in number default hr_api.g_number

Line 1302: ,p_money_amount in number default hr_api.g_number

1298: ,p_finance_header_id in number default hr_api.g_number
1299: ,p_finance_line_id in out nocopy number
1300: ,p_standard_amount in number default hr_api.g_number
1301: ,p_unitary_amount in number default hr_api.g_number
1302: ,p_money_amount in number default hr_api.g_number
1303: ,p_currency_code in varchar2 default hr_api.g_varchar2
1304: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
1305: ,p_booking_deal_id in number default hr_api.g_number
1306: ,p_enrollment_type in varchar2 default hr_api.g_varchar2

Line 1303: ,p_currency_code in varchar2 default hr_api.g_varchar2

1299: ,p_finance_line_id in out nocopy number
1300: ,p_standard_amount in number default hr_api.g_number
1301: ,p_unitary_amount in number default hr_api.g_number
1302: ,p_money_amount in number default hr_api.g_number
1303: ,p_currency_code in varchar2 default hr_api.g_varchar2
1304: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
1305: ,p_booking_deal_id in number default hr_api.g_number
1306: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
1307: ,p_validate in number default hr_api.g_false_num

Line 1304: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2

1300: ,p_standard_amount in number default hr_api.g_number
1301: ,p_unitary_amount in number default hr_api.g_number
1302: ,p_money_amount in number default hr_api.g_number
1303: ,p_currency_code in varchar2 default hr_api.g_varchar2
1304: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
1305: ,p_booking_deal_id in number default hr_api.g_number
1306: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
1307: ,p_validate in number default hr_api.g_false_num
1308: ,p_organization_id in number default hr_api.g_number

Line 1305: ,p_booking_deal_id in number default hr_api.g_number

1301: ,p_unitary_amount in number default hr_api.g_number
1302: ,p_money_amount in number default hr_api.g_number
1303: ,p_currency_code in varchar2 default hr_api.g_varchar2
1304: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
1305: ,p_booking_deal_id in number default hr_api.g_number
1306: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
1307: ,p_validate in number default hr_api.g_false_num
1308: ,p_organization_id in number default hr_api.g_number
1309: ,p_sponsor_person_id in number default hr_api.g_number

Line 1306: ,p_enrollment_type in varchar2 default hr_api.g_varchar2

1302: ,p_money_amount in number default hr_api.g_number
1303: ,p_currency_code in varchar2 default hr_api.g_varchar2
1304: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
1305: ,p_booking_deal_id in number default hr_api.g_number
1306: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
1307: ,p_validate in number default hr_api.g_false_num
1308: ,p_organization_id in number default hr_api.g_number
1309: ,p_sponsor_person_id in number default hr_api.g_number
1310: ,p_sponsor_assignment_id in number default hr_api.g_number

Line 1307: ,p_validate in number default hr_api.g_false_num

1303: ,p_currency_code in varchar2 default hr_api.g_varchar2
1304: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
1305: ,p_booking_deal_id in number default hr_api.g_number
1306: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
1307: ,p_validate in number default hr_api.g_false_num
1308: ,p_organization_id in number default hr_api.g_number
1309: ,p_sponsor_person_id in number default hr_api.g_number
1310: ,p_sponsor_assignment_id in number default hr_api.g_number
1311: ,p_person_address_id in number default hr_api.g_number

Line 1308: ,p_organization_id in number default hr_api.g_number

1304: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
1305: ,p_booking_deal_id in number default hr_api.g_number
1306: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
1307: ,p_validate in number default hr_api.g_false_num
1308: ,p_organization_id in number default hr_api.g_number
1309: ,p_sponsor_person_id in number default hr_api.g_number
1310: ,p_sponsor_assignment_id in number default hr_api.g_number
1311: ,p_person_address_id in number default hr_api.g_number
1312: ,p_delegate_assignment_id in number default hr_api.g_number

Line 1309: ,p_sponsor_person_id in number default hr_api.g_number

1305: ,p_booking_deal_id in number default hr_api.g_number
1306: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
1307: ,p_validate in number default hr_api.g_false_num
1308: ,p_organization_id in number default hr_api.g_number
1309: ,p_sponsor_person_id in number default hr_api.g_number
1310: ,p_sponsor_assignment_id in number default hr_api.g_number
1311: ,p_person_address_id in number default hr_api.g_number
1312: ,p_delegate_assignment_id in number default hr_api.g_number
1313: ,p_delegate_contact_id in number default hr_api.g_number

Line 1310: ,p_sponsor_assignment_id in number default hr_api.g_number

1306: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
1307: ,p_validate in number default hr_api.g_false_num
1308: ,p_organization_id in number default hr_api.g_number
1309: ,p_sponsor_person_id in number default hr_api.g_number
1310: ,p_sponsor_assignment_id in number default hr_api.g_number
1311: ,p_person_address_id in number default hr_api.g_number
1312: ,p_delegate_assignment_id in number default hr_api.g_number
1313: ,p_delegate_contact_id in number default hr_api.g_number
1314: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2

Line 1311: ,p_person_address_id in number default hr_api.g_number

1307: ,p_validate in number default hr_api.g_false_num
1308: ,p_organization_id in number default hr_api.g_number
1309: ,p_sponsor_person_id in number default hr_api.g_number
1310: ,p_sponsor_assignment_id in number default hr_api.g_number
1311: ,p_person_address_id in number default hr_api.g_number
1312: ,p_delegate_assignment_id in number default hr_api.g_number
1313: ,p_delegate_contact_id in number default hr_api.g_number
1314: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
1315: ,p_third_party_email in varchar2 default hr_api.g_varchar2

Line 1312: ,p_delegate_assignment_id in number default hr_api.g_number

1308: ,p_organization_id in number default hr_api.g_number
1309: ,p_sponsor_person_id in number default hr_api.g_number
1310: ,p_sponsor_assignment_id in number default hr_api.g_number
1311: ,p_person_address_id in number default hr_api.g_number
1312: ,p_delegate_assignment_id in number default hr_api.g_number
1313: ,p_delegate_contact_id in number default hr_api.g_number
1314: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
1315: ,p_third_party_email in varchar2 default hr_api.g_varchar2
1316: ,p_person_address_type in varchar2 default hr_api.g_varchar2

Line 1313: ,p_delegate_contact_id in number default hr_api.g_number

1309: ,p_sponsor_person_id in number default hr_api.g_number
1310: ,p_sponsor_assignment_id in number default hr_api.g_number
1311: ,p_person_address_id in number default hr_api.g_number
1312: ,p_delegate_assignment_id in number default hr_api.g_number
1313: ,p_delegate_contact_id in number default hr_api.g_number
1314: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
1315: ,p_third_party_email in varchar2 default hr_api.g_varchar2
1316: ,p_person_address_type in varchar2 default hr_api.g_varchar2
1317: ,p_line_id in number default hr_api.g_number

Line 1314: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2

1310: ,p_sponsor_assignment_id in number default hr_api.g_number
1311: ,p_person_address_id in number default hr_api.g_number
1312: ,p_delegate_assignment_id in number default hr_api.g_number
1313: ,p_delegate_contact_id in number default hr_api.g_number
1314: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
1315: ,p_third_party_email in varchar2 default hr_api.g_varchar2
1316: ,p_person_address_type in varchar2 default hr_api.g_varchar2
1317: ,p_line_id in number default hr_api.g_number
1318: ,p_org_id in number default hr_api.g_number

Line 1315: ,p_third_party_email in varchar2 default hr_api.g_varchar2

1311: ,p_person_address_id in number default hr_api.g_number
1312: ,p_delegate_assignment_id in number default hr_api.g_number
1313: ,p_delegate_contact_id in number default hr_api.g_number
1314: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
1315: ,p_third_party_email in varchar2 default hr_api.g_varchar2
1316: ,p_person_address_type in varchar2 default hr_api.g_varchar2
1317: ,p_line_id in number default hr_api.g_number
1318: ,p_org_id in number default hr_api.g_number
1319: ,p_daemon_flag in varchar2 default hr_api.g_varchar2

Line 1316: ,p_person_address_type in varchar2 default hr_api.g_varchar2

1312: ,p_delegate_assignment_id in number default hr_api.g_number
1313: ,p_delegate_contact_id in number default hr_api.g_number
1314: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
1315: ,p_third_party_email in varchar2 default hr_api.g_varchar2
1316: ,p_person_address_type in varchar2 default hr_api.g_varchar2
1317: ,p_line_id in number default hr_api.g_number
1318: ,p_org_id in number default hr_api.g_number
1319: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
1320: ,p_daemon_type in varchar2 default hr_api.g_varchar2

Line 1317: ,p_line_id in number default hr_api.g_number

1313: ,p_delegate_contact_id in number default hr_api.g_number
1314: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
1315: ,p_third_party_email in varchar2 default hr_api.g_varchar2
1316: ,p_person_address_type in varchar2 default hr_api.g_varchar2
1317: ,p_line_id in number default hr_api.g_number
1318: ,p_org_id in number default hr_api.g_number
1319: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
1320: ,p_daemon_type in varchar2 default hr_api.g_varchar2
1321: ,p_old_event_id in number default hr_api.g_number

Line 1318: ,p_org_id in number default hr_api.g_number

1314: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
1315: ,p_third_party_email in varchar2 default hr_api.g_varchar2
1316: ,p_person_address_type in varchar2 default hr_api.g_varchar2
1317: ,p_line_id in number default hr_api.g_number
1318: ,p_org_id in number default hr_api.g_number
1319: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
1320: ,p_daemon_type in varchar2 default hr_api.g_varchar2
1321: ,p_old_event_id in number default hr_api.g_number
1322: ,p_quote_line_id in number default hr_api.g_number

Line 1319: ,p_daemon_flag in varchar2 default hr_api.g_varchar2

1315: ,p_third_party_email in varchar2 default hr_api.g_varchar2
1316: ,p_person_address_type in varchar2 default hr_api.g_varchar2
1317: ,p_line_id in number default hr_api.g_number
1318: ,p_org_id in number default hr_api.g_number
1319: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
1320: ,p_daemon_type in varchar2 default hr_api.g_varchar2
1321: ,p_old_event_id in number default hr_api.g_number
1322: ,p_quote_line_id in number default hr_api.g_number
1323: ,p_interface_source in varchar2 default hr_api.g_varchar2

Line 1320: ,p_daemon_type in varchar2 default hr_api.g_varchar2

1316: ,p_person_address_type in varchar2 default hr_api.g_varchar2
1317: ,p_line_id in number default hr_api.g_number
1318: ,p_org_id in number default hr_api.g_number
1319: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
1320: ,p_daemon_type in varchar2 default hr_api.g_varchar2
1321: ,p_old_event_id in number default hr_api.g_number
1322: ,p_quote_line_id in number default hr_api.g_number
1323: ,p_interface_source in varchar2 default hr_api.g_varchar2
1324: ,p_total_training_time in varchar2 default hr_api.g_varchar2

Line 1321: ,p_old_event_id in number default hr_api.g_number

1317: ,p_line_id in number default hr_api.g_number
1318: ,p_org_id in number default hr_api.g_number
1319: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
1320: ,p_daemon_type in varchar2 default hr_api.g_varchar2
1321: ,p_old_event_id in number default hr_api.g_number
1322: ,p_quote_line_id in number default hr_api.g_number
1323: ,p_interface_source in varchar2 default hr_api.g_varchar2
1324: ,p_total_training_time in varchar2 default hr_api.g_varchar2
1325: ,p_content_player_status in varchar2 default hr_api.g_varchar2

Line 1322: ,p_quote_line_id in number default hr_api.g_number

1318: ,p_org_id in number default hr_api.g_number
1319: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
1320: ,p_daemon_type in varchar2 default hr_api.g_varchar2
1321: ,p_old_event_id in number default hr_api.g_number
1322: ,p_quote_line_id in number default hr_api.g_number
1323: ,p_interface_source in varchar2 default hr_api.g_varchar2
1324: ,p_total_training_time in varchar2 default hr_api.g_varchar2
1325: ,p_content_player_status in varchar2 default hr_api.g_varchar2
1326: ,p_score in number default hr_api.g_number

Line 1323: ,p_interface_source in varchar2 default hr_api.g_varchar2

1319: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
1320: ,p_daemon_type in varchar2 default hr_api.g_varchar2
1321: ,p_old_event_id in number default hr_api.g_number
1322: ,p_quote_line_id in number default hr_api.g_number
1323: ,p_interface_source in varchar2 default hr_api.g_varchar2
1324: ,p_total_training_time in varchar2 default hr_api.g_varchar2
1325: ,p_content_player_status in varchar2 default hr_api.g_varchar2
1326: ,p_score in number default hr_api.g_number
1327: ,p_completed_content in number default hr_api.g_number

Line 1324: ,p_total_training_time in varchar2 default hr_api.g_varchar2

1320: ,p_daemon_type in varchar2 default hr_api.g_varchar2
1321: ,p_old_event_id in number default hr_api.g_number
1322: ,p_quote_line_id in number default hr_api.g_number
1323: ,p_interface_source in varchar2 default hr_api.g_varchar2
1324: ,p_total_training_time in varchar2 default hr_api.g_varchar2
1325: ,p_content_player_status in varchar2 default hr_api.g_varchar2
1326: ,p_score in number default hr_api.g_number
1327: ,p_completed_content in number default hr_api.g_number
1328: ,p_total_content in number default hr_api.g_number

Line 1325: ,p_content_player_status in varchar2 default hr_api.g_varchar2

1321: ,p_old_event_id in number default hr_api.g_number
1322: ,p_quote_line_id in number default hr_api.g_number
1323: ,p_interface_source in varchar2 default hr_api.g_varchar2
1324: ,p_total_training_time in varchar2 default hr_api.g_varchar2
1325: ,p_content_player_status in varchar2 default hr_api.g_varchar2
1326: ,p_score in number default hr_api.g_number
1327: ,p_completed_content in number default hr_api.g_number
1328: ,p_total_content in number default hr_api.g_number
1329: ,p_return_status out nocopy varchar2

Line 1326: ,p_score in number default hr_api.g_number

1322: ,p_quote_line_id in number default hr_api.g_number
1323: ,p_interface_source in varchar2 default hr_api.g_varchar2
1324: ,p_total_training_time in varchar2 default hr_api.g_varchar2
1325: ,p_content_player_status in varchar2 default hr_api.g_varchar2
1326: ,p_score in number default hr_api.g_number
1327: ,p_completed_content in number default hr_api.g_number
1328: ,p_total_content in number default hr_api.g_number
1329: ,p_return_status out nocopy varchar2
1330: ,p_booking_justification_id in number default hr_api.g_number

Line 1327: ,p_completed_content in number default hr_api.g_number

1323: ,p_interface_source in varchar2 default hr_api.g_varchar2
1324: ,p_total_training_time in varchar2 default hr_api.g_varchar2
1325: ,p_content_player_status in varchar2 default hr_api.g_varchar2
1326: ,p_score in number default hr_api.g_number
1327: ,p_completed_content in number default hr_api.g_number
1328: ,p_total_content in number default hr_api.g_number
1329: ,p_return_status out nocopy varchar2
1330: ,p_booking_justification_id in number default hr_api.g_number
1331: ,p_is_history_flag in varchar2 default hr_api.g_varchar2

Line 1328: ,p_total_content in number default hr_api.g_number

1324: ,p_total_training_time in varchar2 default hr_api.g_varchar2
1325: ,p_content_player_status in varchar2 default hr_api.g_varchar2
1326: ,p_score in number default hr_api.g_number
1327: ,p_completed_content in number default hr_api.g_number
1328: ,p_total_content in number default hr_api.g_number
1329: ,p_return_status out nocopy varchar2
1330: ,p_booking_justification_id in number default hr_api.g_number
1331: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
1332: ,p_override_prerequisites in varchar2

Line 1330: ,p_booking_justification_id in number default hr_api.g_number

1326: ,p_score in number default hr_api.g_number
1327: ,p_completed_content in number default hr_api.g_number
1328: ,p_total_content in number default hr_api.g_number
1329: ,p_return_status out nocopy varchar2
1330: ,p_booking_justification_id in number default hr_api.g_number
1331: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
1332: ,p_override_prerequisites in varchar2
1333: ,p_override_learner_access in varchar2
1334: ) is

Line 1331: ,p_is_history_flag in varchar2 default hr_api.g_varchar2

1327: ,p_completed_content in number default hr_api.g_number
1328: ,p_total_content in number default hr_api.g_number
1329: ,p_return_status out nocopy varchar2
1330: ,p_booking_justification_id in number default hr_api.g_number
1331: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
1332: ,p_override_prerequisites in varchar2
1333: ,p_override_learner_access in varchar2
1334: ) is
1335: --

Line 1385: hr_api.constant_to_boolean

1381: --
1382: -- Convert constant values to their corresponding boolean value
1383: --
1384: l_validate :=
1385: hr_api.constant_to_boolean
1386: (p_constant_value => p_validate);
1387: --
1388: -- Register Surrogate ID or user key values
1389: --