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.OKC_PAT_PVT dependencies on FND_GLOBAL

Line 1978: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

1974: l_pat_rec.applied_flag,
1975: l_pat_rec.on_invoice_flag,
1976: l_pat_rec.pricing_phase_id,
1977: l_pat_rec.context,
1978: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1979: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1980: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1981: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1982: l_pat_rec.list_header_id,

Line 1979: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

1975: l_pat_rec.on_invoice_flag,
1976: l_pat_rec.pricing_phase_id,
1977: l_pat_rec.context,
1978: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1979: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1980: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1981: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1982: l_pat_rec.list_header_id,
1983: l_pat_rec.list_line_id,

Line 1980: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

1976: l_pat_rec.pricing_phase_id,
1977: l_pat_rec.context,
1978: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1979: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1980: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1981: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1982: l_pat_rec.list_header_id,
1983: l_pat_rec.list_line_id,
1984: l_pat_rec.list_line_type_code,

Line 1981: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),

1977: l_pat_rec.context,
1978: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1979: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1980: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1981: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1982: l_pat_rec.list_header_id,
1983: l_pat_rec.list_line_id,
1984: l_pat_rec.list_line_type_code,
1985: l_pat_rec.change_reason_code,

Line 2112: l_patv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

2108: l_patv_rec patv_rec_type := p_patv_rec;
2109: BEGIN
2110:
2111: l_patv_rec.CREATION_DATE := SYSDATE;
2112: l_patv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2113: l_patv_rec.LAST_UPDATE_DATE := l_patv_rec.CREATION_DATE;
2114: l_patv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2115: l_patv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2116: RETURN(l_patv_rec);

Line 2114: l_patv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2110:
2111: l_patv_rec.CREATION_DATE := SYSDATE;
2112: l_patv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2113: l_patv_rec.LAST_UPDATE_DATE := l_patv_rec.CREATION_DATE;
2114: l_patv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2115: l_patv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2116: RETURN(l_patv_rec);
2117:
2118: END fill_who_columns;

Line 2115: l_patv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2111: l_patv_rec.CREATION_DATE := SYSDATE;
2112: l_patv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2113: l_patv_rec.LAST_UPDATE_DATE := l_patv_rec.CREATION_DATE;
2114: l_patv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2115: l_patv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2116: RETURN(l_patv_rec);
2117:
2118: END fill_who_columns;
2119: ------------------------------------------------

Line 3116: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pat_rec.request_id),

3112: APPLIED_FLAG = l_def_pat_rec.applied_flag,
3113: ON_INVOICE_FLAG = l_def_pat_rec.on_invoice_flag,
3114: PRICING_PHASE_ID = l_def_pat_rec.pricing_phase_id,
3115: CONTEXT = l_def_pat_rec.context,
3116: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pat_rec.request_id),
3117: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pat_rec.program_application_id),
3118: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pat_rec.program_id),
3119: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pat_rec.program_update_date,SYSDATE),
3120:

Line 3117: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pat_rec.program_application_id),

3113: ON_INVOICE_FLAG = l_def_pat_rec.on_invoice_flag,
3114: PRICING_PHASE_ID = l_def_pat_rec.pricing_phase_id,
3115: CONTEXT = l_def_pat_rec.context,
3116: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pat_rec.request_id),
3117: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pat_rec.program_application_id),
3118: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pat_rec.program_id),
3119: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pat_rec.program_update_date,SYSDATE),
3120:
3121: LIST_HEADER_ID = l_def_pat_rec.list_header_id,

Line 3118: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pat_rec.program_id),

3114: PRICING_PHASE_ID = l_def_pat_rec.pricing_phase_id,
3115: CONTEXT = l_def_pat_rec.context,
3116: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pat_rec.request_id),
3117: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pat_rec.program_application_id),
3118: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pat_rec.program_id),
3119: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pat_rec.program_update_date,SYSDATE),
3120:
3121: LIST_HEADER_ID = l_def_pat_rec.list_header_id,
3122: LIST_LINE_ID = l_def_pat_rec.list_line_id,

Line 3119: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pat_rec.program_update_date,SYSDATE),

3115: CONTEXT = l_def_pat_rec.context,
3116: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pat_rec.request_id),
3117: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pat_rec.program_application_id),
3118: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pat_rec.program_id),
3119: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pat_rec.program_update_date,SYSDATE),
3120:
3121: LIST_HEADER_ID = l_def_pat_rec.list_header_id,
3122: LIST_LINE_ID = l_def_pat_rec.list_line_id,
3123: LIST_LINE_TYPE_CODE = l_def_pat_rec.list_line_type_code,

Line 3252: l_patv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

3248: l_patv_rec patv_rec_type := p_patv_rec;
3249: BEGIN
3250:
3251: l_patv_rec.LAST_UPDATE_DATE := SYSDATE;
3252: l_patv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3253: l_patv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3254: RETURN(l_patv_rec);
3255:
3256: END fill_who_columns;

Line 3253: l_patv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

3249: BEGIN
3250:
3251: l_patv_rec.LAST_UPDATE_DATE := SYSDATE;
3252: l_patv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3253: l_patv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3254: RETURN(l_patv_rec);
3255:
3256: END fill_who_columns;
3257: ----------------------------------