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.IBY_FNDCPT_TRXN_PUB dependencies on FND_GLOBAL

Line 1034: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

1030: p_trxn_attribs.Trxn_Ref_Number1, p_trxn_attribs.Trxn_Ref_Number2,
1031: p_trxn_attribs.Additional_Info,
1032: length(p_trxn_attribs.Instrument_Security_Code), l_encrypted,
1033: l_segment_id,
1034: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
1035: fnd_global.login_id, 1
1036: );
1037:
1038: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;

Line 1035: fnd_global.login_id, 1

1031: p_trxn_attribs.Additional_Info,
1032: length(p_trxn_attribs.Instrument_Security_Code), l_encrypted,
1033: l_segment_id,
1034: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
1035: fnd_global.login_id, 1
1036: );
1037:
1038: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;
1039: END IF;

Line 1371: last_updated_by = fnd_global.user_id,

1367: p_trxn_attribs.Trxn_Ref_Number2),
1368: additional_info = DECODE(p_trxn_attribs.Additional_Info,
1369: FND_API.G_MISS_CHAR,NULL, NULL,additional_info,
1370: p_trxn_attribs.Additional_Info),
1371: last_updated_by = fnd_global.user_id,
1372: last_update_date = SYSDATE,
1373: last_update_login = fnd_global.login_id,
1374: object_version_number = object_version_number + 1
1375: WHERE (trxn_extension_id = p_entity_id);

Line 1373: last_update_login = fnd_global.login_id,

1369: FND_API.G_MISS_CHAR,NULL, NULL,additional_info,
1370: p_trxn_attribs.Additional_Info),
1371: last_updated_by = fnd_global.user_id,
1372: last_update_date = SYSDATE,
1373: last_update_login = fnd_global.login_id,
1374: object_version_number = object_version_number + 1
1375: WHERE (trxn_extension_id = p_entity_id);
1376:
1377: iby_debug_pub.add('updating extension',

Line 2094: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

2090: l_extension.Order_Id, l_extension.PO_Number,
2091: l_extension.PO_Line_Number,
2092: l_extension.Trxn_Ref_Number1, l_extension.Trxn_Ref_Number2,
2093: l_extension.Additional_Info,
2094: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2095: fnd_global.login_id, 1
2096: );
2097:
2098: FOR i IN p_entities.FIRST..p_entities.LAST LOOP

Line 2095: fnd_global.login_id, 1

2091: l_extension.PO_Line_Number,
2092: l_extension.Trxn_Ref_Number1, l_extension.Trxn_Ref_Number2,
2093: l_extension.Additional_Info,
2094: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2095: fnd_global.login_id, 1
2096: );
2097:
2098: FOR i IN p_entities.FIRST..p_entities.LAST LOOP
2099:

Line 2108: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

2104: last_update_login, object_version_number
2105: )
2106: VALUES
2107: (p_entities(i), x_entity_id,
2108: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2109: fnd_global.login_id, 1
2110: );
2111:
2112: -- only the first copy receives an operations for the extension

Line 2109: fnd_global.login_id, 1

2105: )
2106: VALUES
2107: (p_entities(i), x_entity_id,
2108: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2109: fnd_global.login_id, 1
2110: );
2111:
2112: -- only the first copy receives an operations for the extension
2113: IF (l_copy_count < 1) THEN

Line 2126: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

2122: )
2123: -- instrument may change during copy
2124: SELECT
2125: x_entity_id, transactionid,
2126: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2127: fnd_global.login_id, 1
2128: FROM iby_fndcpt_tx_operations
2129: WHERE trxn_extension_id = p_entities(i);
2130: END IF;

Line 2127: fnd_global.login_id, 1

2123: -- instrument may change during copy
2124: SELECT
2125: x_entity_id, transactionid,
2126: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2127: fnd_global.login_id, 1
2128: FROM iby_fndcpt_tx_operations
2129: WHERE trxn_extension_id = p_entities(i);
2130: END IF;
2131: END LOOP;

Line 2223: last_updated_by = fnd_global.user_id,

2219: -- Update the sec_code with a randomly generated number
2220: SET instrument_security_code = l_random_val,
2221: --instr_sec_code_length = NULL,
2222: encrypted = 'N',
2223: last_updated_by = fnd_global.user_id,
2224: last_update_date = SYSDATE,
2225: last_update_login = fnd_global.login_id,
2226: object_version_number = object_version_number + 1
2227: WHERE trxn_extension_id = p_trxn_extn_id;

Line 2225: last_update_login = fnd_global.login_id,

2221: --instr_sec_code_length = NULL,
2222: encrypted = 'N',
2223: last_updated_by = fnd_global.user_id,
2224: last_update_date = SYSDATE,
2225: last_update_login = fnd_global.login_id,
2226: object_version_number = object_version_number + 1
2227: WHERE trxn_extension_id = p_trxn_extn_id;
2228: COMMIT;
2229:

Line 2235: last_updated_by = fnd_global.user_id,

2231: UPDATE iby_fndcpt_tx_extensions
2232: SET instrument_security_code = NULL,
2233: --instr_sec_code_length = NULL,
2234: encrypted = 'N',
2235: last_updated_by = fnd_global.user_id,
2236: last_update_date = SYSDATE,
2237: last_update_login = fnd_global.login_id,
2238: object_version_number = object_version_number + 1
2239: WHERE trxn_extension_id = p_trxn_extn_id;

Line 2237: last_update_login = fnd_global.login_id,

2233: --instr_sec_code_length = NULL,
2234: encrypted = 'N',
2235: last_updated_by = fnd_global.user_id,
2236: last_update_date = SYSDATE,
2237: last_update_login = fnd_global.login_id,
2238: object_version_number = object_version_number + 1
2239: WHERE trxn_extension_id = p_trxn_extn_id;
2240: COMMIT;
2241:

Line 2252: last_updated_by = fnd_global.user_id,

2248: UPDATE iby_fndcpt_tx_extensions
2249: SET instrument_security_code = NULL,
2250: --instr_sec_code_length = NULL,
2251: encrypted = 'N',
2252: last_updated_by = fnd_global.user_id,
2253: last_update_date = SYSDATE,
2254: last_update_login = fnd_global.login_id,
2255: object_version_number = object_version_number + 1
2256: WHERE trxn_extension_id = p_trxn_extn_id;

Line 2254: last_update_login = fnd_global.login_id,

2250: --instr_sec_code_length = NULL,
2251: encrypted = 'N',
2252: last_updated_by = fnd_global.user_id,
2253: last_update_date = SYSDATE,
2254: last_update_login = fnd_global.login_id,
2255: object_version_number = object_version_number + 1
2256: WHERE trxn_extension_id = p_trxn_extn_id;
2257:
2258: -- Delete the Security Code reference from the

Line 2583: -- last_updated_by = fnd_global.user_id,

2579: -- UPDATE iby_fndcpt_tx_extensions
2580: -- SET instrument_security_code = NULL,
2581: --instr_sec_code_length = NULL,
2582: -- encrypted = 'N',
2583: -- last_updated_by = fnd_global.user_id,
2584: -- last_update_date = SYSDATE,
2585: -- last_update_login = fnd_global.login_id,
2586: -- object_version_number = object_version_number + 1
2587: -- WHERE trxn_extension_id = p_trxn_entity_id;

Line 2585: -- last_update_login = fnd_global.login_id,

2581: --instr_sec_code_length = NULL,
2582: -- encrypted = 'N',
2583: -- last_updated_by = fnd_global.user_id,
2584: -- last_update_date = SYSDATE,
2585: -- last_update_login = fnd_global.login_id,
2586: -- object_version_number = object_version_number + 1
2587: -- WHERE trxn_extension_id = p_trxn_entity_id;
2588:
2589: -- DELETE iby_security_segments

Line 2660: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

2656: last_update_login, object_version_number
2657: )
2658: VALUES
2659: (p_trxn_entity_id, l_reqresp.Trxn_Id,
2660: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2661: fnd_global.login_id, 1
2662: );
2663:
2664: --

Line 2661: fnd_global.login_id, 1

2657: )
2658: VALUES
2659: (p_trxn_entity_id, l_reqresp.Trxn_Id,
2660: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2661: fnd_global.login_id, 1
2662: );
2663:
2664: --
2665: -- back-propagate the authorization

Line 2673: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

2669: created_by, creation_date, last_updated_by, last_update_date,
2670: last_update_login, object_version_number
2671: )
2672: SELECT source_trxn_extension_id, l_reqresp.Trxn_Id,
2673: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2674: fnd_global.login_id, 1
2675: FROM iby_fndcpt_tx_xe_copies
2676: START WITH copy_trxn_extension_id = p_trxn_entity_id
2677: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;

Line 2674: fnd_global.login_id, 1

2670: last_update_login, object_version_number
2671: )
2672: SELECT source_trxn_extension_id, l_reqresp.Trxn_Id,
2673: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2674: fnd_global.login_id, 1
2675: FROM iby_fndcpt_tx_xe_copies
2676: START WITH copy_trxn_extension_id = p_trxn_entity_id
2677: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
2678:

Line 2691: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

2687: created_by, creation_date, last_updated_by, last_update_date,
2688: last_update_login, object_version_number
2689: )
2690: SELECT copy_trxn_extension_id, l_reqresp.Trxn_Id,
2691: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2692: fnd_global.login_id, 1
2693: FROM iby_fndcpt_tx_xe_copies
2694: START WITH source_trxn_extension_id = p_trxn_entity_id
2695: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;

Line 2692: fnd_global.login_id, 1

2688: last_update_login, object_version_number
2689: )
2690: SELECT copy_trxn_extension_id, l_reqresp.Trxn_Id,
2691: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2692: fnd_global.login_id, 1
2693: FROM iby_fndcpt_tx_xe_copies
2694: START WITH source_trxn_extension_id = p_trxn_entity_id
2695: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
2696:

Line 3328: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

3324: last_update_login, object_version_number
3325: )
3326: VALUES
3327: (p_trxn_entity_id, l_reqresp.Trxn_Id,
3328: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3329: fnd_global.login_id, 1
3330: );
3331:
3332: --

Line 3329: fnd_global.login_id, 1

3325: )
3326: VALUES
3327: (p_trxn_entity_id, l_reqresp.Trxn_Id,
3328: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3329: fnd_global.login_id, 1
3330: );
3331:
3332: --
3333: -- back-propagate the authorization

Line 3341: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

3337: created_by, creation_date, last_updated_by, last_update_date,
3338: last_update_login, object_version_number
3339: )
3340: SELECT source_trxn_extension_id, l_reqresp.Trxn_Id,
3341: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3342: fnd_global.login_id, 1
3343: FROM iby_fndcpt_tx_xe_copies
3344: START WITH copy_trxn_extension_id = p_trxn_entity_id
3345: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;

Line 3342: fnd_global.login_id, 1

3338: last_update_login, object_version_number
3339: )
3340: SELECT source_trxn_extension_id, l_reqresp.Trxn_Id,
3341: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3342: fnd_global.login_id, 1
3343: FROM iby_fndcpt_tx_xe_copies
3344: START WITH copy_trxn_extension_id = p_trxn_entity_id
3345: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
3346:

Line 3359: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

3355: created_by, creation_date, last_updated_by, last_update_date,
3356: last_update_login, object_version_number
3357: )
3358: SELECT copy_trxn_extension_id, l_reqresp.Trxn_Id,
3359: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3360: fnd_global.login_id, 1
3361: FROM iby_fndcpt_tx_xe_copies
3362: START WITH source_trxn_extension_id = p_trxn_entity_id
3363: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;

Line 3360: fnd_global.login_id, 1

3356: last_update_login, object_version_number
3357: )
3358: SELECT copy_trxn_extension_id, l_reqresp.Trxn_Id,
3359: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3360: fnd_global.login_id, 1
3361: FROM iby_fndcpt_tx_xe_copies
3362: START WITH source_trxn_extension_id = p_trxn_entity_id
3363: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
3364:

Line 4216: l_Tangible_Tab(tangibleIndx).CREATED_BY := FND_GLOBAL.user_id;

4212: l_Tangible_Tab(tangibleIndx).MTANGIBLEID := l_mtangible;
4213: l_Tangible_Tab(tangibleIndx).TANGIBLEID := l_Trxn_Tab(indx).TANGIBLEID;
4214: l_Tangible_Tab(tangibleIndx).AMOUNT := l_settlement_trxn_rec.SETTLEMENT_AMOUNT;
4215: l_Tangible_Tab(tangibleIndx).CURRENCYNAMECODE := l_settlement_trxn_rec.SETTLEMENT_CURRENCY_CODE;
4216: l_Tangible_Tab(tangibleIndx).CREATED_BY := FND_GLOBAL.user_id;
4217: l_Tangible_Tab(tangibleIndx).CREATION_DATE := sysdate;
4218: l_Tangible_Tab(tangibleIndx).LAST_UPDATED_BY := FND_GLOBAL.user_id;
4219: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_DATE := sysdate;
4220: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;

Line 4218: l_Tangible_Tab(tangibleIndx).LAST_UPDATED_BY := FND_GLOBAL.user_id;

4214: l_Tangible_Tab(tangibleIndx).AMOUNT := l_settlement_trxn_rec.SETTLEMENT_AMOUNT;
4215: l_Tangible_Tab(tangibleIndx).CURRENCYNAMECODE := l_settlement_trxn_rec.SETTLEMENT_CURRENCY_CODE;
4216: l_Tangible_Tab(tangibleIndx).CREATED_BY := FND_GLOBAL.user_id;
4217: l_Tangible_Tab(tangibleIndx).CREATION_DATE := sysdate;
4218: l_Tangible_Tab(tangibleIndx).LAST_UPDATED_BY := FND_GLOBAL.user_id;
4219: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_DATE := sysdate;
4220: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;
4221: l_Tangible_Tab(tangibleIndx).OBJECT_VERSION_NUMBER := 1.0;
4222:

Line 4220: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;

4216: l_Tangible_Tab(tangibleIndx).CREATED_BY := FND_GLOBAL.user_id;
4217: l_Tangible_Tab(tangibleIndx).CREATION_DATE := sysdate;
4218: l_Tangible_Tab(tangibleIndx).LAST_UPDATED_BY := FND_GLOBAL.user_id;
4219: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_DATE := sysdate;
4220: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;
4221: l_Tangible_Tab(tangibleIndx).OBJECT_VERSION_NUMBER := 1.0;
4222:
4223:
4224: --l_Tangible_Tab(tangibleIndx).SOURCE_OBJECT_TYPE_CODE :=

Line 4324: l_Trxn_Tab(indx).LAST_UPDATED_BY := FND_GLOBAL.user_id;

4320: l_Trxn_Tab(indx).OBJECT_VERSION_NUMBER := 1.0;
4321:
4322: l_Trxn_Tab(indx).TRXNREF := l_settlement_trxn_rec.TRXN_REF_NUMBER1;
4323: l_Trxn_Tab(indx).LAST_UPDATE_DATE := sysdate;
4324: l_Trxn_Tab(indx).LAST_UPDATED_BY := FND_GLOBAL.user_id;
4325: l_Trxn_Tab(indx).CREATION_DATE := sysdate;
4326: l_Trxn_Tab(indx).CREATED_BY := FND_GLOBAL.user_id;
4327: l_Trxn_Tab(indx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;
4328:

Line 4326: l_Trxn_Tab(indx).CREATED_BY := FND_GLOBAL.user_id;

4322: l_Trxn_Tab(indx).TRXNREF := l_settlement_trxn_rec.TRXN_REF_NUMBER1;
4323: l_Trxn_Tab(indx).LAST_UPDATE_DATE := sysdate;
4324: l_Trxn_Tab(indx).LAST_UPDATED_BY := FND_GLOBAL.user_id;
4325: l_Trxn_Tab(indx).CREATION_DATE := sysdate;
4326: l_Trxn_Tab(indx).CREATED_BY := FND_GLOBAL.user_id;
4327: l_Trxn_Tab(indx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;
4328:
4329:
4330: -- New columns start here

Line 4327: l_Trxn_Tab(indx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;

4323: l_Trxn_Tab(indx).LAST_UPDATE_DATE := sysdate;
4324: l_Trxn_Tab(indx).LAST_UPDATED_BY := FND_GLOBAL.user_id;
4325: l_Trxn_Tab(indx).CREATION_DATE := sysdate;
4326: l_Trxn_Tab(indx).CREATED_BY := FND_GLOBAL.user_id;
4327: l_Trxn_Tab(indx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;
4328:
4329:
4330: -- New columns start here
4331: l_Trxn_Tab(indx).PAYER_PARTY_ID := l_settlement_trxn_rec.payer_party_id;

Line 4377: l_TrxnCore_Tab(trxnCoreIndx).last_updated_by := FND_GLOBAL.user_id;

4373: l_TrxnCore_Tab(trxnCoreIndx).TrxnMID := l_settlement_trxn_rec.TRXNMID;
4374: l_TrxnCore_Tab(trxnCoreIndx).REFERENCECODE := l_settlement_trxn_rec.TRXN_REF_NUMBER1;
4375: l_TrxnCore_Tab(trxnCoreIndx).PONumber := l_settlement_trxn_rec.PO_NUMBER;
4376: l_TrxnCore_Tab(trxnCoreIndx).last_update_date := sysdate;
4377: l_TrxnCore_Tab(trxnCoreIndx).last_updated_by := FND_GLOBAL.user_id;
4378: l_TrxnCore_Tab(trxnCoreIndx).creation_date := sysdate;
4379: l_TrxnCore_Tab(trxnCoreIndx).created_by := FND_GLOBAL.user_id;
4380: l_TrxnCore_Tab(trxnCoreIndx).last_update_login := FND_GLOBAL.login_id;
4381: l_TrxnCore_Tab(trxnCoreIndx).object_version_number := 1.0;

Line 4379: l_TrxnCore_Tab(trxnCoreIndx).created_by := FND_GLOBAL.user_id;

4375: l_TrxnCore_Tab(trxnCoreIndx).PONumber := l_settlement_trxn_rec.PO_NUMBER;
4376: l_TrxnCore_Tab(trxnCoreIndx).last_update_date := sysdate;
4377: l_TrxnCore_Tab(trxnCoreIndx).last_updated_by := FND_GLOBAL.user_id;
4378: l_TrxnCore_Tab(trxnCoreIndx).creation_date := sysdate;
4379: l_TrxnCore_Tab(trxnCoreIndx).created_by := FND_GLOBAL.user_id;
4380: l_TrxnCore_Tab(trxnCoreIndx).last_update_login := FND_GLOBAL.login_id;
4381: l_TrxnCore_Tab(trxnCoreIndx).object_version_number := 1.0;
4382:
4383: trxnCoreIndx := trxnCoreIndx + 1;

Line 4380: l_TrxnCore_Tab(trxnCoreIndx).last_update_login := FND_GLOBAL.login_id;

4376: l_TrxnCore_Tab(trxnCoreIndx).last_update_date := sysdate;
4377: l_TrxnCore_Tab(trxnCoreIndx).last_updated_by := FND_GLOBAL.user_id;
4378: l_TrxnCore_Tab(trxnCoreIndx).creation_date := sysdate;
4379: l_TrxnCore_Tab(trxnCoreIndx).created_by := FND_GLOBAL.user_id;
4380: l_TrxnCore_Tab(trxnCoreIndx).last_update_login := FND_GLOBAL.login_id;
4381: l_TrxnCore_Tab(trxnCoreIndx).object_version_number := 1.0;
4382:
4383: trxnCoreIndx := trxnCoreIndx + 1;
4384: END IF;

Line 4678: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

4674: last_update_login, object_version_number
4675: )
4676: VALUES
4677: (p_trxn_entity_id, lx_creditresp.Trxn_Id,
4678: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4679: fnd_global.login_id, 1
4680: );
4681: --
4682: -- back-propagate the credit

Line 4679: fnd_global.login_id, 1

4675: )
4676: VALUES
4677: (p_trxn_entity_id, lx_creditresp.Trxn_Id,
4678: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4679: fnd_global.login_id, 1
4680: );
4681: --
4682: -- back-propagate the credit
4683: --

Line 4690: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

4686: created_by, creation_date, last_updated_by, last_update_date,
4687: last_update_login, object_version_number
4688: )
4689: SELECT source_trxn_extension_id, lx_creditresp.Trxn_Id,
4690: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4691: fnd_global.login_id, 1
4692: FROM iby_fndcpt_tx_xe_copies
4693: START WITH copy_trxn_extension_id = p_trxn_entity_id
4694: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;

Line 4691: fnd_global.login_id, 1

4687: last_update_login, object_version_number
4688: )
4689: SELECT source_trxn_extension_id, lx_creditresp.Trxn_Id,
4690: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4691: fnd_global.login_id, 1
4692: FROM iby_fndcpt_tx_xe_copies
4693: START WITH copy_trxn_extension_id = p_trxn_entity_id
4694: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
4695:

Line 4916: last_updated_by = fnd_global.user_id,

4912: SET
4913: instrument_security_code = LPAD('X',LENGTH(instrument_security_code),'X'),
4914: encrypted = 'Y',
4915: instr_code_sec_segment_id = lx_segment_id,
4916: last_updated_by = fnd_global.user_id,
4917: last_update_date = SYSDATE,
4918: last_update_login = fnd_global.login_id,
4919: object_version_number = object_version_number + 1
4920: WHERE trxn_extension_id = c_ext_rec.trxn_extension_id;

Line 4918: last_update_login = fnd_global.login_id,

4914: encrypted = 'Y',
4915: instr_code_sec_segment_id = lx_segment_id,
4916: last_updated_by = fnd_global.user_id,
4917: last_update_date = SYSDATE,
4918: last_update_login = fnd_global.login_id,
4919: object_version_number = object_version_number + 1
4920: WHERE trxn_extension_id = c_ext_rec.trxn_extension_id;
4921: END LOOP;
4922:

Line 5009: last_updated_by = fnd_global.user_id,

5005: c_ext_rec.segment_cipher_text,
5006: c_ext_rec.instr_sec_code_length),
5007: encrypted = 'N',
5008: instr_code_sec_segment_id = NULL,
5009: last_updated_by = fnd_global.user_id,
5010: last_update_date = SYSDATE,
5011: last_update_login = fnd_global.login_id,
5012: object_version_number = object_version_number + 1
5013: WHERE trxn_extension_id = c_ext_rec.trxn_extension_id;

Line 5011: last_update_login = fnd_global.login_id,

5007: encrypted = 'N',
5008: instr_code_sec_segment_id = NULL,
5009: last_updated_by = fnd_global.user_id,
5010: last_update_date = SYSDATE,
5011: last_update_login = fnd_global.login_id,
5012: object_version_number = object_version_number + 1
5013: WHERE trxn_extension_id = c_ext_rec.trxn_extension_id;
5014:
5015: DELETE iby_security_segments