DBA Data[Home] [Help]

APPS.PSB_HR_POPULATE_DATA_PVT dependencies on FND_GLOBAL

Line 367: l_last_updated_BY := FND_GLOBAL.USER_ID;

363:
364: BEGIN
365: /* Bug 4222417 Start */
366: l_last_update_date := SYSDATE;
367: l_last_updated_BY := FND_GLOBAL.USER_ID;
368: l_last_update_login := FND_GLOBAL.LOGIN_ID;
369: l_creation_date := SYSDATE;
370: l_created_by := FND_GLOBAL.USER_ID;
371: /* Bug 4222417 End */

Line 368: l_last_update_login := FND_GLOBAL.LOGIN_ID;

364: BEGIN
365: /* Bug 4222417 Start */
366: l_last_update_date := SYSDATE;
367: l_last_updated_BY := FND_GLOBAL.USER_ID;
368: l_last_update_login := FND_GLOBAL.LOGIN_ID;
369: l_creation_date := SYSDATE;
370: l_created_by := FND_GLOBAL.USER_ID;
371: /* Bug 4222417 End */
372:

Line 370: l_created_by := FND_GLOBAL.USER_ID;

366: l_last_update_date := SYSDATE;
367: l_last_updated_BY := FND_GLOBAL.USER_ID;
368: l_last_update_login := FND_GLOBAL.LOGIN_ID;
369: l_creation_date := SYSDATE;
370: l_created_by := FND_GLOBAL.USER_ID;
371: /* Bug 4222417 End */
372:
373: --hr_utility.trace_on;
374: hr_utility.set_location(' Inside Salary Assignment',333);

Line 551: l_last_updated_BY := FND_GLOBAL.USER_ID;

547:
548: -- Bug 4222417 moved the following statements
549: -- to the beginning of the api
550: /* l_last_update_date := sysdate;
551: l_last_updated_BY := FND_GLOBAL.USER_ID;
552: l_last_update_login := FND_GLOBAL.LOGIN_ID;
553: l_creation_date := sysdate;
554: l_created_by := FND_GLOBAL.USER_ID; */
555:

Line 552: l_last_update_login := FND_GLOBAL.LOGIN_ID;

548: -- Bug 4222417 moved the following statements
549: -- to the beginning of the api
550: /* l_last_update_date := sysdate;
551: l_last_updated_BY := FND_GLOBAL.USER_ID;
552: l_last_update_login := FND_GLOBAL.LOGIN_ID;
553: l_creation_date := sysdate;
554: l_created_by := FND_GLOBAL.USER_ID; */
555:
556: Select psb_pay_element_options_s.nextval

Line 554: l_created_by := FND_GLOBAL.USER_ID; */

550: /* l_last_update_date := sysdate;
551: l_last_updated_BY := FND_GLOBAL.USER_ID;
552: l_last_update_login := FND_GLOBAL.LOGIN_ID;
553: l_creation_date := sysdate;
554: l_created_by := FND_GLOBAL.USER_ID; */
555:
556: Select psb_pay_element_options_s.nextval
557: INTO l_pay_element_option_id
558: FROM dual;

Line 1330: l_last_updated_BY := FND_GLOBAL.USER_ID;

1326: END LOOP;
1327:
1328: IF (l_attribute_value_id IS NULL) THEN
1329: l_last_update_date := sysdate;
1330: l_last_updated_BY := FND_GLOBAL.USER_ID;
1331: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1332: l_creation_date := sysDATE;
1333: l_created_by := FND_GLOBAL.USER_ID;
1334:

Line 1331: l_last_update_login := FND_GLOBAL.LOGIN_ID;

1327:
1328: IF (l_attribute_value_id IS NULL) THEN
1329: l_last_update_date := sysdate;
1330: l_last_updated_BY := FND_GLOBAL.USER_ID;
1331: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1332: l_creation_date := sysDATE;
1333: l_created_by := FND_GLOBAL.USER_ID;
1334:
1335: -- Insert the new value in PSB_ATTRIBUTE_VALUES

Line 1333: l_created_by := FND_GLOBAL.USER_ID;

1329: l_last_update_date := sysdate;
1330: l_last_updated_BY := FND_GLOBAL.USER_ID;
1331: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1332: l_creation_date := sysDATE;
1333: l_created_by := FND_GLOBAL.USER_ID;
1334:
1335: -- Insert the new value in PSB_ATTRIBUTE_VALUES
1336: select psb_attribute_values_s.nextval into
1337: l_attribute_value_id from dual;

Line 5822: l_last_updated_BY := FND_GLOBAL.USER_ID;

5818: PSB_HR_POPULATE_DATA_PVT.g_pop_assignment := 'Y';
5819:
5820: -- Populate WHO columns.
5821: l_last_update_date := sysdate;
5822: l_last_updated_BY := FND_GLOBAL.USER_ID;
5823: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5824: l_creation_date := sysdate;
5825: l_created_BY := FND_GLOBAL.USER_ID;
5826:

Line 5823: l_last_update_login := FND_GLOBAL.LOGIN_ID;

5819:
5820: -- Populate WHO columns.
5821: l_last_update_date := sysdate;
5822: l_last_updated_BY := FND_GLOBAL.USER_ID;
5823: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5824: l_creation_date := sysdate;
5825: l_created_BY := FND_GLOBAL.USER_ID;
5826:
5827: -- DE by Org

Line 5825: l_created_BY := FND_GLOBAL.USER_ID;

5821: l_last_update_date := sysdate;
5822: l_last_updated_BY := FND_GLOBAL.USER_ID;
5823: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5824: l_creation_date := sysdate;
5825: l_created_BY := FND_GLOBAL.USER_ID;
5826:
5827: -- DE by Org
5828: -- If extract_method is REFRESH do nothing.
5829: -- Else use the appropriate extract_method based on the organization's

Line 7128: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;

7124:
7125: Savepoint Populate_Employee;
7126:
7127: l_last_upDATE_DATE := sysDATE;
7128: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
7129: l_last_upDATE_login := FND_GLOBAL.LOGIN_ID;
7130: l_creation_DATE := sysDATE;
7131: l_created_BY := FND_GLOBAL.USER_ID;
7132:

Line 7129: l_last_upDATE_login := FND_GLOBAL.LOGIN_ID;

7125: Savepoint Populate_Employee;
7126:
7127: l_last_upDATE_DATE := sysDATE;
7128: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
7129: l_last_upDATE_login := FND_GLOBAL.LOGIN_ID;
7130: l_creation_DATE := sysDATE;
7131: l_created_BY := FND_GLOBAL.USER_ID;
7132:
7133: -- StANDard call to check FOR call compatibility.

Line 7131: l_created_BY := FND_GLOBAL.USER_ID;

7127: l_last_upDATE_DATE := sysDATE;
7128: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
7129: l_last_upDATE_login := FND_GLOBAL.LOGIN_ID;
7130: l_creation_DATE := sysDATE;
7131: l_created_BY := FND_GLOBAL.USER_ID;
7132:
7133: -- StANDard call to check FOR call compatibility.
7134:
7135: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 7938: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;

7934: Begin
7935:
7936: Savepoint Populate_Element;
7937: l_last_update_date := sysDATE;
7938: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
7939: l_last_upDATE_login :=FND_GLOBAL.LOGIN_ID;
7940: l_creation_DATE := sysDATE;
7941: l_created_BY := FND_GLOBAL.USER_ID;
7942:

Line 7939: l_last_upDATE_login :=FND_GLOBAL.LOGIN_ID;

7935:
7936: Savepoint Populate_Element;
7937: l_last_update_date := sysDATE;
7938: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
7939: l_last_upDATE_login :=FND_GLOBAL.LOGIN_ID;
7940: l_creation_DATE := sysDATE;
7941: l_created_BY := FND_GLOBAL.USER_ID;
7942:
7943:

Line 7941: l_created_BY := FND_GLOBAL.USER_ID;

7937: l_last_update_date := sysDATE;
7938: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
7939: l_last_upDATE_login :=FND_GLOBAL.LOGIN_ID;
7940: l_creation_DATE := sysDATE;
7941: l_created_BY := FND_GLOBAL.USER_ID;
7942:
7943:
7944: IF NOT FND_API.Compatible_API_Call (l_api_version,
7945: p_api_version,

Line 8521: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;

8517:
8518: Savepoint Populate_Attributes;
8519:
8520: l_last_update_date := sysDATE;
8521: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
8522: l_last_upDATE_login :=FND_GLOBAL.LOGIN_ID;
8523: l_creation_DATE := sysDATE;
8524: l_created_BY := FND_GLOBAL.USER_ID;
8525:

Line 8522: l_last_upDATE_login :=FND_GLOBAL.LOGIN_ID;

8518: Savepoint Populate_Attributes;
8519:
8520: l_last_update_date := sysDATE;
8521: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
8522: l_last_upDATE_login :=FND_GLOBAL.LOGIN_ID;
8523: l_creation_DATE := sysDATE;
8524: l_created_BY := FND_GLOBAL.USER_ID;
8525:
8526:

Line 8524: l_created_BY := FND_GLOBAL.USER_ID;

8520: l_last_update_date := sysDATE;
8521: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
8522: l_last_upDATE_login :=FND_GLOBAL.LOGIN_ID;
8523: l_creation_DATE := sysDATE;
8524: l_created_BY := FND_GLOBAL.USER_ID;
8525:
8526:
8527: IF NOT FND_API.Compatible_API_Call (l_api_version,
8528: p_api_version,

Line 9067: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;

9063:
9064: Savepoint Populate_Position_Assignments;
9065:
9066: l_last_update_date := sysDATE;
9067: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
9068: l_last_upDATE_login := FND_GLOBAL.LOGIN_ID;
9069: l_creation_DATE := sysDATE;
9070: l_created_BY := FND_GLOBAL.USER_ID;
9071:

Line 9068: l_last_upDATE_login := FND_GLOBAL.LOGIN_ID;

9064: Savepoint Populate_Position_Assignments;
9065:
9066: l_last_update_date := sysDATE;
9067: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
9068: l_last_upDATE_login := FND_GLOBAL.LOGIN_ID;
9069: l_creation_DATE := sysDATE;
9070: l_created_BY := FND_GLOBAL.USER_ID;
9071:
9072: /* start bug 4153562 */

Line 9070: l_created_BY := FND_GLOBAL.USER_ID;

9066: l_last_update_date := sysDATE;
9067: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
9068: l_last_upDATE_login := FND_GLOBAL.LOGIN_ID;
9069: l_creation_DATE := sysDATE;
9070: l_created_BY := FND_GLOBAL.USER_ID;
9071:
9072: /* start bug 4153562 */
9073: -- initialize the packaged varible with the extract method.
9074: PSB_HR_POPULATE_DATA_PVT.g_extract_method := p_extract_method;

Line 9582: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;

9578:
9579: Savepoint Apply_Defaults;
9580:
9581: l_last_upDATE_DATE := sysDATE;
9582: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
9583: l_last_upDATE_login :=FND_GLOBAL.LOGIN_ID;
9584: l_creation_DATE := sysDATE;
9585: l_created_BY := FND_GLOBAL.USER_ID;
9586:

Line 9583: l_last_upDATE_login :=FND_GLOBAL.LOGIN_ID;

9579: Savepoint Apply_Defaults;
9580:
9581: l_last_upDATE_DATE := sysDATE;
9582: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
9583: l_last_upDATE_login :=FND_GLOBAL.LOGIN_ID;
9584: l_creation_DATE := sysDATE;
9585: l_created_BY := FND_GLOBAL.USER_ID;
9586:
9587: -- StANDard call to check FOR call compatibility.

Line 9585: l_created_BY := FND_GLOBAL.USER_ID;

9581: l_last_upDATE_DATE := sysDATE;
9582: l_last_upDATEd_BY := FND_GLOBAL.USER_ID;
9583: l_last_upDATE_login :=FND_GLOBAL.LOGIN_ID;
9584: l_creation_DATE := sysDATE;
9585: l_created_BY := FND_GLOBAL.USER_ID;
9586:
9587: -- StANDard call to check FOR call compatibility.
9588:
9589: IF NOT FND_API.Compatible_API_Call (l_api_version,