DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on DUAL

Line 4100: FROM DUAL;

4096: ,FND_GLOBAL.LOGIN_ID
4097: ,OKCLinesTLRecTab.OkcTL_SECURITY_GROUP_ID(i)
4098: ,OKCLinesTLRecTab.OkcTL_OKE_BOE_DESCRIPTION(i)
4099: ,OKCLinesTLRecTab.OkcTL_COGNOMEN(i)
4100: FROM DUAL;
4101:
4102: IF (P_Partial_Copy_YN = 'N') THEN
4103: EXIT WHEN GetOkcLinesTLFull%NOTFOUND;
4104: ELSIF (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) THEN

Line 6889: DUAL;

6885: ,FND_GLOBAL.USER_ID
6886: ,SYSDATE
6887: ,FND_GLOBAL.LOGIN_ID
6888: from
6889: DUAL;
6890:
6891: If (P_Partial_Copy_YN = 'N') then
6892: EXIT WHEN GetOkcPAVFull%NOTFOUND;
6893: End If;

Line 7915: DUAL;

7911: ,FND_GLOBAL.USER_ID
7912: ,SYSDATE
7913: ,FND_GLOBAL.LOGIN_ID
7914: FROM
7915: DUAL;
7916:
7917:
7918: IF (P_Partial_Copy_YN = 'N') THEN
7919: EXIT WHEN GetOkcPAFull%NOTFOUND;

Line 8328: FROM DUAL;

8324: ,SYSDATE
8325: ,FND_GLOBAL.USER_ID
8326: ,SYSDATE
8327: ,FND_GLOBAL.LOGIN_ID
8328: FROM DUAL;
8329:
8330: IF (P_Partial_Copy_YN = 'N') THEN
8331: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8332: FND_LOG.string(FND_LOG.level_statement

Line 8612: FROM DUAL;

8608: ,SYSDATE
8609: ,FND_GLOBAL.USER_ID
8610: ,SYSDATE
8611: ,FND_GLOBAL.LOGIN_ID
8612: FROM DUAL;
8613:
8614: If (P_Partial_Copy_YN = 'N') then
8615: EXIT WHEN GetOkcPRTLFull%NOTFOUND;
8616: Elsif (P_Partial_Copy_YN = 'Y' AND P_Lines_Count > 0) then

Line 8901: FROM DUAL;

8897: , SYSDATE
8898: , FND_GLOBAL.USER_ID
8899: , SYSDATE
8900: , FND_GLOBAL.LOGIN_ID
8901: FROM DUAL;
8902:
8903: IF (P_Partial_Copy_YN = 'N') then
8904: EXIT WHEN GetOkcCFull%NOTFOUND;
8905: ELSIF (P_Partial_Copy_YN = 'Y' AND P_Lines_Count > 0) then

Line 9052: FROM DUAL;

9048: ,SYSDATE
9049: ,FND_GLOBAL.USER_ID
9050: ,SYSDATE
9051: ,FND_GLOBAL.LOGIN_ID
9052: FROM DUAL;
9053: EXIT WHEN GetOkcOLFull%NOTFOUND;
9054: END LOOP;
9055:
9056: CLOSE GetOkcOLFull;

Line 9230: FROM DUAL;

9226: , SYSDATE
9227: , FND_GLOBAL.USER_ID
9228: , SYSDATE
9229: , FND_GLOBAL.LOGIN_ID
9230: FROM DUAL;
9231:
9232: If (P_Partial_Copy_YN = 'N') then
9233: EXIT WHEN GetOksTLFull%NOTFOUND;
9234: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 9378: FROM DUAL;

9374: , SYSDATE
9375: , FND_GLOBAL.USER_ID
9376: , SYSDATE
9377: , FND_GLOBAL.LOGIN_ID
9378: FROM DUAL;
9379:
9380: If (P_Partial_Copy_YN = 'N') then
9381: EXIT WHEN GetOksRDFull%NOTFOUND;
9382: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 9723: FROM DUAL;

9719: , SYSDATE
9720: , FND_GLOBAL.USER_ID
9721: , FND_GLOBAL.LOGIN_ID
9722: , SYSDATE
9723: FROM DUAL;
9724:
9725: If (P_Partial_Copy_YN = 'N') then
9726: EXIT WHEN GetOksQFull%NOTFOUND;
9727: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 9912: FROM DUAL;

9908: ,SYSDATE
9909: ,FND_GLOBAL.USER_ID
9910: ,SYSDATE
9911: ,FND_GLOBAL.LOGIN_ID
9912: FROM DUAL;
9913:
9914: If (P_Partial_Copy_YN = 'N') then
9915: EXIT WHEN GetOksCTZFull%NOTFOUND;
9916: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 10139: FROM DUAL;

10135: ,SYSDATE
10136: ,FND_GLOBAL.USER_ID
10137: ,SYSDATE
10138: ,FND_GLOBAL.LOGIN_ID
10139: FROM DUAL;
10140:
10141: If (P_Partial_Copy_YN = 'N') then
10142: EXIT WHEN GetOksCTFull%NOTFOUND;
10143: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 10340: FROM DUAL;

10336: ,SYSDATE
10337: ,FND_GLOBAL.USER_ID
10338: ,SYSDATE
10339: ,FND_GLOBAL.LOGIN_ID
10340: FROM DUAL;
10341:
10342: If (P_Partial_Copy_YN = 'N') then
10343: EXIT WHEN GetOksPMAFull%NOTFOUND;
10344: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 10649: FROM DUAL;

10645: ,SYSDATE
10646: ,FND_GLOBAL.USER_ID
10647: ,SYSDATE
10648: ,FND_GLOBAL.LOGIN_ID
10649: FROM DUAL;
10650:
10651: IF (P_Partial_Copy_YN = 'N') then
10652: EXIT WHEN GetOksPMSLFull%NOTFOUND;
10653: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 10867: FROM DUAL;

10863: ,SYSDATE
10864: ,FND_GLOBAL.USER_ID
10865: ,SYSDATE
10866: ,FND_GLOBAL.LOGIN_ID
10867: FROM DUAL;
10868:
10869: If (P_Partial_Copy_YN = 'N') then
10870: EXIT WHEN GetOksPMSCHFull%NOTFOUND;
10871: Elsif (P_Partial_Copy_YN = 'Y') then

Line 11143: FROM DUAL;

11139: ,SYSDATE
11140: ,FND_GLOBAL.USER_ID
11141: ,SYSDATE
11142: ,FND_GLOBAL.LOGIN_ID
11143: FROM DUAL;
11144:
11145: If (P_Partial_Copy_YN = 'N') then
11146: EXIT WHEN GetOksATTFull%NOTFOUND;
11147: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 11358: FROM DUAL;

11354: ,SYSDATE
11355: ,FND_GLOBAL.USER_ID
11356: ,SYSDATE
11357: ,FND_GLOBAL.LOGIN_ID
11358: FROM DUAL;
11359:
11360: If (P_Partial_Copy_YN = 'N') then
11361: EXIT WHEN GetOksATFull%NOTFOUND;
11362: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 11655: FROM DUAL;

11651: ,FND_GLOBAL.USER_ID
11652: ,SYSDATE
11653: ,FND_GLOBAL.USER_ID
11654: ,SYSDATE
11655: FROM DUAL;
11656:
11657: If (P_Partial_Copy_YN = 'N') then
11658: EXIT WHEN GetOksSCFull%NOTFOUND;
11659: Elsif (P_Partial_Copy_YN = 'Y') then

Line 11947: FROM DUAL;

11943: ,SYSDATE
11944: ,FND_GLOBAL.USER_ID
11945: ,SYSDATE
11946: ,FND_GLOBAL.LOGIN_ID
11947: FROM DUAL;
11948:
11949: If (P_Partial_Copy_YN = 'N') then
11950: EXIT WHEN GetOksBSCHFull%NOTFOUND;
11951: Elsif (P_Partial_Copy_YN = 'Y' and P_Lines_Count > 0) then

Line 12619: FROM DUAL;

12615: ,SYSDATE
12616: ,FND_GLOBAL.USER_ID
12617: ,SYSDATE
12618: ,FND_GLOBAL.LOGIN_ID
12619: FROM DUAL;
12620:
12621: If (P_Partial_Copy_YN = 'N') then
12622: EXIT WHEN GetOksSLFull%NOTFOUND;
12623: ElsIf (P_Partial_Copy_YN = 'Y') then

Line 13296: FROM DUAL;

13292: ,FND_GLOBAL.USER_ID
13293: ,SYSDATE
13294: ,FND_GLOBAL.USER_ID
13295: ,SYSDATE
13296: FROM DUAL;
13297:
13298: IF (P_Partial_Copy_YN = 'N') then
13299: EXIT WHEN GetOksLEFull%NOTFOUND;
13300: Elsif (P_Partial_Copy_YN = 'Y') then

Line 18343: DUAL;

18339: ,SYSDATE
18340: ,FND_GLOBAL.USER_ID
18341: ,FND_GLOBAL.LOGIN_ID
18342: FROM
18343: DUAL;
18344:
18345: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
18346: FND_LOG.string(FND_LOG.level_statement
18347: ,l_module_name

Line 18572: DUAL

18568: ,SYSDATE
18569: ,FND_GLOBAL.USER_ID
18570: ,FND_GLOBAL.LOGIN_ID
18571: FROM
18572: DUAL
18573: WHERE
18574: OKCOKSLinesRecTab.OksB_OldOksLineID(i) IS NOT NULL;
18575:
18576: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then

Line 18655: DUAL

18651: ,SYSDATE
18652: ,FND_GLOBAL.USER_ID
18653: ,FND_GLOBAL.LOGIN_ID
18654: FROM
18655: DUAL
18656: where OKCOKSLinesRecTab.OkcI_OldOkcItemID(i) IS NOT NULL;
18657:
18658: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
18659: FND_LOG.string(FND_LOG.level_statement

Line 23773: DUAL;

23769: ,SYSDATE
23770: ,FND_GLOBAL.USER_ID
23771: ,FND_GLOBAL.LOGIN_ID
23772: FROM
23773: DUAL;
23774:
23775: If (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
23776: FND_LOG.string(FND_LOG.level_statement
23777: ,l_module_name

Line 23994: DUAL

23990: ,SYSDATE
23991: ,FND_GLOBAL.USER_ID
23992: ,FND_GLOBAL.LOGIN_ID
23993: FROM
23994: DUAL
23995: WHERE
23996: OKCOKSLinesRecTab.OksB_OldOksLineID(i) IS NOT NULL;
23997:
23998: If (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then

Line 24060: DUAL

24056: ,SYSDATE
24057: ,FND_GLOBAL.USER_ID
24058: ,FND_GLOBAL.LOGIN_ID
24059: FROM
24060: DUAL
24061: where OKCOKSLinesRecTab.OkcI_OldOkcItemID(i) IS NOT NULL;
24062:
24063: If (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
24064: FND_LOG.string(FND_LOG.level_statement