DBA Data[Home] [Help]

APPS.PA_PAY_INTERFACE dependencies on FND_GLOBAL

Line 397: G_ORG_ID := FND_GLOBAL.ORG_ID;

393:
394: -- SELECT org_id INTO G_ORG_ID FROM pa_implementations;
395: SELECT sysdate INTO G_RUN_DATE FROM dual;
396:
397: G_ORG_ID := FND_GLOBAL.ORG_ID;
398: G_USER_ID :=FND_GLOBAL.USER_ID;
399: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID();
400: G_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
401: G_PROG_APPL_ID := FND_GLOBAL.PROG_APPL_ID;

Line 398: G_USER_ID :=FND_GLOBAL.USER_ID;

394: -- SELECT org_id INTO G_ORG_ID FROM pa_implementations;
395: SELECT sysdate INTO G_RUN_DATE FROM dual;
396:
397: G_ORG_ID := FND_GLOBAL.ORG_ID;
398: G_USER_ID :=FND_GLOBAL.USER_ID;
399: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID();
400: G_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
401: G_PROG_APPL_ID := FND_GLOBAL.PROG_APPL_ID;
402: G_FUNC_CURR_CODE := PA_CURRENCY.GET_CURRENCY_CODE;

Line 399: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID();

395: SELECT sysdate INTO G_RUN_DATE FROM dual;
396:
397: G_ORG_ID := FND_GLOBAL.ORG_ID;
398: G_USER_ID :=FND_GLOBAL.USER_ID;
399: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID();
400: G_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
401: G_PROG_APPL_ID := FND_GLOBAL.PROG_APPL_ID;
402: G_FUNC_CURR_CODE := PA_CURRENCY.GET_CURRENCY_CODE;
403: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID();

Line 400: G_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

396:
397: G_ORG_ID := FND_GLOBAL.ORG_ID;
398: G_USER_ID :=FND_GLOBAL.USER_ID;
399: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID();
400: G_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
401: G_PROG_APPL_ID := FND_GLOBAL.PROG_APPL_ID;
402: G_FUNC_CURR_CODE := PA_CURRENCY.GET_CURRENCY_CODE;
403: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID();
404: G_DEBUG_MODE := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 401: G_PROG_APPL_ID := FND_GLOBAL.PROG_APPL_ID;

397: G_ORG_ID := FND_GLOBAL.ORG_ID;
398: G_USER_ID :=FND_GLOBAL.USER_ID;
399: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID();
400: G_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
401: G_PROG_APPL_ID := FND_GLOBAL.PROG_APPL_ID;
402: G_FUNC_CURR_CODE := PA_CURRENCY.GET_CURRENCY_CODE;
403: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID();
404: G_DEBUG_MODE := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
405: G_RETRO := 'N';

Line 403: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID();

399: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID();
400: G_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
401: G_PROG_APPL_ID := FND_GLOBAL.PROG_APPL_ID;
402: G_FUNC_CURR_CODE := PA_CURRENCY.GET_CURRENCY_CODE;
403: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID();
404: G_DEBUG_MODE := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
405: G_RETRO := 'N';
406:
407: l_date_from := fnd_date.canonical_to_date(P_FROM_DATE);

Line 752: HOI.ORG_INFORMATION1 = To_Char(FND_GLOBAL.ORG_ID) AND

748: WHERE
749: PCPV.PERSON_ID = PAAF.PERSON_ID AND
750: PCPV.ASSIGNMENT_NUMBER = PAAF.ASSIGNMENT_NUMBER AND
751: HOI.organization_id = PAAF.organization_id AND
752: HOI.ORG_INFORMATION1 = To_Char(FND_GLOBAL.ORG_ID) AND
753: PCPV.TIME_PERIOD_END_DATE BETWEEN (P_FROM_DATE ) AND ( P_TO_DATE )
754: AND PCPV.PAYROLL_ID = Nvl(P_PAYROLL_ID,PCPV.PAYROLL_ID)
755: AND PCPV.PERSON_ID = Nvl(P_PERSON_ID,PCPV.PERSON_ID)
756: AND PCPV.ORGANIZATION_ID = Nvl(P_EMP_ORG_ID,PCPV.ORGANIZATION_ID)

Line 850: FND_GLOBAL.CONC_REQUEST_ID,

846: PEM.PAYROLL_PROJ_SEGMENT,
847: PEM.PAYROLL_TASK_SEGMENT,
848: PIT.OUTPUT_CURRENCY_CODE,
849: 458 ORG,
850: FND_GLOBAL.CONC_REQUEST_ID,
851: trunc(sysdate)L_UPDATE_DATE,
852: fnd_global.user_id L_UPDATE_BY,
853: trunc(sysdate) C_UPDATE_DATE,
854: fnd_global.user_id C_UPDATE_BY,';

Line 852: fnd_global.user_id L_UPDATE_BY,

848: PIT.OUTPUT_CURRENCY_CODE,
849: 458 ORG,
850: FND_GLOBAL.CONC_REQUEST_ID,
851: trunc(sysdate)L_UPDATE_DATE,
852: fnd_global.user_id L_UPDATE_BY,
853: trunc(sysdate) C_UPDATE_DATE,
854: fnd_global.user_id C_UPDATE_BY,';
855:
856: IF P_PAYROLL_PROJ_SEGMENT IS NOT NULL THEN

Line 854: fnd_global.user_id C_UPDATE_BY,';

850: FND_GLOBAL.CONC_REQUEST_ID,
851: trunc(sysdate)L_UPDATE_DATE,
852: fnd_global.user_id L_UPDATE_BY,
853: trunc(sysdate) C_UPDATE_DATE,
854: fnd_global.user_id C_UPDATE_BY,';
855:
856: IF P_PAYROLL_PROJ_SEGMENT IS NOT NULL THEN
857: l_insert_random := ' , PAY_SOURCE_PROJECT_ID';
858: l_sql_sel_random := P_PAYROLL_PROJ_SEGMENT || ' , ';

Line 1006: FND_GLOBAL.CONC_REQUEST_ID ,

1002: PPEI.PAY_SOURCE_PROJECT_ID ,
1003: PPEI.PAY_SOURCE_TASK_ID ,
1004: PPEI.PAY_CURRENCY_CODE ,
1005: G_ORG_ID ,
1006: FND_GLOBAL.CONC_REQUEST_ID ,
1007: TRUNC(sysdate)L_UPDATE_DATE ,
1008: fnd_global.user_id L_UPDATE_BY,
1009: TRUNC(sysdate) C_UPDATE_DATE ,
1010: fnd_global.user_id C_UPDATE_BY,

Line 1008: fnd_global.user_id L_UPDATE_BY,

1004: PPEI.PAY_CURRENCY_CODE ,
1005: G_ORG_ID ,
1006: FND_GLOBAL.CONC_REQUEST_ID ,
1007: TRUNC(sysdate)L_UPDATE_DATE ,
1008: fnd_global.user_id L_UPDATE_BY,
1009: TRUNC(sysdate) C_UPDATE_DATE ,
1010: fnd_global.user_id C_UPDATE_BY,
1011: SUM(PAY_AMOUNT) PAY_AMOUNT
1012: FROM

Line 1010: fnd_global.user_id C_UPDATE_BY,

1006: FND_GLOBAL.CONC_REQUEST_ID ,
1007: TRUNC(sysdate)L_UPDATE_DATE ,
1008: fnd_global.user_id L_UPDATE_BY,
1009: TRUNC(sysdate) C_UPDATE_DATE ,
1010: fnd_global.user_id C_UPDATE_BY,
1011: SUM(PAY_AMOUNT) PAY_AMOUNT
1012: FROM
1013: PA_PAY_AUDIT PAA ,
1014: PA_PAY_EXT_INTERAFACE_V PPEI,

Line 1667: fnd_global.user_id,

1663: DECODE(COST_TYPE_CODE,'RAW',PAY_AMOUNT,0),
1664: DECODE(COST_TYPE_CODE,'BURDEN',PAY_AMOUNT,0),
1665: ORG_ID,
1666: trunc(sysdate),
1667: fnd_global.user_id,
1668: trunc(sysdate),
1669: fnd_global.user_id
1670: from PA_PAY_SOURCE_AMOUNTS
1671: WHERE PAY_REJECTION_ID IS NULL

Line 1669: fnd_global.user_id

1665: ORG_ID,
1666: trunc(sysdate),
1667: fnd_global.user_id,
1668: trunc(sysdate),
1669: fnd_global.user_id
1670: from PA_PAY_SOURCE_AMOUNTS
1671: WHERE PAY_REJECTION_ID IS NULL
1672: AND DISTRIBUTION_BASIS_CODE = 'NONE'
1673: AND PAY_SOURCE_PROJECT_ID >0

Line 2074: fnd_global.user_id ,

2070: RATIO_TO_REPORT(EII.QUANTITY) over (PARTITION BY PAY_SOURCE_ID) * PSA.PAY_AMOUNT AS AMOUNT ,
2071: EII.EXPENDITURE_ITEM_ID ,
2072: EII.ORG_ID ,
2073: TRUNC(sysdate) ,
2074: fnd_global.user_id ,
2075: TRUNC(sysdate) ,
2076: fnd_global.user_id ,
2077: G_LOGIN_ID ,
2078: G_REQUEST_ID

Line 2076: fnd_global.user_id ,

2072: EII.ORG_ID ,
2073: TRUNC(sysdate) ,
2074: fnd_global.user_id ,
2075: TRUNC(sysdate) ,
2076: fnd_global.user_id ,
2077: G_LOGIN_ID ,
2078: G_REQUEST_ID
2079: FROM
2080: PA_PAY_EXP_TEMP EII , -- change to PA_PAY_EXP_TEMP danger