DBA Data[Home] [Help]

APPS.PAY_SE_POPULATE_COUNTRIES dependencies on PAY_USER_ROW_API

Line 85: These are the parameters to call the PAY_USER_ROW_API.UPDATE_USER_ROW

81: l_row_low_range_or_name :=' ';
82:
83: /*
84: ----------------------------------------------------------
85: These are the parameters to call the PAY_USER_ROW_API.UPDATE_USER_ROW
86: P_VALIDATE BOOLEAN IN DEFAULT
87: P_EFFECTIVE_DATE DATE IN
88: P_DATETRACK_UPDATE_MODE VARCHAR2 IN
89: P_USER_ROW_ID NUMBER IN

Line 106: PAY_USER_ROW_API.UPDATE_USER_ROW

102: FETCH c_chk_territory INTO l_row_low_range_or_name ;
103: CLOSE c_chk_territory;
104:
105:
106: PAY_USER_ROW_API.UPDATE_USER_ROW
107: ( P_VALIDATE => FALSE
108: , P_EFFECTIVE_DATE => l_effective_date
109: , P_DATETRACK_UPDATE_MODE => 'CORRECTION'
110: , P_USER_ROW_ID => tc_rec.user_row_id

Line 149: These are the parmeters to call the PAY_USER_ROW_API.CREATE_USER_ROW

145: l_user_column_instance_id := NULL;
146:
147: /*
148: ----------------------------------------------------------
149: These are the parmeters to call the PAY_USER_ROW_API.CREATE_USER_ROW
150: p_validate in boolean default false
151: ,p_effective_date in date
152: ,p_user_table_id in number
153: ,p_row_low_range_or_name in varchar2

Line 167: -- Call the Procedure pay_user_row_api.create_user_row to insert

163: ,p_effective_end_date out nocopy date
164: -------------------------------------------------------------
165: */
166:
167: -- Call the Procedure pay_user_row_api.create_user_row to insert
168: --rows into the Table
169: --
170: l_display_sequence := l_display_sequence + 1 ;
171: l_effective_date := TO_DATE('01010001','DDMMYYYY');

Line 173: PAY_USER_ROW_API.CREATE_USER_ROW

169: --
170: l_display_sequence := l_display_sequence + 1 ;
171: l_effective_date := TO_DATE('01010001','DDMMYYYY');
172:
173: PAY_USER_ROW_API.CREATE_USER_ROW
174: (p_validate => FALSE
175: ,p_effective_date => l_effective_date
176: ,p_user_table_id => l_user_table_id
177: ,p_row_low_range_or_name => territory_rec.territory_short_name