eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_RIW_OFFERING_WRAPPER dependencies on HR_API

Line 32: l_offering_rec.business_group_id := hr_api.g_number;

28: g_date constant date := to_date('01-01-4712', 'DD-MM-SYYYY');
29: ==========================================================================
30: */
31: Hr_Utility.set_location(' Before : ', 5);
32: l_offering_rec.business_group_id := hr_api.g_number;
33: l_offering_rec.name := hr_api.g_varchar2 ;
34: l_offering_rec.start_date := hr_api.g_date ;
35: l_offering_rec.activity_version_id := hr_api.g_number ;
36: l_offering_rec.end_date := hr_api.g_date ;

Line 33: l_offering_rec.name := hr_api.g_varchar2 ;

29: ==========================================================================
30: */
31: Hr_Utility.set_location(' Before : ', 5);
32: l_offering_rec.business_group_id := hr_api.g_number;
33: l_offering_rec.name := hr_api.g_varchar2 ;
34: l_offering_rec.start_date := hr_api.g_date ;
35: l_offering_rec.activity_version_id := hr_api.g_number ;
36: l_offering_rec.end_date := hr_api.g_date ;
37: l_offering_rec.owner_id := hr_api.g_number ;

Line 34: l_offering_rec.start_date := hr_api.g_date ;

30: */
31: Hr_Utility.set_location(' Before : ', 5);
32: l_offering_rec.business_group_id := hr_api.g_number;
33: l_offering_rec.name := hr_api.g_varchar2 ;
34: l_offering_rec.start_date := hr_api.g_date ;
35: l_offering_rec.activity_version_id := hr_api.g_number ;
36: l_offering_rec.end_date := hr_api.g_date ;
37: l_offering_rec.owner_id := hr_api.g_number ;
38: l_offering_rec.delivery_mode_id := hr_api.g_number ;

Line 35: l_offering_rec.activity_version_id := hr_api.g_number ;

31: Hr_Utility.set_location(' Before : ', 5);
32: l_offering_rec.business_group_id := hr_api.g_number;
33: l_offering_rec.name := hr_api.g_varchar2 ;
34: l_offering_rec.start_date := hr_api.g_date ;
35: l_offering_rec.activity_version_id := hr_api.g_number ;
36: l_offering_rec.end_date := hr_api.g_date ;
37: l_offering_rec.owner_id := hr_api.g_number ;
38: l_offering_rec.delivery_mode_id := hr_api.g_number ;
39: l_offering_rec.language_id := hr_api.g_number ;

Line 36: l_offering_rec.end_date := hr_api.g_date ;

32: l_offering_rec.business_group_id := hr_api.g_number;
33: l_offering_rec.name := hr_api.g_varchar2 ;
34: l_offering_rec.start_date := hr_api.g_date ;
35: l_offering_rec.activity_version_id := hr_api.g_number ;
36: l_offering_rec.end_date := hr_api.g_date ;
37: l_offering_rec.owner_id := hr_api.g_number ;
38: l_offering_rec.delivery_mode_id := hr_api.g_number ;
39: l_offering_rec.language_id := hr_api.g_number ;
40: Hr_Utility.set_location(' after : l_offering_rec.language_id', 5);

Line 37: l_offering_rec.owner_id := hr_api.g_number ;

33: l_offering_rec.name := hr_api.g_varchar2 ;
34: l_offering_rec.start_date := hr_api.g_date ;
35: l_offering_rec.activity_version_id := hr_api.g_number ;
36: l_offering_rec.end_date := hr_api.g_date ;
37: l_offering_rec.owner_id := hr_api.g_number ;
38: l_offering_rec.delivery_mode_id := hr_api.g_number ;
39: l_offering_rec.language_id := hr_api.g_number ;
40: Hr_Utility.set_location(' after : l_offering_rec.language_id', 5);
41: l_offering_rec.duration := hr_api.g_number ;

Line 38: l_offering_rec.delivery_mode_id := hr_api.g_number ;

34: l_offering_rec.start_date := hr_api.g_date ;
35: l_offering_rec.activity_version_id := hr_api.g_number ;
36: l_offering_rec.end_date := hr_api.g_date ;
37: l_offering_rec.owner_id := hr_api.g_number ;
38: l_offering_rec.delivery_mode_id := hr_api.g_number ;
39: l_offering_rec.language_id := hr_api.g_number ;
40: Hr_Utility.set_location(' after : l_offering_rec.language_id', 5);
41: l_offering_rec.duration := hr_api.g_number ;
42: Hr_Utility.set_location(' after : l_offering_rec.duration', 5);

Line 39: l_offering_rec.language_id := hr_api.g_number ;

35: l_offering_rec.activity_version_id := hr_api.g_number ;
36: l_offering_rec.end_date := hr_api.g_date ;
37: l_offering_rec.owner_id := hr_api.g_number ;
38: l_offering_rec.delivery_mode_id := hr_api.g_number ;
39: l_offering_rec.language_id := hr_api.g_number ;
40: Hr_Utility.set_location(' after : l_offering_rec.language_id', 5);
41: l_offering_rec.duration := hr_api.g_number ;
42: Hr_Utility.set_location(' after : l_offering_rec.duration', 5);
43: l_offering_rec.duration_units := hr_api.g_varchar2 ;

Line 41: l_offering_rec.duration := hr_api.g_number ;

37: l_offering_rec.owner_id := hr_api.g_number ;
38: l_offering_rec.delivery_mode_id := hr_api.g_number ;
39: l_offering_rec.language_id := hr_api.g_number ;
40: Hr_Utility.set_location(' after : l_offering_rec.language_id', 5);
41: l_offering_rec.duration := hr_api.g_number ;
42: Hr_Utility.set_location(' after : l_offering_rec.duration', 5);
43: l_offering_rec.duration_units := hr_api.g_varchar2 ;
44: Hr_Utility.set_location(' after : l_offering_rec.duration_units', 5);
45: l_offering_rec.learning_object_id := hr_api.g_number ;

Line 43: l_offering_rec.duration_units := hr_api.g_varchar2 ;

39: l_offering_rec.language_id := hr_api.g_number ;
40: Hr_Utility.set_location(' after : l_offering_rec.language_id', 5);
41: l_offering_rec.duration := hr_api.g_number ;
42: Hr_Utility.set_location(' after : l_offering_rec.duration', 5);
43: l_offering_rec.duration_units := hr_api.g_varchar2 ;
44: Hr_Utility.set_location(' after : l_offering_rec.duration_units', 5);
45: l_offering_rec.learning_object_id := hr_api.g_number ;
46: Hr_Utility.set_location(' Before duration : ', 5);
47: -- l_offering_rec.player_toolbar_flag := hr_api.g_varchar2 ;

Line 45: l_offering_rec.learning_object_id := hr_api.g_number ;

41: l_offering_rec.duration := hr_api.g_number ;
42: Hr_Utility.set_location(' after : l_offering_rec.duration', 5);
43: l_offering_rec.duration_units := hr_api.g_varchar2 ;
44: Hr_Utility.set_location(' after : l_offering_rec.duration_units', 5);
45: l_offering_rec.learning_object_id := hr_api.g_number ;
46: Hr_Utility.set_location(' Before duration : ', 5);
47: -- l_offering_rec.player_toolbar_flag := hr_api.g_varchar2 ;
48: g_player_toolbar_flag :=hr_api.g_varchar2;
49:

Line 47: -- l_offering_rec.player_toolbar_flag := hr_api.g_varchar2 ;

43: l_offering_rec.duration_units := hr_api.g_varchar2 ;
44: Hr_Utility.set_location(' after : l_offering_rec.duration_units', 5);
45: l_offering_rec.learning_object_id := hr_api.g_number ;
46: Hr_Utility.set_location(' Before duration : ', 5);
47: -- l_offering_rec.player_toolbar_flag := hr_api.g_varchar2 ;
48: g_player_toolbar_flag :=hr_api.g_varchar2;
49:
50: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_flag', 5);
51: l_offering_rec.player_toolbar_bitset := hr_api.g_number ;

Line 48: g_player_toolbar_flag :=hr_api.g_varchar2;

44: Hr_Utility.set_location(' after : l_offering_rec.duration_units', 5);
45: l_offering_rec.learning_object_id := hr_api.g_number ;
46: Hr_Utility.set_location(' Before duration : ', 5);
47: -- l_offering_rec.player_toolbar_flag := hr_api.g_varchar2 ;
48: g_player_toolbar_flag :=hr_api.g_varchar2;
49:
50: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_flag', 5);
51: l_offering_rec.player_toolbar_bitset := hr_api.g_number ;
52: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_bitset', 5);

Line 51: l_offering_rec.player_toolbar_bitset := hr_api.g_number ;

47: -- l_offering_rec.player_toolbar_flag := hr_api.g_varchar2 ;
48: g_player_toolbar_flag :=hr_api.g_varchar2;
49:
50: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_flag', 5);
51: l_offering_rec.player_toolbar_bitset := hr_api.g_number ;
52: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_bitset', 5);
53: -- l_offering_rec.player_new_window_flag := hr_api.g_varchar2 ;
54:
55: g_player_new_window_flag :=hr_api.g_varchar2;

Line 53: -- l_offering_rec.player_new_window_flag := hr_api.g_varchar2 ;

49:
50: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_flag', 5);
51: l_offering_rec.player_toolbar_bitset := hr_api.g_number ;
52: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_bitset', 5);
53: -- l_offering_rec.player_new_window_flag := hr_api.g_varchar2 ;
54:
55: g_player_new_window_flag :=hr_api.g_varchar2;
56: Hr_Utility.set_location(' after :g_player_new_window_flag '||g_player_new_window_flag, 5);
57: l_offering_rec.maximum_attendees := hr_api.g_number ;

Line 55: g_player_new_window_flag :=hr_api.g_varchar2;

51: l_offering_rec.player_toolbar_bitset := hr_api.g_number ;
52: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_bitset', 5);
53: -- l_offering_rec.player_new_window_flag := hr_api.g_varchar2 ;
54:
55: g_player_new_window_flag :=hr_api.g_varchar2;
56: Hr_Utility.set_location(' after :g_player_new_window_flag '||g_player_new_window_flag, 5);
57: l_offering_rec.maximum_attendees := hr_api.g_number ;
58: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
59: l_offering_rec.maximum_internal_attendees := hr_api.g_number ;

Line 57: l_offering_rec.maximum_attendees := hr_api.g_number ;

53: -- l_offering_rec.player_new_window_flag := hr_api.g_varchar2 ;
54:
55: g_player_new_window_flag :=hr_api.g_varchar2;
56: Hr_Utility.set_location(' after :g_player_new_window_flag '||g_player_new_window_flag, 5);
57: l_offering_rec.maximum_attendees := hr_api.g_number ;
58: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
59: l_offering_rec.maximum_internal_attendees := hr_api.g_number ;
60: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
61:

Line 59: l_offering_rec.maximum_internal_attendees := hr_api.g_number ;

55: g_player_new_window_flag :=hr_api.g_varchar2;
56: Hr_Utility.set_location(' after :g_player_new_window_flag '||g_player_new_window_flag, 5);
57: l_offering_rec.maximum_attendees := hr_api.g_number ;
58: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
59: l_offering_rec.maximum_internal_attendees := hr_api.g_number ;
60: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
61:
62: l_offering_rec.minimum_attendees := hr_api.g_number ;
63: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);

Line 62: l_offering_rec.minimum_attendees := hr_api.g_number ;

58: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
59: l_offering_rec.maximum_internal_attendees := hr_api.g_number ;
60: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
61:
62: l_offering_rec.minimum_attendees := hr_api.g_number ;
63: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
64:
65: l_offering_rec.actual_cost := hr_api.g_number ;
66:

Line 65: l_offering_rec.actual_cost := hr_api.g_number ;

61:
62: l_offering_rec.minimum_attendees := hr_api.g_number ;
63: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
64:
65: l_offering_rec.actual_cost := hr_api.g_number ;
66:
67: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
68: l_offering_rec.budget_cost := hr_api.g_number ;
69: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);

Line 68: l_offering_rec.budget_cost := hr_api.g_number ;

64:
65: l_offering_rec.actual_cost := hr_api.g_number ;
66:
67: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
68: l_offering_rec.budget_cost := hr_api.g_number ;
69: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
70: l_offering_rec.budget_currency_code := hr_api.g_varchar2 ;
71: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
72: l_offering_rec.price_basis := hr_api.g_varchar2 ;

Line 70: l_offering_rec.budget_currency_code := hr_api.g_varchar2 ;

66:
67: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
68: l_offering_rec.budget_cost := hr_api.g_number ;
69: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
70: l_offering_rec.budget_currency_code := hr_api.g_varchar2 ;
71: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
72: l_offering_rec.price_basis := hr_api.g_varchar2 ;
73: l_offering_rec.currency_code := hr_api.g_varchar2 ;
74: l_offering_rec.standard_price := hr_api.g_number ;

Line 72: l_offering_rec.price_basis := hr_api.g_varchar2 ;

68: l_offering_rec.budget_cost := hr_api.g_number ;
69: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
70: l_offering_rec.budget_currency_code := hr_api.g_varchar2 ;
71: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
72: l_offering_rec.price_basis := hr_api.g_varchar2 ;
73: l_offering_rec.currency_code := hr_api.g_varchar2 ;
74: l_offering_rec.standard_price := hr_api.g_number ;
75: l_offering_rec.attribute_category := hr_api.g_varchar2 ;
76: l_offering_rec.attribute1 := hr_api.g_varchar2 ;

Line 73: l_offering_rec.currency_code := hr_api.g_varchar2 ;

69: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
70: l_offering_rec.budget_currency_code := hr_api.g_varchar2 ;
71: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
72: l_offering_rec.price_basis := hr_api.g_varchar2 ;
73: l_offering_rec.currency_code := hr_api.g_varchar2 ;
74: l_offering_rec.standard_price := hr_api.g_number ;
75: l_offering_rec.attribute_category := hr_api.g_varchar2 ;
76: l_offering_rec.attribute1 := hr_api.g_varchar2 ;
77: l_offering_rec.attribute2 := hr_api.g_varchar2 ;

Line 74: l_offering_rec.standard_price := hr_api.g_number ;

70: l_offering_rec.budget_currency_code := hr_api.g_varchar2 ;
71: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
72: l_offering_rec.price_basis := hr_api.g_varchar2 ;
73: l_offering_rec.currency_code := hr_api.g_varchar2 ;
74: l_offering_rec.standard_price := hr_api.g_number ;
75: l_offering_rec.attribute_category := hr_api.g_varchar2 ;
76: l_offering_rec.attribute1 := hr_api.g_varchar2 ;
77: l_offering_rec.attribute2 := hr_api.g_varchar2 ;
78: l_offering_rec.attribute3 := hr_api.g_varchar2 ;

Line 75: l_offering_rec.attribute_category := hr_api.g_varchar2 ;

71: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
72: l_offering_rec.price_basis := hr_api.g_varchar2 ;
73: l_offering_rec.currency_code := hr_api.g_varchar2 ;
74: l_offering_rec.standard_price := hr_api.g_number ;
75: l_offering_rec.attribute_category := hr_api.g_varchar2 ;
76: l_offering_rec.attribute1 := hr_api.g_varchar2 ;
77: l_offering_rec.attribute2 := hr_api.g_varchar2 ;
78: l_offering_rec.attribute3 := hr_api.g_varchar2 ;
79: l_offering_rec.attribute4 := hr_api.g_varchar2 ;

Line 76: l_offering_rec.attribute1 := hr_api.g_varchar2 ;

72: l_offering_rec.price_basis := hr_api.g_varchar2 ;
73: l_offering_rec.currency_code := hr_api.g_varchar2 ;
74: l_offering_rec.standard_price := hr_api.g_number ;
75: l_offering_rec.attribute_category := hr_api.g_varchar2 ;
76: l_offering_rec.attribute1 := hr_api.g_varchar2 ;
77: l_offering_rec.attribute2 := hr_api.g_varchar2 ;
78: l_offering_rec.attribute3 := hr_api.g_varchar2 ;
79: l_offering_rec.attribute4 := hr_api.g_varchar2 ;
80: l_offering_rec.attribute5 := hr_api.g_varchar2 ;

Line 77: l_offering_rec.attribute2 := hr_api.g_varchar2 ;

73: l_offering_rec.currency_code := hr_api.g_varchar2 ;
74: l_offering_rec.standard_price := hr_api.g_number ;
75: l_offering_rec.attribute_category := hr_api.g_varchar2 ;
76: l_offering_rec.attribute1 := hr_api.g_varchar2 ;
77: l_offering_rec.attribute2 := hr_api.g_varchar2 ;
78: l_offering_rec.attribute3 := hr_api.g_varchar2 ;
79: l_offering_rec.attribute4 := hr_api.g_varchar2 ;
80: l_offering_rec.attribute5 := hr_api.g_varchar2 ;
81: l_offering_rec.attribute6 := hr_api.g_varchar2 ;

Line 78: l_offering_rec.attribute3 := hr_api.g_varchar2 ;

74: l_offering_rec.standard_price := hr_api.g_number ;
75: l_offering_rec.attribute_category := hr_api.g_varchar2 ;
76: l_offering_rec.attribute1 := hr_api.g_varchar2 ;
77: l_offering_rec.attribute2 := hr_api.g_varchar2 ;
78: l_offering_rec.attribute3 := hr_api.g_varchar2 ;
79: l_offering_rec.attribute4 := hr_api.g_varchar2 ;
80: l_offering_rec.attribute5 := hr_api.g_varchar2 ;
81: l_offering_rec.attribute6 := hr_api.g_varchar2 ;
82: l_offering_rec.attribute7 := hr_api.g_varchar2 ;

Line 79: l_offering_rec.attribute4 := hr_api.g_varchar2 ;

75: l_offering_rec.attribute_category := hr_api.g_varchar2 ;
76: l_offering_rec.attribute1 := hr_api.g_varchar2 ;
77: l_offering_rec.attribute2 := hr_api.g_varchar2 ;
78: l_offering_rec.attribute3 := hr_api.g_varchar2 ;
79: l_offering_rec.attribute4 := hr_api.g_varchar2 ;
80: l_offering_rec.attribute5 := hr_api.g_varchar2 ;
81: l_offering_rec.attribute6 := hr_api.g_varchar2 ;
82: l_offering_rec.attribute7 := hr_api.g_varchar2 ;
83: l_offering_rec.attribute8 := hr_api.g_varchar2 ;

Line 80: l_offering_rec.attribute5 := hr_api.g_varchar2 ;

76: l_offering_rec.attribute1 := hr_api.g_varchar2 ;
77: l_offering_rec.attribute2 := hr_api.g_varchar2 ;
78: l_offering_rec.attribute3 := hr_api.g_varchar2 ;
79: l_offering_rec.attribute4 := hr_api.g_varchar2 ;
80: l_offering_rec.attribute5 := hr_api.g_varchar2 ;
81: l_offering_rec.attribute6 := hr_api.g_varchar2 ;
82: l_offering_rec.attribute7 := hr_api.g_varchar2 ;
83: l_offering_rec.attribute8 := hr_api.g_varchar2 ;
84: l_offering_rec.attribute9 := hr_api.g_varchar2 ;

Line 81: l_offering_rec.attribute6 := hr_api.g_varchar2 ;

77: l_offering_rec.attribute2 := hr_api.g_varchar2 ;
78: l_offering_rec.attribute3 := hr_api.g_varchar2 ;
79: l_offering_rec.attribute4 := hr_api.g_varchar2 ;
80: l_offering_rec.attribute5 := hr_api.g_varchar2 ;
81: l_offering_rec.attribute6 := hr_api.g_varchar2 ;
82: l_offering_rec.attribute7 := hr_api.g_varchar2 ;
83: l_offering_rec.attribute8 := hr_api.g_varchar2 ;
84: l_offering_rec.attribute9 := hr_api.g_varchar2 ;
85: l_offering_rec.attribute10 := hr_api.g_varchar2 ;

Line 82: l_offering_rec.attribute7 := hr_api.g_varchar2 ;

78: l_offering_rec.attribute3 := hr_api.g_varchar2 ;
79: l_offering_rec.attribute4 := hr_api.g_varchar2 ;
80: l_offering_rec.attribute5 := hr_api.g_varchar2 ;
81: l_offering_rec.attribute6 := hr_api.g_varchar2 ;
82: l_offering_rec.attribute7 := hr_api.g_varchar2 ;
83: l_offering_rec.attribute8 := hr_api.g_varchar2 ;
84: l_offering_rec.attribute9 := hr_api.g_varchar2 ;
85: l_offering_rec.attribute10 := hr_api.g_varchar2 ;
86: l_offering_rec.attribute11 := hr_api.g_varchar2 ;

Line 83: l_offering_rec.attribute8 := hr_api.g_varchar2 ;

79: l_offering_rec.attribute4 := hr_api.g_varchar2 ;
80: l_offering_rec.attribute5 := hr_api.g_varchar2 ;
81: l_offering_rec.attribute6 := hr_api.g_varchar2 ;
82: l_offering_rec.attribute7 := hr_api.g_varchar2 ;
83: l_offering_rec.attribute8 := hr_api.g_varchar2 ;
84: l_offering_rec.attribute9 := hr_api.g_varchar2 ;
85: l_offering_rec.attribute10 := hr_api.g_varchar2 ;
86: l_offering_rec.attribute11 := hr_api.g_varchar2 ;
87: l_offering_rec.attribute12 := hr_api.g_varchar2 ;

Line 84: l_offering_rec.attribute9 := hr_api.g_varchar2 ;

80: l_offering_rec.attribute5 := hr_api.g_varchar2 ;
81: l_offering_rec.attribute6 := hr_api.g_varchar2 ;
82: l_offering_rec.attribute7 := hr_api.g_varchar2 ;
83: l_offering_rec.attribute8 := hr_api.g_varchar2 ;
84: l_offering_rec.attribute9 := hr_api.g_varchar2 ;
85: l_offering_rec.attribute10 := hr_api.g_varchar2 ;
86: l_offering_rec.attribute11 := hr_api.g_varchar2 ;
87: l_offering_rec.attribute12 := hr_api.g_varchar2 ;
88: l_offering_rec.attribute13 := hr_api.g_varchar2 ;

Line 85: l_offering_rec.attribute10 := hr_api.g_varchar2 ;

81: l_offering_rec.attribute6 := hr_api.g_varchar2 ;
82: l_offering_rec.attribute7 := hr_api.g_varchar2 ;
83: l_offering_rec.attribute8 := hr_api.g_varchar2 ;
84: l_offering_rec.attribute9 := hr_api.g_varchar2 ;
85: l_offering_rec.attribute10 := hr_api.g_varchar2 ;
86: l_offering_rec.attribute11 := hr_api.g_varchar2 ;
87: l_offering_rec.attribute12 := hr_api.g_varchar2 ;
88: l_offering_rec.attribute13 := hr_api.g_varchar2 ;
89: l_offering_rec.attribute14 := hr_api.g_varchar2 ;

Line 86: l_offering_rec.attribute11 := hr_api.g_varchar2 ;

82: l_offering_rec.attribute7 := hr_api.g_varchar2 ;
83: l_offering_rec.attribute8 := hr_api.g_varchar2 ;
84: l_offering_rec.attribute9 := hr_api.g_varchar2 ;
85: l_offering_rec.attribute10 := hr_api.g_varchar2 ;
86: l_offering_rec.attribute11 := hr_api.g_varchar2 ;
87: l_offering_rec.attribute12 := hr_api.g_varchar2 ;
88: l_offering_rec.attribute13 := hr_api.g_varchar2 ;
89: l_offering_rec.attribute14 := hr_api.g_varchar2 ;
90: l_offering_rec.attribute15 := hr_api.g_varchar2 ;

Line 87: l_offering_rec.attribute12 := hr_api.g_varchar2 ;

83: l_offering_rec.attribute8 := hr_api.g_varchar2 ;
84: l_offering_rec.attribute9 := hr_api.g_varchar2 ;
85: l_offering_rec.attribute10 := hr_api.g_varchar2 ;
86: l_offering_rec.attribute11 := hr_api.g_varchar2 ;
87: l_offering_rec.attribute12 := hr_api.g_varchar2 ;
88: l_offering_rec.attribute13 := hr_api.g_varchar2 ;
89: l_offering_rec.attribute14 := hr_api.g_varchar2 ;
90: l_offering_rec.attribute15 := hr_api.g_varchar2 ;
91: l_offering_rec.attribute16 := hr_api.g_varchar2 ;

Line 88: l_offering_rec.attribute13 := hr_api.g_varchar2 ;

84: l_offering_rec.attribute9 := hr_api.g_varchar2 ;
85: l_offering_rec.attribute10 := hr_api.g_varchar2 ;
86: l_offering_rec.attribute11 := hr_api.g_varchar2 ;
87: l_offering_rec.attribute12 := hr_api.g_varchar2 ;
88: l_offering_rec.attribute13 := hr_api.g_varchar2 ;
89: l_offering_rec.attribute14 := hr_api.g_varchar2 ;
90: l_offering_rec.attribute15 := hr_api.g_varchar2 ;
91: l_offering_rec.attribute16 := hr_api.g_varchar2 ;
92: l_offering_rec.attribute17 := hr_api.g_varchar2 ;

Line 89: l_offering_rec.attribute14 := hr_api.g_varchar2 ;

85: l_offering_rec.attribute10 := hr_api.g_varchar2 ;
86: l_offering_rec.attribute11 := hr_api.g_varchar2 ;
87: l_offering_rec.attribute12 := hr_api.g_varchar2 ;
88: l_offering_rec.attribute13 := hr_api.g_varchar2 ;
89: l_offering_rec.attribute14 := hr_api.g_varchar2 ;
90: l_offering_rec.attribute15 := hr_api.g_varchar2 ;
91: l_offering_rec.attribute16 := hr_api.g_varchar2 ;
92: l_offering_rec.attribute17 := hr_api.g_varchar2 ;
93: l_offering_rec.attribute18 := hr_api.g_varchar2 ;

Line 90: l_offering_rec.attribute15 := hr_api.g_varchar2 ;

86: l_offering_rec.attribute11 := hr_api.g_varchar2 ;
87: l_offering_rec.attribute12 := hr_api.g_varchar2 ;
88: l_offering_rec.attribute13 := hr_api.g_varchar2 ;
89: l_offering_rec.attribute14 := hr_api.g_varchar2 ;
90: l_offering_rec.attribute15 := hr_api.g_varchar2 ;
91: l_offering_rec.attribute16 := hr_api.g_varchar2 ;
92: l_offering_rec.attribute17 := hr_api.g_varchar2 ;
93: l_offering_rec.attribute18 := hr_api.g_varchar2 ;
94: l_offering_rec.attribute19 := hr_api.g_varchar2 ;

Line 91: l_offering_rec.attribute16 := hr_api.g_varchar2 ;

87: l_offering_rec.attribute12 := hr_api.g_varchar2 ;
88: l_offering_rec.attribute13 := hr_api.g_varchar2 ;
89: l_offering_rec.attribute14 := hr_api.g_varchar2 ;
90: l_offering_rec.attribute15 := hr_api.g_varchar2 ;
91: l_offering_rec.attribute16 := hr_api.g_varchar2 ;
92: l_offering_rec.attribute17 := hr_api.g_varchar2 ;
93: l_offering_rec.attribute18 := hr_api.g_varchar2 ;
94: l_offering_rec.attribute19 := hr_api.g_varchar2 ;
95: l_offering_rec.attribute20 := hr_api.g_varchar2 ;

Line 92: l_offering_rec.attribute17 := hr_api.g_varchar2 ;

88: l_offering_rec.attribute13 := hr_api.g_varchar2 ;
89: l_offering_rec.attribute14 := hr_api.g_varchar2 ;
90: l_offering_rec.attribute15 := hr_api.g_varchar2 ;
91: l_offering_rec.attribute16 := hr_api.g_varchar2 ;
92: l_offering_rec.attribute17 := hr_api.g_varchar2 ;
93: l_offering_rec.attribute18 := hr_api.g_varchar2 ;
94: l_offering_rec.attribute19 := hr_api.g_varchar2 ;
95: l_offering_rec.attribute20 := hr_api.g_varchar2 ;
96: l_offering_rec.data_source := hr_api.g_varchar2 ;

Line 93: l_offering_rec.attribute18 := hr_api.g_varchar2 ;

89: l_offering_rec.attribute14 := hr_api.g_varchar2 ;
90: l_offering_rec.attribute15 := hr_api.g_varchar2 ;
91: l_offering_rec.attribute16 := hr_api.g_varchar2 ;
92: l_offering_rec.attribute17 := hr_api.g_varchar2 ;
93: l_offering_rec.attribute18 := hr_api.g_varchar2 ;
94: l_offering_rec.attribute19 := hr_api.g_varchar2 ;
95: l_offering_rec.attribute20 := hr_api.g_varchar2 ;
96: l_offering_rec.data_source := hr_api.g_varchar2 ;
97: l_offering_rec.vendor_id := hr_api.g_number ;

Line 94: l_offering_rec.attribute19 := hr_api.g_varchar2 ;

90: l_offering_rec.attribute15 := hr_api.g_varchar2 ;
91: l_offering_rec.attribute16 := hr_api.g_varchar2 ;
92: l_offering_rec.attribute17 := hr_api.g_varchar2 ;
93: l_offering_rec.attribute18 := hr_api.g_varchar2 ;
94: l_offering_rec.attribute19 := hr_api.g_varchar2 ;
95: l_offering_rec.attribute20 := hr_api.g_varchar2 ;
96: l_offering_rec.data_source := hr_api.g_varchar2 ;
97: l_offering_rec.vendor_id := hr_api.g_number ;
98: l_offering_rec.description := hr_api.g_varchar2 ;

Line 95: l_offering_rec.attribute20 := hr_api.g_varchar2 ;

91: l_offering_rec.attribute16 := hr_api.g_varchar2 ;
92: l_offering_rec.attribute17 := hr_api.g_varchar2 ;
93: l_offering_rec.attribute18 := hr_api.g_varchar2 ;
94: l_offering_rec.attribute19 := hr_api.g_varchar2 ;
95: l_offering_rec.attribute20 := hr_api.g_varchar2 ;
96: l_offering_rec.data_source := hr_api.g_varchar2 ;
97: l_offering_rec.vendor_id := hr_api.g_number ;
98: l_offering_rec.description := hr_api.g_varchar2 ;
99: l_offering_rec.competency_update_level := hr_api.g_varchar2 ;

Line 96: l_offering_rec.data_source := hr_api.g_varchar2 ;

92: l_offering_rec.attribute17 := hr_api.g_varchar2 ;
93: l_offering_rec.attribute18 := hr_api.g_varchar2 ;
94: l_offering_rec.attribute19 := hr_api.g_varchar2 ;
95: l_offering_rec.attribute20 := hr_api.g_varchar2 ;
96: l_offering_rec.data_source := hr_api.g_varchar2 ;
97: l_offering_rec.vendor_id := hr_api.g_number ;
98: l_offering_rec.description := hr_api.g_varchar2 ;
99: l_offering_rec.competency_update_level := hr_api.g_varchar2 ;
100: l_offering_rec.language_code := hr_api.g_varchar2 ;

Line 97: l_offering_rec.vendor_id := hr_api.g_number ;

93: l_offering_rec.attribute18 := hr_api.g_varchar2 ;
94: l_offering_rec.attribute19 := hr_api.g_varchar2 ;
95: l_offering_rec.attribute20 := hr_api.g_varchar2 ;
96: l_offering_rec.data_source := hr_api.g_varchar2 ;
97: l_offering_rec.vendor_id := hr_api.g_number ;
98: l_offering_rec.description := hr_api.g_varchar2 ;
99: l_offering_rec.competency_update_level := hr_api.g_varchar2 ;
100: l_offering_rec.language_code := hr_api.g_varchar2 ;
101:

Line 98: l_offering_rec.description := hr_api.g_varchar2 ;

94: l_offering_rec.attribute19 := hr_api.g_varchar2 ;
95: l_offering_rec.attribute20 := hr_api.g_varchar2 ;
96: l_offering_rec.data_source := hr_api.g_varchar2 ;
97: l_offering_rec.vendor_id := hr_api.g_number ;
98: l_offering_rec.description := hr_api.g_varchar2 ;
99: l_offering_rec.competency_update_level := hr_api.g_varchar2 ;
100: l_offering_rec.language_code := hr_api.g_varchar2 ;
101:
102: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

Line 99: l_offering_rec.competency_update_level := hr_api.g_varchar2 ;

95: l_offering_rec.attribute20 := hr_api.g_varchar2 ;
96: l_offering_rec.data_source := hr_api.g_varchar2 ;
97: l_offering_rec.vendor_id := hr_api.g_number ;
98: l_offering_rec.description := hr_api.g_varchar2 ;
99: l_offering_rec.competency_update_level := hr_api.g_varchar2 ;
100: l_offering_rec.language_code := hr_api.g_varchar2 ;
101:
102: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
103: return l_offering_rec;

Line 100: l_offering_rec.language_code := hr_api.g_varchar2 ;

96: l_offering_rec.data_source := hr_api.g_varchar2 ;
97: l_offering_rec.vendor_id := hr_api.g_number ;
98: l_offering_rec.description := hr_api.g_varchar2 ;
99: l_offering_rec.competency_update_level := hr_api.g_varchar2 ;
100: l_offering_rec.language_code := hr_api.g_varchar2 ;
101:
102: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
103: return l_offering_rec;
104: exception

Line 281: (p_validate in number default hr_api.g_false_num

277: -- InsUpd_Offering:
278: -- =============================================================================
279:
280: PROCEDURE InsUpd_Offering
281: (p_validate in number default hr_api.g_false_num
282: ,p_effective_date in date
283: ,p_business_group_id in number
284: ,p_name in varchar2
285: ,p_start_date in date

Line 401: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);

397:
398: --
399: -- Convert constant values to their corresponding boolean value
400: --
401: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);
402:
403: -- $ Finding the value for the l_player_toolbar_bitset based on the input
404: -- $ Flag values
405: l_player_exit_flag :=1;