DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on FND_GLOBAL

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

551: FROM okc_k_grpings_v cgcv,
552: okc_k_groups_b cgpv
553: WHERE cgcv.included_chr_id = p_from_chr_id
554: AND cgcv.cgp_parent_id = cgpv.id
555: AND (cgpv.public_yn = 'Y' OR cgpv.user_id = fnd_global.user_id);
556:
557: BEGIN
558: x_return_status := l_return_status;
559: FOR l_c_grpings IN c_grpings LOOP

Line 4092: ,FND_GLOBAL.USER_ID

4088: ,OKCLinesTLRecTab.OkcTL_NAME(i)
4089: ,OKCLinesTLRecTab.OkcTL_COMMENTS(i)
4090: ,OKCLinesTLRecTab.OkcTL_ITEM_DESCRIPTION(i)
4091: ,OKCLinesTLRecTab.OkcTL_BLOCK23TEXT(i)
4092: ,FND_GLOBAL.USER_ID
4093: ,SYSDATE
4094: ,FND_GLOBAL.USER_ID
4095: ,SYSDATE
4096: ,FND_GLOBAL.LOGIN_ID

Line 4094: ,FND_GLOBAL.USER_ID

4090: ,OKCLinesTLRecTab.OkcTL_ITEM_DESCRIPTION(i)
4091: ,OKCLinesTLRecTab.OkcTL_BLOCK23TEXT(i)
4092: ,FND_GLOBAL.USER_ID
4093: ,SYSDATE
4094: ,FND_GLOBAL.USER_ID
4095: ,SYSDATE
4096: ,FND_GLOBAL.LOGIN_ID
4097: ,OKCLinesTLRecTab.OkcTL_SECURITY_GROUP_ID(i)
4098: ,OKCLinesTLRecTab.OkcTL_OKE_BOE_DESCRIPTION(i)

Line 4096: ,FND_GLOBAL.LOGIN_ID

4092: ,FND_GLOBAL.USER_ID
4093: ,SYSDATE
4094: ,FND_GLOBAL.USER_ID
4095: ,SYSDATE
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;

Line 6883: ,FND_GLOBAL.USER_ID

6879: ,OkcPAVRecTab.OkcPAV_PROGRAM_ID(i)
6880: ,OkcPAVRecTab.OkcPAV_PROGRAM_UPDATE_DATE(i)
6881: ,OkcPAVRecTab.OkcPAV_REQUEST_ID(i)
6882: ,OkcPAVRecTab.OkcPAV_OBJECT_VERSION_NUMBER(i)
6883: ,FND_GLOBAL.USER_ID
6884: ,SYSDATE
6885: ,FND_GLOBAL.USER_ID
6886: ,SYSDATE
6887: ,FND_GLOBAL.LOGIN_ID

Line 6885: ,FND_GLOBAL.USER_ID

6881: ,OkcPAVRecTab.OkcPAV_REQUEST_ID(i)
6882: ,OkcPAVRecTab.OkcPAV_OBJECT_VERSION_NUMBER(i)
6883: ,FND_GLOBAL.USER_ID
6884: ,SYSDATE
6885: ,FND_GLOBAL.USER_ID
6886: ,SYSDATE
6887: ,FND_GLOBAL.LOGIN_ID
6888: from
6889: DUAL;

Line 6887: ,FND_GLOBAL.LOGIN_ID

6883: ,FND_GLOBAL.USER_ID
6884: ,SYSDATE
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

Line 7909: ,FND_GLOBAL.USER_ID

7905: ,okcPARecTab.OkcPA_SUBSTITUTION_ATTRIBUTE(i)
7906: ,okcPARecTab.OkcPA_PRORATION_TYPE_CODE(i)
7907: ,okcPARecTab.OkcPA_INCLUDE_ON_RETURNS_FLAG(i)
7908: ,okcPARecTab.OkcPA_REBATE_TRXN_TYPE_CODE(i)
7909: ,FND_GLOBAL.USER_ID
7910: ,SYSDATE
7911: ,FND_GLOBAL.USER_ID
7912: ,SYSDATE
7913: ,FND_GLOBAL.LOGIN_ID

Line 7911: ,FND_GLOBAL.USER_ID

7907: ,okcPARecTab.OkcPA_INCLUDE_ON_RETURNS_FLAG(i)
7908: ,okcPARecTab.OkcPA_REBATE_TRXN_TYPE_CODE(i)
7909: ,FND_GLOBAL.USER_ID
7910: ,SYSDATE
7911: ,FND_GLOBAL.USER_ID
7912: ,SYSDATE
7913: ,FND_GLOBAL.LOGIN_ID
7914: FROM
7915: DUAL;

Line 7913: ,FND_GLOBAL.LOGIN_ID

7909: ,FND_GLOBAL.USER_ID
7910: ,SYSDATE
7911: ,FND_GLOBAL.USER_ID
7912: ,SYSDATE
7913: ,FND_GLOBAL.LOGIN_ID
7914: FROM
7915: DUAL;
7916:
7917:

Line 8323: ,FND_GLOBAL.USER_ID

8319: ,OkcPRBRecTab.OkcPRB_CUST_ACCT_ID(i)
8320: ,OkcPRBRecTab.OkcPRB_ORIG_SYSTEM_ID1(i)
8321: ,OkcPRBRecTab.OkcPRB_ORIG_SYSTEM_REFERENCE1(i)
8322: ,OkcPRBRecTab.OkcPRB_ORIG_SYSTEM_SOURCE_CODE(i)
8323: ,FND_GLOBAL.USER_ID
8324: ,SYSDATE
8325: ,FND_GLOBAL.USER_ID
8326: ,SYSDATE
8327: ,FND_GLOBAL.LOGIN_ID

Line 8325: ,FND_GLOBAL.USER_ID

8321: ,OkcPRBRecTab.OkcPRB_ORIG_SYSTEM_REFERENCE1(i)
8322: ,OkcPRBRecTab.OkcPRB_ORIG_SYSTEM_SOURCE_CODE(i)
8323: ,FND_GLOBAL.USER_ID
8324: ,SYSDATE
8325: ,FND_GLOBAL.USER_ID
8326: ,SYSDATE
8327: ,FND_GLOBAL.LOGIN_ID
8328: FROM DUAL;
8329:

Line 8327: ,FND_GLOBAL.LOGIN_ID

8323: ,FND_GLOBAL.USER_ID
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

Line 8607: ,FND_GLOBAL.USER_ID

8603: ,OkcPRTLRecTab.OkcPRTL_SFWT_FLAG(i)
8604: ,OkcPRTLRecTab.OkcPRTL_COGNOMEN(i)
8605: ,OkcPRTLRecTab.OkcPRTL_ALIAS(i)
8606: ,OkcPRTLRecTab.OkcPRTL_SECURITY_GROUP_ID(i)
8607: ,FND_GLOBAL.USER_ID
8608: ,SYSDATE
8609: ,FND_GLOBAL.USER_ID
8610: ,SYSDATE
8611: ,FND_GLOBAL.LOGIN_ID

Line 8609: ,FND_GLOBAL.USER_ID

8605: ,OkcPRTLRecTab.OkcPRTL_ALIAS(i)
8606: ,OkcPRTLRecTab.OkcPRTL_SECURITY_GROUP_ID(i)
8607: ,FND_GLOBAL.USER_ID
8608: ,SYSDATE
8609: ,FND_GLOBAL.USER_ID
8610: ,SYSDATE
8611: ,FND_GLOBAL.LOGIN_ID
8612: FROM DUAL;
8613:

Line 8611: ,FND_GLOBAL.LOGIN_ID

8607: ,FND_GLOBAL.USER_ID
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;

Line 8896: , FND_GLOBAL.USER_ID

8892: , OkcCRecTab.OkcC_END_DATE(i)
8893: , OkcCRecTab.OkcC_PRIMARY_YN(i)
8894: , OkcCRecTab.OkcC_RESOURCE_CLASS(i)
8895: , OkcCRecTab.OkcC_SALES_GROUP_ID(i)
8896: , FND_GLOBAL.USER_ID
8897: , SYSDATE
8898: , FND_GLOBAL.USER_ID
8899: , SYSDATE
8900: , FND_GLOBAL.LOGIN_ID

Line 8898: , FND_GLOBAL.USER_ID

8894: , OkcCRecTab.OkcC_RESOURCE_CLASS(i)
8895: , OkcCRecTab.OkcC_SALES_GROUP_ID(i)
8896: , FND_GLOBAL.USER_ID
8897: , SYSDATE
8898: , FND_GLOBAL.USER_ID
8899: , SYSDATE
8900: , FND_GLOBAL.LOGIN_ID
8901: FROM DUAL;
8902:

Line 8900: , FND_GLOBAL.LOGIN_ID

8896: , FND_GLOBAL.USER_ID
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;

Line 9047: ,FND_GLOBAL.USER_ID

9043: ,OkcOLRecTab.OkcOLSECURITY_GROUP_ID(i)
9044: ,OkcOLRecTab.OkcOLMESSAGE_CODE(i)
9045: ,OkcOLRecTab.OkcOLPARENT_OLE_ID(i)
9046: ,OkcOLRecTab.OkcOLACTIVE_YN(i)
9047: ,FND_GLOBAL.USER_ID
9048: ,SYSDATE
9049: ,FND_GLOBAL.USER_ID
9050: ,SYSDATE
9051: ,FND_GLOBAL.LOGIN_ID

Line 9049: ,FND_GLOBAL.USER_ID

9045: ,OkcOLRecTab.OkcOLPARENT_OLE_ID(i)
9046: ,OkcOLRecTab.OkcOLACTIVE_YN(i)
9047: ,FND_GLOBAL.USER_ID
9048: ,SYSDATE
9049: ,FND_GLOBAL.USER_ID
9050: ,SYSDATE
9051: ,FND_GLOBAL.LOGIN_ID
9052: FROM DUAL;
9053: EXIT WHEN GetOkcOLFull%NOTFOUND;

Line 9051: ,FND_GLOBAL.LOGIN_ID

9047: ,FND_GLOBAL.USER_ID
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:

Line 9225: , FND_GLOBAL.USER_ID

9221: , OksTLRecTab.OksTL_IB_TRX_DETAILS(i)
9222: , OksTLRecTab.OksTL_STATUS_TEXT(i)
9223: , OksTLRecTab.OksTL_REACT_TIME_NAME(i)
9224: , OksTLRecTab.OksTL_SECURITY_GROUP_ID(i)
9225: , FND_GLOBAL.USER_ID
9226: , SYSDATE
9227: , FND_GLOBAL.USER_ID
9228: , SYSDATE
9229: , FND_GLOBAL.LOGIN_ID

Line 9227: , FND_GLOBAL.USER_ID

9223: , OksTLRecTab.OksTL_REACT_TIME_NAME(i)
9224: , OksTLRecTab.OksTL_SECURITY_GROUP_ID(i)
9225: , FND_GLOBAL.USER_ID
9226: , SYSDATE
9227: , FND_GLOBAL.USER_ID
9228: , SYSDATE
9229: , FND_GLOBAL.LOGIN_ID
9230: FROM DUAL;
9231:

Line 9229: , FND_GLOBAL.LOGIN_ID

9225: , FND_GLOBAL.USER_ID
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;

Line 9373: , FND_GLOBAL.USER_ID

9369: , OksRDRecTab.OksRD_CODE_COMBINATION_ID(i)
9370: , OksRDRecTab.OksRD_PERCENT(i)
9371: , OksRDRecTab.OksRD_OBJECT_VERSION_NUMBER(i)
9372: , OksRDRecTab.OksRD_SECURITY_GROUP_ID(i)
9373: , FND_GLOBAL.USER_ID
9374: , SYSDATE
9375: , FND_GLOBAL.USER_ID
9376: , SYSDATE
9377: , FND_GLOBAL.LOGIN_ID

Line 9375: , FND_GLOBAL.USER_ID

9371: , OksRDRecTab.OksRD_OBJECT_VERSION_NUMBER(i)
9372: , OksRDRecTab.OksRD_SECURITY_GROUP_ID(i)
9373: , FND_GLOBAL.USER_ID
9374: , SYSDATE
9375: , FND_GLOBAL.USER_ID
9376: , SYSDATE
9377: , FND_GLOBAL.LOGIN_ID
9378: FROM DUAL;
9379:

Line 9377: , FND_GLOBAL.LOGIN_ID

9373: , FND_GLOBAL.USER_ID
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;

Line 9718: , FND_GLOBAL.USER_ID

9714: , OksQRecTab.OksQ_LIST_TYPE_CODE(i)
9715: , OksQRecTab.OksQ_QUAL_ATTRVALUE_FROM_NUM(i)
9716: , OksQRecTab.OksQ_QUAL_ATTRVALUE_TO_NUM(i)
9717: , OksQRecTab.OksQ_SECURITY_GROUP_ID(i)
9718: , FND_GLOBAL.USER_ID
9719: , SYSDATE
9720: , FND_GLOBAL.USER_ID
9721: , FND_GLOBAL.LOGIN_ID
9722: , SYSDATE

Line 9720: , FND_GLOBAL.USER_ID

9716: , OksQRecTab.OksQ_QUAL_ATTRVALUE_TO_NUM(i)
9717: , OksQRecTab.OksQ_SECURITY_GROUP_ID(i)
9718: , FND_GLOBAL.USER_ID
9719: , SYSDATE
9720: , FND_GLOBAL.USER_ID
9721: , FND_GLOBAL.LOGIN_ID
9722: , SYSDATE
9723: FROM DUAL;
9724:

Line 9721: , FND_GLOBAL.LOGIN_ID

9717: , OksQRecTab.OksQ_SECURITY_GROUP_ID(i)
9718: , FND_GLOBAL.USER_ID
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

Line 9907: ,FND_GLOBAL.USER_ID

9903: ,OksCTZRecTab.OksCTZ_OBJECT_VERSION_NUMBER(i)
9904: ,OksCTZRecTab.OksCTZ_ORIG_SYSTEM_ID1(i)
9905: ,OksCTZRecTab.OksCTZ_ORIG_SYSTEM_SOURCE_CODE(i)
9906: ,OksCTZRecTab.OksCTZ_ORIG_SYSTEM_REFERENCE1(i)
9907: ,FND_GLOBAL.USER_ID
9908: ,SYSDATE
9909: ,FND_GLOBAL.USER_ID
9910: ,SYSDATE
9911: ,FND_GLOBAL.LOGIN_ID

Line 9909: ,FND_GLOBAL.USER_ID

9905: ,OksCTZRecTab.OksCTZ_ORIG_SYSTEM_SOURCE_CODE(i)
9906: ,OksCTZRecTab.OksCTZ_ORIG_SYSTEM_REFERENCE1(i)
9907: ,FND_GLOBAL.USER_ID
9908: ,SYSDATE
9909: ,FND_GLOBAL.USER_ID
9910: ,SYSDATE
9911: ,FND_GLOBAL.LOGIN_ID
9912: FROM DUAL;
9913:

Line 9911: ,FND_GLOBAL.LOGIN_ID

9907: ,FND_GLOBAL.USER_ID
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;

Line 10134: ,FND_GLOBAL.USER_ID

10130: ,OksCTRecTab.OksCT_OBJECT_VERSION_NUMBER(i)
10131: ,OksCTRecTab.OksCT_PROGRAM_ID(i)
10132: ,OksCTRecTab.OksCT_PROGRAM_UPDATE_DATE(i)
10133: ,OksCTRecTab.OksCT_REQUEST_ID(i)
10134: ,FND_GLOBAL.USER_ID
10135: ,SYSDATE
10136: ,FND_GLOBAL.USER_ID
10137: ,SYSDATE
10138: ,FND_GLOBAL.LOGIN_ID

Line 10136: ,FND_GLOBAL.USER_ID

10132: ,OksCTRecTab.OksCT_PROGRAM_UPDATE_DATE(i)
10133: ,OksCTRecTab.OksCT_REQUEST_ID(i)
10134: ,FND_GLOBAL.USER_ID
10135: ,SYSDATE
10136: ,FND_GLOBAL.USER_ID
10137: ,SYSDATE
10138: ,FND_GLOBAL.LOGIN_ID
10139: FROM DUAL;
10140:

Line 10138: ,FND_GLOBAL.LOGIN_ID

10134: ,FND_GLOBAL.USER_ID
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;

Line 10335: ,FND_GLOBAL.USER_ID

10331: ,OksPMARecTab.OksPMA_REQUEST_ID(i)
10332: ,OksPMARecTab.OksPMA_ORIG_SYSTEM_ID1(i)
10333: ,OksPMARecTab.OksPMA_ORIG_SYSTEM_SOURCE_CODE(i)
10334: ,OksPMARecTab.OksPMA_ORIG_SYSTEM_REFERENCE1(i)
10335: ,FND_GLOBAL.USER_ID
10336: ,SYSDATE
10337: ,FND_GLOBAL.USER_ID
10338: ,SYSDATE
10339: ,FND_GLOBAL.LOGIN_ID

Line 10337: ,FND_GLOBAL.USER_ID

10333: ,OksPMARecTab.OksPMA_ORIG_SYSTEM_SOURCE_CODE(i)
10334: ,OksPMARecTab.OksPMA_ORIG_SYSTEM_REFERENCE1(i)
10335: ,FND_GLOBAL.USER_ID
10336: ,SYSDATE
10337: ,FND_GLOBAL.USER_ID
10338: ,SYSDATE
10339: ,FND_GLOBAL.LOGIN_ID
10340: FROM DUAL;
10341:

Line 10339: ,FND_GLOBAL.LOGIN_ID

10335: ,FND_GLOBAL.USER_ID
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;

Line 10644: ,FND_GLOBAL.USER_ID

10640: ,OksPMSLRecTab.OksPMSL_REQUEST_ID(i)
10641: ,OksPMSLRecTab.OksPMSL_ORIG_SYSTEM_ID1(i)
10642: ,OksPMSLRecTab.OksPMSL_ORIG_SYS_SOURCE_CODE(i)
10643: ,OksPMSLRecTab.OksPMSL_ORIG_SYS_REFERENCE1(i)
10644: ,FND_GLOBAL.USER_ID
10645: ,SYSDATE
10646: ,FND_GLOBAL.USER_ID
10647: ,SYSDATE
10648: ,FND_GLOBAL.LOGIN_ID

Line 10646: ,FND_GLOBAL.USER_ID

10642: ,OksPMSLRecTab.OksPMSL_ORIG_SYS_SOURCE_CODE(i)
10643: ,OksPMSLRecTab.OksPMSL_ORIG_SYS_REFERENCE1(i)
10644: ,FND_GLOBAL.USER_ID
10645: ,SYSDATE
10646: ,FND_GLOBAL.USER_ID
10647: ,SYSDATE
10648: ,FND_GLOBAL.LOGIN_ID
10649: FROM DUAL;
10650:

Line 10648: ,FND_GLOBAL.LOGIN_ID

10644: ,FND_GLOBAL.USER_ID
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;

Line 10862: ,FND_GLOBAL.USER_ID

10858: ,OksPMSCHRecTab.OksPMSCH_PROG_APPLICATION_ID(i)
10859: ,OksPMSCHRecTab.OksPMSCH_PROGRAM_ID(i)
10860: ,OksPMSCHRecTab.OksPMSCH_PROGRAM_UPDATE_DATE(i)
10861: ,OksPMSCHRecTab.OksPMSCH_REQUEST_ID(i)
10862: ,FND_GLOBAL.USER_ID
10863: ,SYSDATE
10864: ,FND_GLOBAL.USER_ID
10865: ,SYSDATE
10866: ,FND_GLOBAL.LOGIN_ID

Line 10864: ,FND_GLOBAL.USER_ID

10860: ,OksPMSCHRecTab.OksPMSCH_PROGRAM_UPDATE_DATE(i)
10861: ,OksPMSCHRecTab.OksPMSCH_REQUEST_ID(i)
10862: ,FND_GLOBAL.USER_ID
10863: ,SYSDATE
10864: ,FND_GLOBAL.USER_ID
10865: ,SYSDATE
10866: ,FND_GLOBAL.LOGIN_ID
10867: FROM DUAL;
10868:

Line 10866: ,FND_GLOBAL.LOGIN_ID

10862: ,FND_GLOBAL.USER_ID
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;

Line 11138: ,FND_GLOBAL.USER_ID

11134: ,OksATTRecTab.OksATT_OBJECT_VERSION_NUMBER(i)
11135: ,OksATTRecTab.OksATT_ORIG_SYSTEM_ID1(i)
11136: ,OksATTRecTab.OksATT_ORIG_SYSTEM_SOURCE_CODE(i)
11137: ,OksATTRecTab.OksATT_ORIG_SYSTEM_REFERENCE1(i)
11138: ,FND_GLOBAL.USER_ID
11139: ,SYSDATE
11140: ,FND_GLOBAL.USER_ID
11141: ,SYSDATE
11142: ,FND_GLOBAL.LOGIN_ID

Line 11140: ,FND_GLOBAL.USER_ID

11136: ,OksATTRecTab.OksATT_ORIG_SYSTEM_SOURCE_CODE(i)
11137: ,OksATTRecTab.OksATT_ORIG_SYSTEM_REFERENCE1(i)
11138: ,FND_GLOBAL.USER_ID
11139: ,SYSDATE
11140: ,FND_GLOBAL.USER_ID
11141: ,SYSDATE
11142: ,FND_GLOBAL.LOGIN_ID
11143: FROM DUAL;
11144:

Line 11142: ,FND_GLOBAL.LOGIN_ID

11138: ,FND_GLOBAL.USER_ID
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;

Line 11353: ,FND_GLOBAL.USER_ID

11349: ,OksATRecTab.OksAT_PROGRAM_ID(i)
11350: ,OksATRecTab.OksAT_PROGRAM_UPDATE_DATE(i)
11351: ,OksATRecTab.OksAT_REQUEST_ID(i)
11352: ,OksATRecTab.OksAT_OBJECT_VERSION_NUMBER(i)
11353: ,FND_GLOBAL.USER_ID
11354: ,SYSDATE
11355: ,FND_GLOBAL.USER_ID
11356: ,SYSDATE
11357: ,FND_GLOBAL.LOGIN_ID

Line 11355: ,FND_GLOBAL.USER_ID

11351: ,OksATRecTab.OksAT_REQUEST_ID(i)
11352: ,OksATRecTab.OksAT_OBJECT_VERSION_NUMBER(i)
11353: ,FND_GLOBAL.USER_ID
11354: ,SYSDATE
11355: ,FND_GLOBAL.USER_ID
11356: ,SYSDATE
11357: ,FND_GLOBAL.LOGIN_ID
11358: FROM DUAL;
11359:

Line 11357: ,FND_GLOBAL.LOGIN_ID

11353: ,FND_GLOBAL.USER_ID
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;

Line 11651: ,FND_GLOBAL.USER_ID

11647: ,OksSCRecTab.OksSC_SALES_CREDIT_TYPE_ID2(i)
11648: ,OksSCRecTab.OksSC_OBJECT_VERSION_NUMBER(i)
11649: ,OksSCRecTab.OksSC_SECURITY_GROUP_ID(i)
11650: ,OksSCRecTab.OksSC_SALES_GROUP_ID(i)
11651: ,FND_GLOBAL.USER_ID
11652: ,SYSDATE
11653: ,FND_GLOBAL.USER_ID
11654: ,SYSDATE
11655: FROM DUAL;

Line 11653: ,FND_GLOBAL.USER_ID

11649: ,OksSCRecTab.OksSC_SECURITY_GROUP_ID(i)
11650: ,OksSCRecTab.OksSC_SALES_GROUP_ID(i)
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

Line 11942: ,FND_GLOBAL.USER_ID

11938: ,OksBSCHRecTab.OksBSCH_PROGRAM_UPDATE_DATE(i)
11939: ,OksBSCHRecTab.OksBSCH_REQUEST_ID(i)
11940: ,OksBSCHRecTab.OksBSCH_SECURITY_GROUP_ID(i)
11941: ,OksBSCHRecTab.OksBSCH_OBJECT_VERSION_NUMBER(i)
11942: ,FND_GLOBAL.USER_ID
11943: ,SYSDATE
11944: ,FND_GLOBAL.USER_ID
11945: ,SYSDATE
11946: ,FND_GLOBAL.LOGIN_ID

Line 11944: ,FND_GLOBAL.USER_ID

11940: ,OksBSCHRecTab.OksBSCH_SECURITY_GROUP_ID(i)
11941: ,OksBSCHRecTab.OksBSCH_OBJECT_VERSION_NUMBER(i)
11942: ,FND_GLOBAL.USER_ID
11943: ,SYSDATE
11944: ,FND_GLOBAL.USER_ID
11945: ,SYSDATE
11946: ,FND_GLOBAL.LOGIN_ID
11947: FROM DUAL;
11948:

Line 11946: ,FND_GLOBAL.LOGIN_ID

11942: ,FND_GLOBAL.USER_ID
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;

Line 12614: ,FND_GLOBAL.USER_ID

12610: ,OksSLRecTab.OksSL_REQUEST_ID(i)
12611: ,OksSLRecTab.OksSL_ORIG_SYSTEM_ID1(i)
12612: ,OksSLRecTab.OksSL_ORIG_SYSTEM_SOURCE_CODE(i)
12613: ,OksSLRecTab.OksSL_ORIG_SYSTEM_REFERENCE1(i)
12614: ,FND_GLOBAL.USER_ID
12615: ,SYSDATE
12616: ,FND_GLOBAL.USER_ID
12617: ,SYSDATE
12618: ,FND_GLOBAL.LOGIN_ID

Line 12616: ,FND_GLOBAL.USER_ID

12612: ,OksSLRecTab.OksSL_ORIG_SYSTEM_SOURCE_CODE(i)
12613: ,OksSLRecTab.OksSL_ORIG_SYSTEM_REFERENCE1(i)
12614: ,FND_GLOBAL.USER_ID
12615: ,SYSDATE
12616: ,FND_GLOBAL.USER_ID
12617: ,SYSDATE
12618: ,FND_GLOBAL.LOGIN_ID
12619: FROM DUAL;
12620:

Line 12618: ,FND_GLOBAL.LOGIN_ID

12614: ,FND_GLOBAL.USER_ID
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;

Line 13292: ,FND_GLOBAL.USER_ID

13288: ,OksLERecTab.OksLE_NewCleID(i)
13289: ,OksLERecTab.OksLE_NewDnzChrID(i)
13290: ,OksLERecTab.OksLE_NewParentCleID(i)
13291: ,OksLERecTab.OksLE_DATE_END(i)
13292: ,FND_GLOBAL.USER_ID
13293: ,SYSDATE
13294: ,FND_GLOBAL.USER_ID
13295: ,SYSDATE
13296: FROM DUAL;

Line 13294: ,FND_GLOBAL.USER_ID

13290: ,OksLERecTab.OksLE_NewParentCleID(i)
13291: ,OksLERecTab.OksLE_DATE_END(i)
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

Line 18338: ,FND_GLOBAL.USER_ID

18334: ,OKCOKSLinesRecTab.OkcB_ANNUALIZED_FACTOR(i)
18335: ,OKCOKSLinesRecTab.OkcB_PAYMENT_INSTRUCTION_TYPE(i) -- hkamdar 29-Mar-2006 Bug # 4722452
18336: ,OKCOKSLinesRecTab.OkcB_CANCELLED_AMOUNT(i)
18337: ,SYSDATE
18338: ,FND_GLOBAL.USER_ID
18339: ,SYSDATE
18340: ,FND_GLOBAL.USER_ID
18341: ,FND_GLOBAL.LOGIN_ID
18342: FROM

Line 18340: ,FND_GLOBAL.USER_ID

18336: ,OKCOKSLinesRecTab.OkcB_CANCELLED_AMOUNT(i)
18337: ,SYSDATE
18338: ,FND_GLOBAL.USER_ID
18339: ,SYSDATE
18340: ,FND_GLOBAL.USER_ID
18341: ,FND_GLOBAL.LOGIN_ID
18342: FROM
18343: DUAL;
18344:

Line 18341: ,FND_GLOBAL.LOGIN_ID

18337: ,SYSDATE
18338: ,FND_GLOBAL.USER_ID
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

Line 18567: ,FND_GLOBAL.USER_ID

18563: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE(i)
18564: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID(i)
18565: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)
18566: ,SYSDATE
18567: ,FND_GLOBAL.USER_ID
18568: ,SYSDATE
18569: ,FND_GLOBAL.USER_ID
18570: ,FND_GLOBAL.LOGIN_ID
18571: FROM

Line 18569: ,FND_GLOBAL.USER_ID

18565: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)
18566: ,SYSDATE
18567: ,FND_GLOBAL.USER_ID
18568: ,SYSDATE
18569: ,FND_GLOBAL.USER_ID
18570: ,FND_GLOBAL.LOGIN_ID
18571: FROM
18572: DUAL
18573: WHERE

Line 18570: ,FND_GLOBAL.LOGIN_ID

18566: ,SYSDATE
18567: ,FND_GLOBAL.USER_ID
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;

Line 18650: ,FND_GLOBAL.USER_ID

18646: ,OKCOKSLinesRecTab.OkcI_PROGRAM_ID(i)
18647: ,OKCOKSLinesRecTab.OkcI_PROGRAM_UPDATE_DATE(i)
18648: ,OKCOKSLinesRecTab.OkcI_REQUEST_ID(i)
18649: ,SYSDATE
18650: ,FND_GLOBAL.USER_ID
18651: ,SYSDATE
18652: ,FND_GLOBAL.USER_ID
18653: ,FND_GLOBAL.LOGIN_ID
18654: FROM

Line 18652: ,FND_GLOBAL.USER_ID

18648: ,OKCOKSLinesRecTab.OkcI_REQUEST_ID(i)
18649: ,SYSDATE
18650: ,FND_GLOBAL.USER_ID
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;

Line 18653: ,FND_GLOBAL.LOGIN_ID

18649: ,SYSDATE
18650: ,FND_GLOBAL.USER_ID
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:

Line 23768: ,FND_GLOBAL.USER_ID

23764: -- ,OKCOKSLinesRecTab.OkcB_PAYMENT_INSTRUCTION_TYPE(i) -- hkamdar 29-Mar-2006 Bug # 4722452
23765: ,NULL
23766: ,OKCOKSLinesRecTab.OkcB_CANCELLED_AMOUNT(i)
23767: ,SYSDATE
23768: ,FND_GLOBAL.USER_ID
23769: ,SYSDATE
23770: ,FND_GLOBAL.USER_ID
23771: ,FND_GLOBAL.LOGIN_ID
23772: FROM

Line 23770: ,FND_GLOBAL.USER_ID

23766: ,OKCOKSLinesRecTab.OkcB_CANCELLED_AMOUNT(i)
23767: ,SYSDATE
23768: ,FND_GLOBAL.USER_ID
23769: ,SYSDATE
23770: ,FND_GLOBAL.USER_ID
23771: ,FND_GLOBAL.LOGIN_ID
23772: FROM
23773: DUAL;
23774:

Line 23771: ,FND_GLOBAL.LOGIN_ID

23767: ,SYSDATE
23768: ,FND_GLOBAL.USER_ID
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

Line 23989: ,FND_GLOBAL.USER_ID

23985: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE(i)
23986: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID(i)
23987: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)
23988: ,SYSDATE
23989: ,FND_GLOBAL.USER_ID
23990: ,SYSDATE
23991: ,FND_GLOBAL.USER_ID
23992: ,FND_GLOBAL.LOGIN_ID
23993: FROM

Line 23991: ,FND_GLOBAL.USER_ID

23987: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)
23988: ,SYSDATE
23989: ,FND_GLOBAL.USER_ID
23990: ,SYSDATE
23991: ,FND_GLOBAL.USER_ID
23992: ,FND_GLOBAL.LOGIN_ID
23993: FROM
23994: DUAL
23995: WHERE

Line 23992: ,FND_GLOBAL.LOGIN_ID

23988: ,SYSDATE
23989: ,FND_GLOBAL.USER_ID
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;

Line 24055: ,FND_GLOBAL.USER_ID

24051: ,OKCOKSLinesRecTab.OkcI_PROGRAM_ID(i)
24052: ,OKCOKSLinesRecTab.OkcI_PROGRAM_UPDATE_DATE(i)
24053: ,OKCOKSLinesRecTab.OkcI_REQUEST_ID(i)
24054: ,SYSDATE
24055: ,FND_GLOBAL.USER_ID
24056: ,SYSDATE
24057: ,FND_GLOBAL.USER_ID
24058: ,FND_GLOBAL.LOGIN_ID
24059: FROM

Line 24057: ,FND_GLOBAL.USER_ID

24053: ,OKCOKSLinesRecTab.OkcI_REQUEST_ID(i)
24054: ,SYSDATE
24055: ,FND_GLOBAL.USER_ID
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;

Line 24058: ,FND_GLOBAL.LOGIN_ID

24054: ,SYSDATE
24055: ,FND_GLOBAL.USER_ID
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: