DBA Data[Home] [Help]

APPS.PA_PLAN_MATRIX dependencies on FND_GLOBAL

Line 287: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

283: )
284: IS
285: --Local Variable Declarations
286: --Added By Vijay Gautam
287: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
288: l_created_by NUMBER := FND_GLOBAL.USER_ID;
289: l_creation_date DATE := SYSDATE;
290: l_last_update_date DATE := l_creation_date;
291: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line 288: l_created_by NUMBER := FND_GLOBAL.USER_ID;

284: IS
285: --Local Variable Declarations
286: --Added By Vijay Gautam
287: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
288: l_created_by NUMBER := FND_GLOBAL.USER_ID;
289: l_creation_date DATE := SYSDATE;
290: l_last_update_date DATE := l_creation_date;
291: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
292:

Line 291: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

287: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
288: l_created_by NUMBER := FND_GLOBAL.USER_ID;
289: l_creation_date DATE := SYSDATE;
290: l_last_update_date DATE := l_creation_date;
291: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
292:
293: l_plan_period_type VARCHAR2(30);
294: l_project_id NUMBER;
295: l_resource_assignment_id NUMBER;

Line 1481: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

1477:
1478: l_temp NUMBER(5);
1479: l_matrix_counter NUMBER ;
1480: l_number_of_periods NUMBER;
1481: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1482: l_created_by NUMBER := FND_GLOBAL.USER_ID;
1483: l_creation_date DATE := SYSDATE;
1484: l_last_update_date DATE := l_creation_date;
1485: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line 1482: l_created_by NUMBER := FND_GLOBAL.USER_ID;

1478: l_temp NUMBER(5);
1479: l_matrix_counter NUMBER ;
1480: l_number_of_periods NUMBER;
1481: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1482: l_created_by NUMBER := FND_GLOBAL.USER_ID;
1483: l_creation_date DATE := SYSDATE;
1484: l_last_update_date DATE := l_creation_date;
1485: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1486: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

Line 1485: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

1481: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1482: l_created_by NUMBER := FND_GLOBAL.USER_ID;
1483: l_creation_date DATE := SYSDATE;
1484: l_last_update_date DATE := l_creation_date;
1485: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1486: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1487: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1488: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1489:

Line 1486: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

1482: l_created_by NUMBER := FND_GLOBAL.USER_ID;
1483: l_creation_date DATE := SYSDATE;
1484: l_last_update_date DATE := l_creation_date;
1485: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1486: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1487: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1488: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1489:
1490: --Added By Vijay Gautam

Line 1487: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1483: l_creation_date DATE := SYSDATE;
1484: l_last_update_date DATE := l_creation_date;
1485: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1486: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1487: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1488: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1489:
1490: --Added By Vijay Gautam
1491: l_bucketing_period_code_tab PA_PLSQL_DATATYPES.Char30TabTyp; --added this table

Line 1488: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

1484: l_last_update_date DATE := l_creation_date;
1485: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1486: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1487: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1488: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1489:
1490: --Added By Vijay Gautam
1491: l_bucketing_period_code_tab PA_PLSQL_DATATYPES.Char30TabTyp; --added this table
1492: l_parent_assign_id_tab PA_PLSQL_DATATYPES.NumTabTyp; --added this Table