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.

[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on FND_GLOBAL

Line 601: l_current_user_id NUMBER := FND_GLOBAL.USER_ID;

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

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

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

Line 11369: FND_GLOBAL.USER_ID,

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

Line 11371: FND_GLOBAL.USER_ID,

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

Line 11372: FND_GLOBAL.LOGIN_ID,

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

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

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

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

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

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

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

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

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

Line 11408: FND_GLOBAL.USER_ID,

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

Line 11410: FND_GLOBAL.USER_ID,

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

Line 11411: FND_GLOBAL.LOGIN_ID,

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

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

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

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

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

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

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

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

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