DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on FND_GLOBAL

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

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

Line 4129: ,FND_GLOBAL.USER_ID

4125: ,OKCLinesTLRecTab.OkcTL_NAME(i)
4126: ,OKCLinesTLRecTab.OkcTL_COMMENTS(i)
4127: ,OKCLinesTLRecTab.OkcTL_ITEM_DESCRIPTION(i)
4128: ,OKCLinesTLRecTab.OkcTL_BLOCK23TEXT(i)
4129: ,FND_GLOBAL.USER_ID
4130: ,SYSDATE
4131: ,FND_GLOBAL.USER_ID
4132: ,SYSDATE
4133: ,FND_GLOBAL.LOGIN_ID

Line 4131: ,FND_GLOBAL.USER_ID

4127: ,OKCLinesTLRecTab.OkcTL_ITEM_DESCRIPTION(i)
4128: ,OKCLinesTLRecTab.OkcTL_BLOCK23TEXT(i)
4129: ,FND_GLOBAL.USER_ID
4130: ,SYSDATE
4131: ,FND_GLOBAL.USER_ID
4132: ,SYSDATE
4133: ,FND_GLOBAL.LOGIN_ID
4134: ,OKCLinesTLRecTab.OkcTL_SECURITY_GROUP_ID(i)
4135: ,OKCLinesTLRecTab.OkcTL_OKE_BOE_DESCRIPTION(i)

Line 4133: ,FND_GLOBAL.LOGIN_ID

4129: ,FND_GLOBAL.USER_ID
4130: ,SYSDATE
4131: ,FND_GLOBAL.USER_ID
4132: ,SYSDATE
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;

Line 6920: ,FND_GLOBAL.USER_ID

6916: ,OkcPAVRecTab.OkcPAV_PROGRAM_ID(i)
6917: ,OkcPAVRecTab.OkcPAV_PROGRAM_UPDATE_DATE(i)
6918: ,OkcPAVRecTab.OkcPAV_REQUEST_ID(i)
6919: ,OkcPAVRecTab.OkcPAV_OBJECT_VERSION_NUMBER(i)
6920: ,FND_GLOBAL.USER_ID
6921: ,SYSDATE
6922: ,FND_GLOBAL.USER_ID
6923: ,SYSDATE
6924: ,FND_GLOBAL.LOGIN_ID

Line 6922: ,FND_GLOBAL.USER_ID

6918: ,OkcPAVRecTab.OkcPAV_REQUEST_ID(i)
6919: ,OkcPAVRecTab.OkcPAV_OBJECT_VERSION_NUMBER(i)
6920: ,FND_GLOBAL.USER_ID
6921: ,SYSDATE
6922: ,FND_GLOBAL.USER_ID
6923: ,SYSDATE
6924: ,FND_GLOBAL.LOGIN_ID
6925: from
6926: DUAL;

Line 6924: ,FND_GLOBAL.LOGIN_ID

6920: ,FND_GLOBAL.USER_ID
6921: ,SYSDATE
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

Line 7946: ,FND_GLOBAL.USER_ID

7942: ,okcPARecTab.OkcPA_SUBSTITUTION_ATTRIBUTE(i)
7943: ,okcPARecTab.OkcPA_PRORATION_TYPE_CODE(i)
7944: ,okcPARecTab.OkcPA_INCLUDE_ON_RETURNS_FLAG(i)
7945: ,okcPARecTab.OkcPA_REBATE_TRXN_TYPE_CODE(i)
7946: ,FND_GLOBAL.USER_ID
7947: ,SYSDATE
7948: ,FND_GLOBAL.USER_ID
7949: ,SYSDATE
7950: ,FND_GLOBAL.LOGIN_ID

Line 7948: ,FND_GLOBAL.USER_ID

7944: ,okcPARecTab.OkcPA_INCLUDE_ON_RETURNS_FLAG(i)
7945: ,okcPARecTab.OkcPA_REBATE_TRXN_TYPE_CODE(i)
7946: ,FND_GLOBAL.USER_ID
7947: ,SYSDATE
7948: ,FND_GLOBAL.USER_ID
7949: ,SYSDATE
7950: ,FND_GLOBAL.LOGIN_ID
7951: FROM
7952: DUAL;

Line 7950: ,FND_GLOBAL.LOGIN_ID

7946: ,FND_GLOBAL.USER_ID
7947: ,SYSDATE
7948: ,FND_GLOBAL.USER_ID
7949: ,SYSDATE
7950: ,FND_GLOBAL.LOGIN_ID
7951: FROM
7952: DUAL;
7953:
7954:

Line 8360: ,FND_GLOBAL.USER_ID

8356: ,OkcPRBRecTab.OkcPRB_CUST_ACCT_ID(i)
8357: ,OkcPRBRecTab.OkcPRB_ORIG_SYSTEM_ID1(i)
8358: ,OkcPRBRecTab.OkcPRB_ORIG_SYSTEM_REFERENCE1(i)
8359: ,OkcPRBRecTab.OkcPRB_ORIG_SYSTEM_SOURCE_CODE(i)
8360: ,FND_GLOBAL.USER_ID
8361: ,SYSDATE
8362: ,FND_GLOBAL.USER_ID
8363: ,SYSDATE
8364: ,FND_GLOBAL.LOGIN_ID

Line 8362: ,FND_GLOBAL.USER_ID

8358: ,OkcPRBRecTab.OkcPRB_ORIG_SYSTEM_REFERENCE1(i)
8359: ,OkcPRBRecTab.OkcPRB_ORIG_SYSTEM_SOURCE_CODE(i)
8360: ,FND_GLOBAL.USER_ID
8361: ,SYSDATE
8362: ,FND_GLOBAL.USER_ID
8363: ,SYSDATE
8364: ,FND_GLOBAL.LOGIN_ID
8365: FROM DUAL;
8366:

Line 8364: ,FND_GLOBAL.LOGIN_ID

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

Line 8644: ,FND_GLOBAL.USER_ID

8640: ,OkcPRTLRecTab.OkcPRTL_SFWT_FLAG(i)
8641: ,OkcPRTLRecTab.OkcPRTL_COGNOMEN(i)
8642: ,OkcPRTLRecTab.OkcPRTL_ALIAS(i)
8643: ,OkcPRTLRecTab.OkcPRTL_SECURITY_GROUP_ID(i)
8644: ,FND_GLOBAL.USER_ID
8645: ,SYSDATE
8646: ,FND_GLOBAL.USER_ID
8647: ,SYSDATE
8648: ,FND_GLOBAL.LOGIN_ID

Line 8646: ,FND_GLOBAL.USER_ID

8642: ,OkcPRTLRecTab.OkcPRTL_ALIAS(i)
8643: ,OkcPRTLRecTab.OkcPRTL_SECURITY_GROUP_ID(i)
8644: ,FND_GLOBAL.USER_ID
8645: ,SYSDATE
8646: ,FND_GLOBAL.USER_ID
8647: ,SYSDATE
8648: ,FND_GLOBAL.LOGIN_ID
8649: FROM DUAL;
8650:

Line 8648: ,FND_GLOBAL.LOGIN_ID

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

Line 8933: , FND_GLOBAL.USER_ID

8929: , OkcCRecTab.OkcC_END_DATE(i)
8930: , OkcCRecTab.OkcC_PRIMARY_YN(i)
8931: , OkcCRecTab.OkcC_RESOURCE_CLASS(i)
8932: , OkcCRecTab.OkcC_SALES_GROUP_ID(i)
8933: , FND_GLOBAL.USER_ID
8934: , SYSDATE
8935: , FND_GLOBAL.USER_ID
8936: , SYSDATE
8937: , FND_GLOBAL.LOGIN_ID

Line 8935: , FND_GLOBAL.USER_ID

8931: , OkcCRecTab.OkcC_RESOURCE_CLASS(i)
8932: , OkcCRecTab.OkcC_SALES_GROUP_ID(i)
8933: , FND_GLOBAL.USER_ID
8934: , SYSDATE
8935: , FND_GLOBAL.USER_ID
8936: , SYSDATE
8937: , FND_GLOBAL.LOGIN_ID
8938: FROM DUAL;
8939:

Line 8937: , FND_GLOBAL.LOGIN_ID

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

Line 9092: ,FND_GLOBAL.USER_ID

9088: ,OkcOLRecTab.OkcOLSECURITY_GROUP_ID(i)
9089: ,OkcOLRecTab.OkcOLMESSAGE_CODE(i)
9090: ,OkcOLRecTab.OkcOLPARENT_OLE_ID(i)
9091: ,OkcOLRecTab.OkcOLACTIVE_YN(i)
9092: ,FND_GLOBAL.USER_ID
9093: ,SYSDATE
9094: ,FND_GLOBAL.USER_ID
9095: ,SYSDATE
9096: ,FND_GLOBAL.LOGIN_ID

Line 9094: ,FND_GLOBAL.USER_ID

9090: ,OkcOLRecTab.OkcOLPARENT_OLE_ID(i)
9091: ,OkcOLRecTab.OkcOLACTIVE_YN(i)
9092: ,FND_GLOBAL.USER_ID
9093: ,SYSDATE
9094: ,FND_GLOBAL.USER_ID
9095: ,SYSDATE
9096: ,FND_GLOBAL.LOGIN_ID
9097: FROM DUAL;
9098: EXIT WHEN GetOkcOLFull%NOTFOUND;

Line 9096: ,FND_GLOBAL.LOGIN_ID

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

Line 9270: , FND_GLOBAL.USER_ID

9266: , OksTLRecTab.OksTL_IB_TRX_DETAILS(i)
9267: , OksTLRecTab.OksTL_STATUS_TEXT(i)
9268: , OksTLRecTab.OksTL_REACT_TIME_NAME(i)
9269: , OksTLRecTab.OksTL_SECURITY_GROUP_ID(i)
9270: , FND_GLOBAL.USER_ID
9271: , SYSDATE
9272: , FND_GLOBAL.USER_ID
9273: , SYSDATE
9274: , FND_GLOBAL.LOGIN_ID

Line 9272: , FND_GLOBAL.USER_ID

9268: , OksTLRecTab.OksTL_REACT_TIME_NAME(i)
9269: , OksTLRecTab.OksTL_SECURITY_GROUP_ID(i)
9270: , FND_GLOBAL.USER_ID
9271: , SYSDATE
9272: , FND_GLOBAL.USER_ID
9273: , SYSDATE
9274: , FND_GLOBAL.LOGIN_ID
9275: FROM DUAL;
9276:

Line 9274: , FND_GLOBAL.LOGIN_ID

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

Line 9418: , FND_GLOBAL.USER_ID

9414: , OksRDRecTab.OksRD_CODE_COMBINATION_ID(i)
9415: , OksRDRecTab.OksRD_PERCENT(i)
9416: , OksRDRecTab.OksRD_OBJECT_VERSION_NUMBER(i)
9417: , OksRDRecTab.OksRD_SECURITY_GROUP_ID(i)
9418: , FND_GLOBAL.USER_ID
9419: , SYSDATE
9420: , FND_GLOBAL.USER_ID
9421: , SYSDATE
9422: , FND_GLOBAL.LOGIN_ID

Line 9420: , FND_GLOBAL.USER_ID

9416: , OksRDRecTab.OksRD_OBJECT_VERSION_NUMBER(i)
9417: , OksRDRecTab.OksRD_SECURITY_GROUP_ID(i)
9418: , FND_GLOBAL.USER_ID
9419: , SYSDATE
9420: , FND_GLOBAL.USER_ID
9421: , SYSDATE
9422: , FND_GLOBAL.LOGIN_ID
9423: FROM DUAL;
9424:

Line 9422: , FND_GLOBAL.LOGIN_ID

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

Line 9763: , FND_GLOBAL.USER_ID

9759: , OksQRecTab.OksQ_LIST_TYPE_CODE(i)
9760: , OksQRecTab.OksQ_QUAL_ATTRVALUE_FROM_NUM(i)
9761: , OksQRecTab.OksQ_QUAL_ATTRVALUE_TO_NUM(i)
9762: , OksQRecTab.OksQ_SECURITY_GROUP_ID(i)
9763: , FND_GLOBAL.USER_ID
9764: , SYSDATE
9765: , FND_GLOBAL.USER_ID
9766: , FND_GLOBAL.LOGIN_ID
9767: , SYSDATE

Line 9765: , FND_GLOBAL.USER_ID

9761: , OksQRecTab.OksQ_QUAL_ATTRVALUE_TO_NUM(i)
9762: , OksQRecTab.OksQ_SECURITY_GROUP_ID(i)
9763: , FND_GLOBAL.USER_ID
9764: , SYSDATE
9765: , FND_GLOBAL.USER_ID
9766: , FND_GLOBAL.LOGIN_ID
9767: , SYSDATE
9768: FROM DUAL;
9769:

Line 9766: , FND_GLOBAL.LOGIN_ID

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

Line 9952: ,FND_GLOBAL.USER_ID

9948: ,OksCTZRecTab.OksCTZ_OBJECT_VERSION_NUMBER(i)
9949: ,OksCTZRecTab.OksCTZ_ORIG_SYSTEM_ID1(i)
9950: ,OksCTZRecTab.OksCTZ_ORIG_SYSTEM_SOURCE_CODE(i)
9951: ,OksCTZRecTab.OksCTZ_ORIG_SYSTEM_REFERENCE1(i)
9952: ,FND_GLOBAL.USER_ID
9953: ,SYSDATE
9954: ,FND_GLOBAL.USER_ID
9955: ,SYSDATE
9956: ,FND_GLOBAL.LOGIN_ID

Line 9954: ,FND_GLOBAL.USER_ID

9950: ,OksCTZRecTab.OksCTZ_ORIG_SYSTEM_SOURCE_CODE(i)
9951: ,OksCTZRecTab.OksCTZ_ORIG_SYSTEM_REFERENCE1(i)
9952: ,FND_GLOBAL.USER_ID
9953: ,SYSDATE
9954: ,FND_GLOBAL.USER_ID
9955: ,SYSDATE
9956: ,FND_GLOBAL.LOGIN_ID
9957: FROM DUAL;
9958:

Line 9956: ,FND_GLOBAL.LOGIN_ID

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

Line 10179: ,FND_GLOBAL.USER_ID

10175: ,OksCTRecTab.OksCT_OBJECT_VERSION_NUMBER(i)
10176: ,OksCTRecTab.OksCT_PROGRAM_ID(i)
10177: ,OksCTRecTab.OksCT_PROGRAM_UPDATE_DATE(i)
10178: ,OksCTRecTab.OksCT_REQUEST_ID(i)
10179: ,FND_GLOBAL.USER_ID
10180: ,SYSDATE
10181: ,FND_GLOBAL.USER_ID
10182: ,SYSDATE
10183: ,FND_GLOBAL.LOGIN_ID

Line 10181: ,FND_GLOBAL.USER_ID

10177: ,OksCTRecTab.OksCT_PROGRAM_UPDATE_DATE(i)
10178: ,OksCTRecTab.OksCT_REQUEST_ID(i)
10179: ,FND_GLOBAL.USER_ID
10180: ,SYSDATE
10181: ,FND_GLOBAL.USER_ID
10182: ,SYSDATE
10183: ,FND_GLOBAL.LOGIN_ID
10184: FROM DUAL;
10185:

Line 10183: ,FND_GLOBAL.LOGIN_ID

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

Line 10380: ,FND_GLOBAL.USER_ID

10376: ,OksPMARecTab.OksPMA_REQUEST_ID(i)
10377: ,OksPMARecTab.OksPMA_ORIG_SYSTEM_ID1(i)
10378: ,OksPMARecTab.OksPMA_ORIG_SYSTEM_SOURCE_CODE(i)
10379: ,OksPMARecTab.OksPMA_ORIG_SYSTEM_REFERENCE1(i)
10380: ,FND_GLOBAL.USER_ID
10381: ,SYSDATE
10382: ,FND_GLOBAL.USER_ID
10383: ,SYSDATE
10384: ,FND_GLOBAL.LOGIN_ID

Line 10382: ,FND_GLOBAL.USER_ID

10378: ,OksPMARecTab.OksPMA_ORIG_SYSTEM_SOURCE_CODE(i)
10379: ,OksPMARecTab.OksPMA_ORIG_SYSTEM_REFERENCE1(i)
10380: ,FND_GLOBAL.USER_ID
10381: ,SYSDATE
10382: ,FND_GLOBAL.USER_ID
10383: ,SYSDATE
10384: ,FND_GLOBAL.LOGIN_ID
10385: FROM DUAL;
10386:

Line 10384: ,FND_GLOBAL.LOGIN_ID

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

Line 10689: ,FND_GLOBAL.USER_ID

10685: ,OksPMSLRecTab.OksPMSL_REQUEST_ID(i)
10686: ,OksPMSLRecTab.OksPMSL_ORIG_SYSTEM_ID1(i)
10687: ,OksPMSLRecTab.OksPMSL_ORIG_SYS_SOURCE_CODE(i)
10688: ,OksPMSLRecTab.OksPMSL_ORIG_SYS_REFERENCE1(i)
10689: ,FND_GLOBAL.USER_ID
10690: ,SYSDATE
10691: ,FND_GLOBAL.USER_ID
10692: ,SYSDATE
10693: ,FND_GLOBAL.LOGIN_ID

Line 10691: ,FND_GLOBAL.USER_ID

10687: ,OksPMSLRecTab.OksPMSL_ORIG_SYS_SOURCE_CODE(i)
10688: ,OksPMSLRecTab.OksPMSL_ORIG_SYS_REFERENCE1(i)
10689: ,FND_GLOBAL.USER_ID
10690: ,SYSDATE
10691: ,FND_GLOBAL.USER_ID
10692: ,SYSDATE
10693: ,FND_GLOBAL.LOGIN_ID
10694: FROM DUAL;
10695:

Line 10693: ,FND_GLOBAL.LOGIN_ID

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

Line 10907: ,FND_GLOBAL.USER_ID

10903: ,OksPMSCHRecTab.OksPMSCH_PROG_APPLICATION_ID(i)
10904: ,OksPMSCHRecTab.OksPMSCH_PROGRAM_ID(i)
10905: ,OksPMSCHRecTab.OksPMSCH_PROGRAM_UPDATE_DATE(i)
10906: ,OksPMSCHRecTab.OksPMSCH_REQUEST_ID(i)
10907: ,FND_GLOBAL.USER_ID
10908: ,SYSDATE
10909: ,FND_GLOBAL.USER_ID
10910: ,SYSDATE
10911: ,FND_GLOBAL.LOGIN_ID

Line 10909: ,FND_GLOBAL.USER_ID

10905: ,OksPMSCHRecTab.OksPMSCH_PROGRAM_UPDATE_DATE(i)
10906: ,OksPMSCHRecTab.OksPMSCH_REQUEST_ID(i)
10907: ,FND_GLOBAL.USER_ID
10908: ,SYSDATE
10909: ,FND_GLOBAL.USER_ID
10910: ,SYSDATE
10911: ,FND_GLOBAL.LOGIN_ID
10912: FROM DUAL;
10913:

Line 10911: ,FND_GLOBAL.LOGIN_ID

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

Line 11183: ,FND_GLOBAL.USER_ID

11179: ,OksATTRecTab.OksATT_OBJECT_VERSION_NUMBER(i)
11180: ,OksATTRecTab.OksATT_ORIG_SYSTEM_ID1(i)
11181: ,OksATTRecTab.OksATT_ORIG_SYSTEM_SOURCE_CODE(i)
11182: ,OksATTRecTab.OksATT_ORIG_SYSTEM_REFERENCE1(i)
11183: ,FND_GLOBAL.USER_ID
11184: ,SYSDATE
11185: ,FND_GLOBAL.USER_ID
11186: ,SYSDATE
11187: ,FND_GLOBAL.LOGIN_ID

Line 11185: ,FND_GLOBAL.USER_ID

11181: ,OksATTRecTab.OksATT_ORIG_SYSTEM_SOURCE_CODE(i)
11182: ,OksATTRecTab.OksATT_ORIG_SYSTEM_REFERENCE1(i)
11183: ,FND_GLOBAL.USER_ID
11184: ,SYSDATE
11185: ,FND_GLOBAL.USER_ID
11186: ,SYSDATE
11187: ,FND_GLOBAL.LOGIN_ID
11188: FROM DUAL;
11189:

Line 11187: ,FND_GLOBAL.LOGIN_ID

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

Line 11398: ,FND_GLOBAL.USER_ID

11394: ,OksATRecTab.OksAT_PROGRAM_ID(i)
11395: ,OksATRecTab.OksAT_PROGRAM_UPDATE_DATE(i)
11396: ,OksATRecTab.OksAT_REQUEST_ID(i)
11397: ,OksATRecTab.OksAT_OBJECT_VERSION_NUMBER(i)
11398: ,FND_GLOBAL.USER_ID
11399: ,SYSDATE
11400: ,FND_GLOBAL.USER_ID
11401: ,SYSDATE
11402: ,FND_GLOBAL.LOGIN_ID

Line 11400: ,FND_GLOBAL.USER_ID

11396: ,OksATRecTab.OksAT_REQUEST_ID(i)
11397: ,OksATRecTab.OksAT_OBJECT_VERSION_NUMBER(i)
11398: ,FND_GLOBAL.USER_ID
11399: ,SYSDATE
11400: ,FND_GLOBAL.USER_ID
11401: ,SYSDATE
11402: ,FND_GLOBAL.LOGIN_ID
11403: FROM DUAL;
11404:

Line 11402: ,FND_GLOBAL.LOGIN_ID

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

Line 11696: ,FND_GLOBAL.USER_ID

11692: ,OksSCRecTab.OksSC_SALES_CREDIT_TYPE_ID2(i)
11693: ,OksSCRecTab.OksSC_OBJECT_VERSION_NUMBER(i)
11694: ,OksSCRecTab.OksSC_SECURITY_GROUP_ID(i)
11695: ,OksSCRecTab.OksSC_SALES_GROUP_ID(i)
11696: ,FND_GLOBAL.USER_ID
11697: ,SYSDATE
11698: ,FND_GLOBAL.USER_ID
11699: ,SYSDATE
11700: FROM DUAL;

Line 11698: ,FND_GLOBAL.USER_ID

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

Line 11987: ,FND_GLOBAL.USER_ID

11983: ,OksBSCHRecTab.OksBSCH_PROGRAM_UPDATE_DATE(i)
11984: ,OksBSCHRecTab.OksBSCH_REQUEST_ID(i)
11985: ,OksBSCHRecTab.OksBSCH_SECURITY_GROUP_ID(i)
11986: ,OksBSCHRecTab.OksBSCH_OBJECT_VERSION_NUMBER(i)
11987: ,FND_GLOBAL.USER_ID
11988: ,SYSDATE
11989: ,FND_GLOBAL.USER_ID
11990: ,SYSDATE
11991: ,FND_GLOBAL.LOGIN_ID

Line 11989: ,FND_GLOBAL.USER_ID

11985: ,OksBSCHRecTab.OksBSCH_SECURITY_GROUP_ID(i)
11986: ,OksBSCHRecTab.OksBSCH_OBJECT_VERSION_NUMBER(i)
11987: ,FND_GLOBAL.USER_ID
11988: ,SYSDATE
11989: ,FND_GLOBAL.USER_ID
11990: ,SYSDATE
11991: ,FND_GLOBAL.LOGIN_ID
11992: FROM DUAL;
11993:

Line 11991: ,FND_GLOBAL.LOGIN_ID

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

Line 12659: ,FND_GLOBAL.USER_ID

12655: ,OksSLRecTab.OksSL_REQUEST_ID(i)
12656: ,OksSLRecTab.OksSL_ORIG_SYSTEM_ID1(i)
12657: ,OksSLRecTab.OksSL_ORIG_SYSTEM_SOURCE_CODE(i)
12658: ,OksSLRecTab.OksSL_ORIG_SYSTEM_REFERENCE1(i)
12659: ,FND_GLOBAL.USER_ID
12660: ,SYSDATE
12661: ,FND_GLOBAL.USER_ID
12662: ,SYSDATE
12663: ,FND_GLOBAL.LOGIN_ID

Line 12661: ,FND_GLOBAL.USER_ID

12657: ,OksSLRecTab.OksSL_ORIG_SYSTEM_SOURCE_CODE(i)
12658: ,OksSLRecTab.OksSL_ORIG_SYSTEM_REFERENCE1(i)
12659: ,FND_GLOBAL.USER_ID
12660: ,SYSDATE
12661: ,FND_GLOBAL.USER_ID
12662: ,SYSDATE
12663: ,FND_GLOBAL.LOGIN_ID
12664: FROM DUAL;
12665:

Line 12663: ,FND_GLOBAL.LOGIN_ID

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

Line 13337: ,FND_GLOBAL.USER_ID

13333: ,OksLERecTab.OksLE_NewCleID(i)
13334: ,OksLERecTab.OksLE_NewDnzChrID(i)
13335: ,OksLERecTab.OksLE_NewParentCleID(i)
13336: ,OksLERecTab.OksLE_DATE_END(i)
13337: ,FND_GLOBAL.USER_ID
13338: ,SYSDATE
13339: ,FND_GLOBAL.USER_ID
13340: ,SYSDATE
13341: FROM DUAL;

Line 13339: ,FND_GLOBAL.USER_ID

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

Line 18427: ,FND_GLOBAL.USER_ID

18423: ,OKCOKSLinesRecTab.OkcB_ANNUALIZED_FACTOR(i)
18424: ,OKCOKSLinesRecTab.OkcB_PAYMENT_INSTRUCTION_TYPE(i) -- hkamdar 29-Mar-2006 Bug # 4722452
18425: ,OKCOKSLinesRecTab.OkcB_CANCELLED_AMOUNT(i)
18426: ,SYSDATE
18427: ,FND_GLOBAL.USER_ID
18428: ,SYSDATE
18429: ,FND_GLOBAL.USER_ID
18430: ,FND_GLOBAL.LOGIN_ID
18431: FROM

Line 18429: ,FND_GLOBAL.USER_ID

18425: ,OKCOKSLinesRecTab.OkcB_CANCELLED_AMOUNT(i)
18426: ,SYSDATE
18427: ,FND_GLOBAL.USER_ID
18428: ,SYSDATE
18429: ,FND_GLOBAL.USER_ID
18430: ,FND_GLOBAL.LOGIN_ID
18431: FROM
18432: DUAL;
18433:

Line 18430: ,FND_GLOBAL.LOGIN_ID

18426: ,SYSDATE
18427: ,FND_GLOBAL.USER_ID
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

Line 18657: ,FND_GLOBAL.USER_ID

18653: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE(i)
18654: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID(i)
18655: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)
18656: ,SYSDATE
18657: ,FND_GLOBAL.USER_ID
18658: ,SYSDATE
18659: ,FND_GLOBAL.USER_ID
18660: ,FND_GLOBAL.LOGIN_ID
18661: ,OKCOKSLinesRecTab.OksB_COUNTER_VALUE_ID(i)

Line 18659: ,FND_GLOBAL.USER_ID

18655: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)
18656: ,SYSDATE
18657: ,FND_GLOBAL.USER_ID
18658: ,SYSDATE
18659: ,FND_GLOBAL.USER_ID
18660: ,FND_GLOBAL.LOGIN_ID
18661: ,OKCOKSLinesRecTab.OksB_COUNTER_VALUE_ID(i)
18662: FROM
18663: DUAL

Line 18660: ,FND_GLOBAL.LOGIN_ID

18656: ,SYSDATE
18657: ,FND_GLOBAL.USER_ID
18658: ,SYSDATE
18659: ,FND_GLOBAL.USER_ID
18660: ,FND_GLOBAL.LOGIN_ID
18661: ,OKCOKSLinesRecTab.OksB_COUNTER_VALUE_ID(i)
18662: FROM
18663: DUAL
18664: WHERE

Line 18741: ,FND_GLOBAL.USER_ID

18737: ,OKCOKSLinesRecTab.OkcI_PROGRAM_ID(i)
18738: ,OKCOKSLinesRecTab.OkcI_PROGRAM_UPDATE_DATE(i)
18739: ,OKCOKSLinesRecTab.OkcI_REQUEST_ID(i)
18740: ,SYSDATE
18741: ,FND_GLOBAL.USER_ID
18742: ,SYSDATE
18743: ,FND_GLOBAL.USER_ID
18744: ,FND_GLOBAL.LOGIN_ID
18745: FROM

Line 18743: ,FND_GLOBAL.USER_ID

18739: ,OKCOKSLinesRecTab.OkcI_REQUEST_ID(i)
18740: ,SYSDATE
18741: ,FND_GLOBAL.USER_ID
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;

Line 18744: ,FND_GLOBAL.LOGIN_ID

18740: ,SYSDATE
18741: ,FND_GLOBAL.USER_ID
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:

Line 23923: ,FND_GLOBAL.USER_ID

23919: -- ,OKCOKSLinesRecTab.OkcB_PAYMENT_INSTRUCTION_TYPE(i) -- hkamdar 29-Mar-2006 Bug # 4722452
23920: ,NULL
23921: ,OKCOKSLinesRecTab.OkcB_CANCELLED_AMOUNT(i)
23922: ,SYSDATE
23923: ,FND_GLOBAL.USER_ID
23924: ,SYSDATE
23925: ,FND_GLOBAL.USER_ID
23926: ,FND_GLOBAL.LOGIN_ID
23927: FROM

Line 23925: ,FND_GLOBAL.USER_ID

23921: ,OKCOKSLinesRecTab.OkcB_CANCELLED_AMOUNT(i)
23922: ,SYSDATE
23923: ,FND_GLOBAL.USER_ID
23924: ,SYSDATE
23925: ,FND_GLOBAL.USER_ID
23926: ,FND_GLOBAL.LOGIN_ID
23927: FROM
23928: DUAL;
23929:

Line 23926: ,FND_GLOBAL.LOGIN_ID

23922: ,SYSDATE
23923: ,FND_GLOBAL.USER_ID
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

Line 24145: ,FND_GLOBAL.USER_ID

24141: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE(i)
24142: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID(i)
24143: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)
24144: ,SYSDATE
24145: ,FND_GLOBAL.USER_ID
24146: ,SYSDATE
24147: ,FND_GLOBAL.USER_ID
24148: ,FND_GLOBAL.LOGIN_ID
24149: ,OKCOKSLinesRecTab.OksB_COUNTER_VALUE_ID(i)

Line 24147: ,FND_GLOBAL.USER_ID

24143: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)
24144: ,SYSDATE
24145: ,FND_GLOBAL.USER_ID
24146: ,SYSDATE
24147: ,FND_GLOBAL.USER_ID
24148: ,FND_GLOBAL.LOGIN_ID
24149: ,OKCOKSLinesRecTab.OksB_COUNTER_VALUE_ID(i)
24150: FROM
24151: DUAL

Line 24148: ,FND_GLOBAL.LOGIN_ID

24144: ,SYSDATE
24145: ,FND_GLOBAL.USER_ID
24146: ,SYSDATE
24147: ,FND_GLOBAL.USER_ID
24148: ,FND_GLOBAL.LOGIN_ID
24149: ,OKCOKSLinesRecTab.OksB_COUNTER_VALUE_ID(i)
24150: FROM
24151: DUAL
24152: WHERE

Line 24212: ,FND_GLOBAL.USER_ID

24208: ,OKCOKSLinesRecTab.OkcI_PROGRAM_ID(i)
24209: ,OKCOKSLinesRecTab.OkcI_PROGRAM_UPDATE_DATE(i)
24210: ,OKCOKSLinesRecTab.OkcI_REQUEST_ID(i)
24211: ,SYSDATE
24212: ,FND_GLOBAL.USER_ID
24213: ,SYSDATE
24214: ,FND_GLOBAL.USER_ID
24215: ,FND_GLOBAL.LOGIN_ID
24216: FROM

Line 24214: ,FND_GLOBAL.USER_ID

24210: ,OKCOKSLinesRecTab.OkcI_REQUEST_ID(i)
24211: ,SYSDATE
24212: ,FND_GLOBAL.USER_ID
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;

Line 24215: ,FND_GLOBAL.LOGIN_ID

24211: ,SYSDATE
24212: ,FND_GLOBAL.USER_ID
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: