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.OKS_COPY_CONTRACT_PVT dependencies on DUAL

Line 4137: FROM DUAL;

4133: ,FND_GLOBAL.LOGIN_ID
4134: ,OKCLinesTLRecTab.OkcTL_SECURITY_GROUP_ID(i)
4135: ,OKCLinesTLRecTab.OkcTL_OKE_BOE_DESCRIPTION(i)
4136: ,OKCLinesTLRecTab.OkcTL_COGNOMEN(i)
4137: FROM DUAL;
4138:
4139: IF (P_Partial_Copy_YN = 'N') THEN
4140: EXIT WHEN GetOkcLinesTLFull%NOTFOUND;
4141: ELSIF (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) THEN

Line 6926: DUAL;

6922: ,FND_GLOBAL.USER_ID
6923: ,SYSDATE
6924: ,FND_GLOBAL.LOGIN_ID
6925: from
6926: DUAL;
6927:
6928: If (P_Partial_Copy_YN = 'N') then
6929: EXIT WHEN GetOkcPAVFull%NOTFOUND;
6930: End If;

Line 7952: DUAL;

7948: ,FND_GLOBAL.USER_ID
7949: ,SYSDATE
7950: ,FND_GLOBAL.LOGIN_ID
7951: FROM
7952: DUAL;
7953:
7954:
7955: IF (P_Partial_Copy_YN = 'N') THEN
7956: EXIT WHEN GetOkcPAFull%NOTFOUND;

Line 8365: FROM DUAL;

8361: ,SYSDATE
8362: ,FND_GLOBAL.USER_ID
8363: ,SYSDATE
8364: ,FND_GLOBAL.LOGIN_ID
8365: FROM DUAL;
8366:
8367: IF (P_Partial_Copy_YN = 'N') THEN
8368: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8369: FND_LOG.string(FND_LOG.level_statement

Line 8649: FROM DUAL;

8645: ,SYSDATE
8646: ,FND_GLOBAL.USER_ID
8647: ,SYSDATE
8648: ,FND_GLOBAL.LOGIN_ID
8649: FROM DUAL;
8650:
8651: If (P_Partial_Copy_YN = 'N') then
8652: EXIT WHEN GetOkcPRTLFull%NOTFOUND;
8653: Elsif (P_Partial_Copy_YN = 'Y' AND P_Lines_Count > 0) then

Line 8938: FROM DUAL;

8934: , SYSDATE
8935: , FND_GLOBAL.USER_ID
8936: , SYSDATE
8937: , FND_GLOBAL.LOGIN_ID
8938: FROM DUAL;
8939:
8940: /*cgopinee Bug fix for 6882512*/
8941: OKC_CTC_PVT.update_contact_stecode(p_chr_id => P_To_Chr_ID,
8942: x_return_status=>l_return_status);

Line 9097: FROM DUAL;

9093: ,SYSDATE
9094: ,FND_GLOBAL.USER_ID
9095: ,SYSDATE
9096: ,FND_GLOBAL.LOGIN_ID
9097: FROM DUAL;
9098: EXIT WHEN GetOkcOLFull%NOTFOUND;
9099: END LOOP;
9100:
9101: CLOSE GetOkcOLFull;

Line 9275: FROM DUAL;

9271: , SYSDATE
9272: , FND_GLOBAL.USER_ID
9273: , SYSDATE
9274: , FND_GLOBAL.LOGIN_ID
9275: FROM DUAL;
9276:
9277: If (P_Partial_Copy_YN = 'N') then
9278: EXIT WHEN GetOksTLFull%NOTFOUND;
9279: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 9423: FROM DUAL;

9419: , SYSDATE
9420: , FND_GLOBAL.USER_ID
9421: , SYSDATE
9422: , FND_GLOBAL.LOGIN_ID
9423: FROM DUAL;
9424:
9425: If (P_Partial_Copy_YN = 'N') then
9426: EXIT WHEN GetOksRDFull%NOTFOUND;
9427: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 9768: FROM DUAL;

9764: , SYSDATE
9765: , FND_GLOBAL.USER_ID
9766: , FND_GLOBAL.LOGIN_ID
9767: , SYSDATE
9768: FROM DUAL;
9769:
9770: If (P_Partial_Copy_YN = 'N') then
9771: EXIT WHEN GetOksQFull%NOTFOUND;
9772: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 9957: FROM DUAL;

9953: ,SYSDATE
9954: ,FND_GLOBAL.USER_ID
9955: ,SYSDATE
9956: ,FND_GLOBAL.LOGIN_ID
9957: FROM DUAL;
9958:
9959: If (P_Partial_Copy_YN = 'N') then
9960: EXIT WHEN GetOksCTZFull%NOTFOUND;
9961: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 10184: FROM DUAL;

10180: ,SYSDATE
10181: ,FND_GLOBAL.USER_ID
10182: ,SYSDATE
10183: ,FND_GLOBAL.LOGIN_ID
10184: FROM DUAL;
10185:
10186: If (P_Partial_Copy_YN = 'N') then
10187: EXIT WHEN GetOksCTFull%NOTFOUND;
10188: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 10385: FROM DUAL;

10381: ,SYSDATE
10382: ,FND_GLOBAL.USER_ID
10383: ,SYSDATE
10384: ,FND_GLOBAL.LOGIN_ID
10385: FROM DUAL;
10386:
10387: If (P_Partial_Copy_YN = 'N') then
10388: EXIT WHEN GetOksPMAFull%NOTFOUND;
10389: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 10694: FROM DUAL;

10690: ,SYSDATE
10691: ,FND_GLOBAL.USER_ID
10692: ,SYSDATE
10693: ,FND_GLOBAL.LOGIN_ID
10694: FROM DUAL;
10695:
10696: IF (P_Partial_Copy_YN = 'N') then
10697: EXIT WHEN GetOksPMSLFull%NOTFOUND;
10698: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 10912: FROM DUAL;

10908: ,SYSDATE
10909: ,FND_GLOBAL.USER_ID
10910: ,SYSDATE
10911: ,FND_GLOBAL.LOGIN_ID
10912: FROM DUAL;
10913:
10914: If (P_Partial_Copy_YN = 'N') then
10915: EXIT WHEN GetOksPMSCHFull%NOTFOUND;
10916: Elsif (P_Partial_Copy_YN = 'Y') then

Line 11188: FROM DUAL;

11184: ,SYSDATE
11185: ,FND_GLOBAL.USER_ID
11186: ,SYSDATE
11187: ,FND_GLOBAL.LOGIN_ID
11188: FROM DUAL;
11189:
11190: If (P_Partial_Copy_YN = 'N') then
11191: EXIT WHEN GetOksATTFull%NOTFOUND;
11192: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 11403: FROM DUAL;

11399: ,SYSDATE
11400: ,FND_GLOBAL.USER_ID
11401: ,SYSDATE
11402: ,FND_GLOBAL.LOGIN_ID
11403: FROM DUAL;
11404:
11405: If (P_Partial_Copy_YN = 'N') then
11406: EXIT WHEN GetOksATFull%NOTFOUND;
11407: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 11700: FROM DUAL;

11696: ,FND_GLOBAL.USER_ID
11697: ,SYSDATE
11698: ,FND_GLOBAL.USER_ID
11699: ,SYSDATE
11700: FROM DUAL;
11701:
11702: If (P_Partial_Copy_YN = 'N') then
11703: EXIT WHEN GetOksSCFull%NOTFOUND;
11704: Elsif (P_Partial_Copy_YN = 'Y') then

Line 11992: FROM DUAL;

11988: ,SYSDATE
11989: ,FND_GLOBAL.USER_ID
11990: ,SYSDATE
11991: ,FND_GLOBAL.LOGIN_ID
11992: FROM DUAL;
11993:
11994: If (P_Partial_Copy_YN = 'N') then
11995: EXIT WHEN GetOksBSCHFull%NOTFOUND;
11996: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 12664: FROM DUAL;

12660: ,SYSDATE
12661: ,FND_GLOBAL.USER_ID
12662: ,SYSDATE
12663: ,FND_GLOBAL.LOGIN_ID
12664: FROM DUAL;
12665:
12666: If (P_Partial_Copy_YN = 'N') then
12667: EXIT WHEN GetOksSLFull%NOTFOUND;
12668: ElsIf (P_Partial_Copy_YN = 'Y') then

Line 13341: FROM DUAL;

13337: ,FND_GLOBAL.USER_ID
13338: ,SYSDATE
13339: ,FND_GLOBAL.USER_ID
13340: ,SYSDATE
13341: FROM DUAL;
13342:
13343: IF (P_Partial_Copy_YN = 'N') then
13344: EXIT WHEN GetOksLEFull%NOTFOUND;
13345: Elsif (P_Partial_Copy_YN = 'Y') then

Line 18432: DUAL;

18428: ,SYSDATE
18429: ,FND_GLOBAL.USER_ID
18430: ,FND_GLOBAL.LOGIN_ID
18431: FROM
18432: DUAL;
18433:
18434: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
18435: FND_LOG.string(FND_LOG.level_statement
18436: ,l_module_name

Line 18663: DUAL

18659: ,FND_GLOBAL.USER_ID
18660: ,FND_GLOBAL.LOGIN_ID
18661: ,OKCOKSLinesRecTab.OksB_COUNTER_VALUE_ID(i)
18662: FROM
18663: DUAL
18664: WHERE
18665: OKCOKSLinesRecTab.OksB_OldOksLineID(i) IS NOT NULL;
18666:
18667: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then

Line 18746: DUAL

18742: ,SYSDATE
18743: ,FND_GLOBAL.USER_ID
18744: ,FND_GLOBAL.LOGIN_ID
18745: FROM
18746: DUAL
18747: where OKCOKSLinesRecTab.OkcI_OldOkcItemID(i) IS NOT NULL;
18748:
18749: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
18750: FND_LOG.string(FND_LOG.level_statement

Line 23928: DUAL;

23924: ,SYSDATE
23925: ,FND_GLOBAL.USER_ID
23926: ,FND_GLOBAL.LOGIN_ID
23927: FROM
23928: DUAL;
23929:
23930: If (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
23931: FND_LOG.string(FND_LOG.level_statement
23932: ,l_module_name

Line 24151: DUAL

24147: ,FND_GLOBAL.USER_ID
24148: ,FND_GLOBAL.LOGIN_ID
24149: ,OKCOKSLinesRecTab.OksB_COUNTER_VALUE_ID(i)
24150: FROM
24151: DUAL
24152: WHERE
24153: OKCOKSLinesRecTab.OksB_OldOksLineID(i) IS NOT NULL;
24154:
24155: If (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then

Line 24217: DUAL

24213: ,SYSDATE
24214: ,FND_GLOBAL.USER_ID
24215: ,FND_GLOBAL.LOGIN_ID
24216: FROM
24217: DUAL
24218: where OKCOKSLinesRecTab.OkcI_OldOkcItemID(i) IS NOT NULL;
24219:
24220: If (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
24221: FND_LOG.string(FND_LOG.level_statement