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_COPY_CONTRACT_PVT dependencies on FND_GLOBAL

Line 600: l_current_user_id NUMBER := FND_GLOBAL.USER_ID;

596:
597: FUNCTION update_target_contract(p_chr_id IN NUMBER) RETURN BOOLEAN IS
598: l_in_process_yn VARCHAR2(1) := '?';
599: l_user_id NUMBER;
600: l_current_user_id NUMBER := FND_GLOBAL.USER_ID;
601:
602: CURSOR c_locked_user(p_chr_id IN NUMBER) IS
603: SELECT cps.user_id,
604: upper(substr(cps.in_process_yn,1,1)) in_process_yn

Line 1354: AND (cgpv.public_yn = 'Y' OR cgpv.user_id = fnd_global.user_id);

1350: FROM okc_k_grpings_v cgcv,
1351: okc_k_groups_b cgpv
1352: WHERE cgcv.included_chr_id = p_from_chr_id
1353: AND cgcv.cgp_parent_id = cgpv.id
1354: AND (cgpv.public_yn = 'Y' OR cgpv.user_id = fnd_global.user_id);
1355:
1356: BEGIN
1357: x_return_status := l_return_status;
1358: FOR l_c_grpings IN c_grpings LOOP

Line 11368: FND_GLOBAL.USER_ID,

11364: p_components_tbl(i).component_type,
11365: p_components_tbl(i).attribute1,
11366: 'OKCCPCON',
11367: FND_PROFILE.VALUE('ORG_ID'),
11368: FND_GLOBAL.USER_ID,
11369: SYSDATE,
11370: FND_GLOBAL.USER_ID,
11371: FND_GLOBAL.LOGIN_ID,
11372: SYSDATE,

Line 11370: FND_GLOBAL.USER_ID,

11366: 'OKCCPCON',
11367: FND_PROFILE.VALUE('ORG_ID'),
11368: FND_GLOBAL.USER_ID,
11369: SYSDATE,
11370: FND_GLOBAL.USER_ID,
11371: FND_GLOBAL.LOGIN_ID,
11372: SYSDATE,
11373: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
11374: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

Line 11371: FND_GLOBAL.LOGIN_ID,

11367: FND_PROFILE.VALUE('ORG_ID'),
11368: FND_GLOBAL.USER_ID,
11369: SYSDATE,
11370: FND_GLOBAL.USER_ID,
11371: FND_GLOBAL.LOGIN_ID,
11372: SYSDATE,
11373: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
11374: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
11375: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

11369: SYSDATE,
11370: FND_GLOBAL.USER_ID,
11371: FND_GLOBAL.LOGIN_ID,
11372: SYSDATE,
11373: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
11374: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
11375: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
11376: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID)
11377: );

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

11370: FND_GLOBAL.USER_ID,
11371: FND_GLOBAL.LOGIN_ID,
11372: SYSDATE,
11373: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
11374: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
11375: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
11376: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID)
11377: );
11378: END LOOP;

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

11371: FND_GLOBAL.LOGIN_ID,
11372: SYSDATE,
11373: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
11374: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
11375: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
11376: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID)
11377: );
11378: END LOOP;
11379: END IF;

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

11372: SYSDATE,
11373: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
11374: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
11375: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
11376: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID)
11377: );
11378: END LOOP;
11379: END IF;
11380: IF p_lines_tbl.count > 0 THEN

Line 11407: FND_GLOBAL.USER_ID,

11403: p_lines_tbl(j).line_exists_yn,
11404: p_lines_tbl(j).line_exp_yn, --bug 3990643
11405: 'OKCCPCON',
11406: FND_PROFILE.VALUE('ORG_ID'),
11407: FND_GLOBAL.USER_ID,
11408: SYSDATE,
11409: FND_GLOBAL.USER_ID,
11410: FND_GLOBAL.LOGIN_ID,
11411: SYSDATE,

Line 11409: FND_GLOBAL.USER_ID,

11405: 'OKCCPCON',
11406: FND_PROFILE.VALUE('ORG_ID'),
11407: FND_GLOBAL.USER_ID,
11408: SYSDATE,
11409: FND_GLOBAL.USER_ID,
11410: FND_GLOBAL.LOGIN_ID,
11411: SYSDATE,
11412: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
11413: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

Line 11410: FND_GLOBAL.LOGIN_ID,

11406: FND_PROFILE.VALUE('ORG_ID'),
11407: FND_GLOBAL.USER_ID,
11408: SYSDATE,
11409: FND_GLOBAL.USER_ID,
11410: FND_GLOBAL.LOGIN_ID,
11411: SYSDATE,
11412: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
11413: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
11414: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

11408: SYSDATE,
11409: FND_GLOBAL.USER_ID,
11410: FND_GLOBAL.LOGIN_ID,
11411: SYSDATE,
11412: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
11413: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
11414: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
11415: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID)
11416: );

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

11409: FND_GLOBAL.USER_ID,
11410: FND_GLOBAL.LOGIN_ID,
11411: SYSDATE,
11412: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
11413: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
11414: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
11415: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID)
11416: );
11417: END LOOP;

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

11410: FND_GLOBAL.LOGIN_ID,
11411: SYSDATE,
11412: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
11413: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
11414: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
11415: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID)
11416: );
11417: END LOOP;
11418: END IF;

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

11411: SYSDATE,
11412: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
11413: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
11414: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
11415: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID)
11416: );
11417: END LOOP;
11418: END IF;
11419: COMMIT;