DBA Data[Home] [Help]

APPS.IBY_FNDCPT_TRXN_PUB dependencies on FND_GLOBAL

Line 1306: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

1302: p_trxn_attribs.Trxn_Ref_Number1, p_trxn_attribs.Trxn_Ref_Number2,
1303: p_trxn_attribs.Additional_Info,
1304: length(p_trxn_attribs.Instrument_Security_Code), l_encrypted,
1305: l_segment_id,
1306: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
1307: fnd_global.login_id, 1, p_trxn_attribs.seq_type_last
1308: );
1309: END IF;
1310:

Line 1307: fnd_global.login_id, 1, p_trxn_attribs.seq_type_last

1303: p_trxn_attribs.Additional_Info,
1304: length(p_trxn_attribs.Instrument_Security_Code), l_encrypted,
1305: l_segment_id,
1306: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
1307: fnd_global.login_id, 1, p_trxn_attribs.seq_type_last
1308: );
1309: END IF;
1310:
1311: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;

Line 1735: last_updated_by = fnd_global.user_id,

1731: p_trxn_attribs.Trxn_Ref_Number2),
1732: additional_info = DECODE(p_trxn_attribs.Additional_Info,
1733: FND_API.G_MISS_CHAR,NULL, NULL,additional_info,
1734: p_trxn_attribs.Additional_Info),
1735: last_updated_by = fnd_global.user_id,
1736: last_update_date = SYSDATE,
1737: last_update_login = fnd_global.login_id,
1738: object_version_number = object_version_number + 1
1739: WHERE (trxn_extension_id = p_entity_id);

Line 1737: last_update_login = fnd_global.login_id,

1733: FND_API.G_MISS_CHAR,NULL, NULL,additional_info,
1734: p_trxn_attribs.Additional_Info),
1735: last_updated_by = fnd_global.user_id,
1736: last_update_date = SYSDATE,
1737: last_update_login = fnd_global.login_id,
1738: object_version_number = object_version_number + 1
1739: WHERE (trxn_extension_id = p_entity_id);
1740:
1741: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2615: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

2611: l_extension.Order_Id, l_extension.PO_Number,
2612: l_extension.PO_Line_Number,
2613: l_extension.Trxn_Ref_Number1, l_extension.Trxn_Ref_Number2,
2614: l_extension.Additional_Info,
2615: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2616: fnd_global.login_id, 1, lc_PSON,
2617: p_trxn_attribs.seq_type_last
2618: );
2619: --End of Bug : 8612180

Line 2616: fnd_global.login_id, 1, lc_PSON,

2612: l_extension.PO_Line_Number,
2613: l_extension.Trxn_Ref_Number1, l_extension.Trxn_Ref_Number2,
2614: l_extension.Additional_Info,
2615: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2616: fnd_global.login_id, 1, lc_PSON,
2617: p_trxn_attribs.seq_type_last
2618: );
2619: --End of Bug : 8612180
2620:

Line 2631: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

2627: last_update_login, object_version_number
2628: )
2629: VALUES
2630: (p_entities(i), x_entity_id,
2631: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2632: fnd_global.login_id, 1
2633: );
2634:
2635: -- only the first copy receives an operations for the extension

Line 2632: fnd_global.login_id, 1

2628: )
2629: VALUES
2630: (p_entities(i), x_entity_id,
2631: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2632: fnd_global.login_id, 1
2633: );
2634:
2635: -- only the first copy receives an operations for the extension
2636: IF (l_copy_count < 1) THEN

Line 2649: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

2645: )
2646: -- instrument may change during copy
2647: SELECT
2648: x_entity_id, transactionid,
2649: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2650: fnd_global.login_id, 1
2651: FROM iby_fndcpt_tx_operations
2652: WHERE trxn_extension_id = p_entities(i);
2653: END IF;

Line 2650: fnd_global.login_id, 1

2646: -- instrument may change during copy
2647: SELECT
2648: x_entity_id, transactionid,
2649: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2650: fnd_global.login_id, 1
2651: FROM iby_fndcpt_tx_operations
2652: WHERE trxn_extension_id = p_entities(i);
2653: END IF;
2654: END LOOP;

Line 3210: last_updated_by = fnd_global.user_id,

3206: UPDATE iby_fndcpt_tx_extensions
3207: SET instrument_security_code = NULL,
3208: --instr_sec_code_length = NULL,
3209: encrypted = 'N',
3210: last_updated_by = fnd_global.user_id,
3211: last_update_date = SYSDATE,
3212: last_update_login = fnd_global.login_id,
3213: object_version_number = object_version_number + 1
3214: WHERE trxn_extension_id = p_trxn_entity_id;

Line 3212: last_update_login = fnd_global.login_id,

3208: --instr_sec_code_length = NULL,
3209: encrypted = 'N',
3210: last_updated_by = fnd_global.user_id,
3211: last_update_date = SYSDATE,
3212: last_update_login = fnd_global.login_id,
3213: object_version_number = object_version_number + 1
3214: WHERE trxn_extension_id = p_trxn_entity_id;
3215:
3216: UPDATE iby_fndcpt_tx_extensions

Line 3220: last_updated_by = fnd_global.user_id,

3216: UPDATE iby_fndcpt_tx_extensions
3217: SET instrument_security_code = NULL,
3218: --instr_sec_code_length = NULL,
3219: encrypted = 'N',
3220: last_updated_by = fnd_global.user_id,
3221: last_update_date = SYSDATE,
3222: last_update_login = fnd_global.login_id,
3223: object_version_number = object_version_number + 1
3224: WHERE trxn_extension_id IN

Line 3222: last_update_login = fnd_global.login_id,

3218: --instr_sec_code_length = NULL,
3219: encrypted = 'N',
3220: last_updated_by = fnd_global.user_id,
3221: last_update_date = SYSDATE,
3222: last_update_login = fnd_global.login_id,
3223: object_version_number = object_version_number + 1
3224: WHERE trxn_extension_id IN
3225: (SELECT source_trxn_extension_id
3226: FROM iby_fndcpt_tx_xe_copies

Line 3322: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

3318: last_update_login, object_version_number
3319: )
3320: VALUES
3321: (p_trxn_entity_id, l_reqresp.Trxn_Id,
3322: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3323: fnd_global.login_id, 1
3324: );
3325:
3326: --

Line 3323: fnd_global.login_id, 1

3319: )
3320: VALUES
3321: (p_trxn_entity_id, l_reqresp.Trxn_Id,
3322: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3323: fnd_global.login_id, 1
3324: );
3325:
3326: --
3327: -- back-propagate the authorization

Line 3335: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

3331: created_by, creation_date, last_updated_by, last_update_date,
3332: last_update_login, object_version_number
3333: )
3334: SELECT source_trxn_extension_id, l_reqresp.Trxn_Id,
3335: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3336: fnd_global.login_id, 1
3337: FROM iby_fndcpt_tx_xe_copies
3338: START WITH copy_trxn_extension_id = p_trxn_entity_id
3339: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;

Line 3336: fnd_global.login_id, 1

3332: last_update_login, object_version_number
3333: )
3334: SELECT source_trxn_extension_id, l_reqresp.Trxn_Id,
3335: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3336: fnd_global.login_id, 1
3337: FROM iby_fndcpt_tx_xe_copies
3338: START WITH copy_trxn_extension_id = p_trxn_entity_id
3339: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
3340:

Line 3354: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

3350: created_by, creation_date, last_updated_by, last_update_date,
3351: last_update_login, object_version_number
3352: )
3353: SELECT copy_trxn_extension_id, l_reqresp.Trxn_Id,
3354: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3355: fnd_global.login_id, 1
3356: FROM iby_fndcpt_tx_xe_copies
3357: START WITH source_trxn_extension_id = p_trxn_entity_id
3358: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;

Line 3355: fnd_global.login_id, 1

3351: last_update_login, object_version_number
3352: )
3353: SELECT copy_trxn_extension_id, l_reqresp.Trxn_Id,
3354: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3355: fnd_global.login_id, 1
3356: FROM iby_fndcpt_tx_xe_copies
3357: START WITH source_trxn_extension_id = p_trxn_entity_id
3358: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
3359:

Line 4095: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

4091: last_update_login, object_version_number
4092: )
4093: VALUES
4094: (p_trxn_entity_id, l_reqresp.Trxn_Id,
4095: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4096: fnd_global.login_id, 1
4097: );
4098:
4099: --

Line 4096: fnd_global.login_id, 1

4092: )
4093: VALUES
4094: (p_trxn_entity_id, l_reqresp.Trxn_Id,
4095: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4096: fnd_global.login_id, 1
4097: );
4098:
4099: --
4100: -- back-propagate the authorization

Line 4108: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

4104: created_by, creation_date, last_updated_by, last_update_date,
4105: last_update_login, object_version_number
4106: )
4107: SELECT source_trxn_extension_id, l_reqresp.Trxn_Id,
4108: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4109: fnd_global.login_id, 1
4110: FROM iby_fndcpt_tx_xe_copies
4111: START WITH copy_trxn_extension_id = p_trxn_entity_id
4112: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;

Line 4109: fnd_global.login_id, 1

4105: last_update_login, object_version_number
4106: )
4107: SELECT source_trxn_extension_id, l_reqresp.Trxn_Id,
4108: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4109: fnd_global.login_id, 1
4110: FROM iby_fndcpt_tx_xe_copies
4111: START WITH copy_trxn_extension_id = p_trxn_entity_id
4112: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
4113:

Line 4128: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

4124: created_by, creation_date, last_updated_by, last_update_date,
4125: last_update_login, object_version_number
4126: )
4127: SELECT copy_trxn_extension_id, l_reqresp.Trxn_Id,
4128: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4129: fnd_global.login_id, 1
4130: FROM iby_fndcpt_tx_xe_copies
4131: START WITH source_trxn_extension_id = p_trxn_entity_id
4132: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;

Line 4129: fnd_global.login_id, 1

4125: last_update_login, object_version_number
4126: )
4127: SELECT copy_trxn_extension_id, l_reqresp.Trxn_Id,
4128: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4129: fnd_global.login_id, 1
4130: FROM iby_fndcpt_tx_xe_copies
4131: START WITH source_trxn_extension_id = p_trxn_entity_id
4132: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
4133:

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

5083: l_Tangible_Tab(tangibleIndx).MTANGIBLEID := l_mtangible;
5084: l_Tangible_Tab(tangibleIndx).TANGIBLEID := l_Trxn_Tab(indx).TANGIBLEID;
5085: l_Tangible_Tab(tangibleIndx).AMOUNT := l_settlement_trxn_rec.SETTLEMENT_AMOUNT;
5086: l_Tangible_Tab(tangibleIndx).CURRENCYNAMECODE := l_settlement_trxn_rec.SETTLEMENT_CURRENCY_CODE;
5087: l_Tangible_Tab(tangibleIndx).CREATED_BY := FND_GLOBAL.user_id;
5088: l_Tangible_Tab(tangibleIndx).CREATION_DATE := sysdate;
5089: l_Tangible_Tab(tangibleIndx).LAST_UPDATED_BY := FND_GLOBAL.user_id;
5090: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_DATE := sysdate;
5091: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;

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

5085: l_Tangible_Tab(tangibleIndx).AMOUNT := l_settlement_trxn_rec.SETTLEMENT_AMOUNT;
5086: l_Tangible_Tab(tangibleIndx).CURRENCYNAMECODE := l_settlement_trxn_rec.SETTLEMENT_CURRENCY_CODE;
5087: l_Tangible_Tab(tangibleIndx).CREATED_BY := FND_GLOBAL.user_id;
5088: l_Tangible_Tab(tangibleIndx).CREATION_DATE := sysdate;
5089: l_Tangible_Tab(tangibleIndx).LAST_UPDATED_BY := FND_GLOBAL.user_id;
5090: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_DATE := sysdate;
5091: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;
5092: l_Tangible_Tab(tangibleIndx).OBJECT_VERSION_NUMBER := 1.0;
5093:

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

5087: l_Tangible_Tab(tangibleIndx).CREATED_BY := FND_GLOBAL.user_id;
5088: l_Tangible_Tab(tangibleIndx).CREATION_DATE := sysdate;
5089: l_Tangible_Tab(tangibleIndx).LAST_UPDATED_BY := FND_GLOBAL.user_id;
5090: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_DATE := sysdate;
5091: l_Tangible_Tab(tangibleIndx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;
5092: l_Tangible_Tab(tangibleIndx).OBJECT_VERSION_NUMBER := 1.0;
5093:
5094:
5095: --l_Tangible_Tab(tangibleIndx).SOURCE_OBJECT_TYPE_CODE :=

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

5284: l_Trxn_Tab(indx).OBJECT_VERSION_NUMBER := 1.0;
5285:
5286: l_Trxn_Tab(indx).TRXNREF := l_settlement_trxn_rec.TRXN_REF_NUMBER1;
5287: l_Trxn_Tab(indx).LAST_UPDATE_DATE := sysdate;
5288: l_Trxn_Tab(indx).LAST_UPDATED_BY := FND_GLOBAL.user_id;
5289: l_Trxn_Tab(indx).CREATION_DATE := sysdate;
5290: l_Trxn_Tab(indx).CREATED_BY := FND_GLOBAL.user_id;
5291: l_Trxn_Tab(indx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;
5292:

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

5286: l_Trxn_Tab(indx).TRXNREF := l_settlement_trxn_rec.TRXN_REF_NUMBER1;
5287: l_Trxn_Tab(indx).LAST_UPDATE_DATE := sysdate;
5288: l_Trxn_Tab(indx).LAST_UPDATED_BY := FND_GLOBAL.user_id;
5289: l_Trxn_Tab(indx).CREATION_DATE := sysdate;
5290: l_Trxn_Tab(indx).CREATED_BY := FND_GLOBAL.user_id;
5291: l_Trxn_Tab(indx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;
5292:
5293:
5294: -- New columns start here

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

5287: l_Trxn_Tab(indx).LAST_UPDATE_DATE := sysdate;
5288: l_Trxn_Tab(indx).LAST_UPDATED_BY := FND_GLOBAL.user_id;
5289: l_Trxn_Tab(indx).CREATION_DATE := sysdate;
5290: l_Trxn_Tab(indx).CREATED_BY := FND_GLOBAL.user_id;
5291: l_Trxn_Tab(indx).LAST_UPDATE_LOGIN := FND_GLOBAL.login_id;
5292:
5293:
5294: -- New columns start here
5295: l_Trxn_Tab(indx).PAYER_PARTY_ID := l_settlement_trxn_rec.payer_party_id;

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

5397: l_TrxnCore_Tab(trxnCoreIndx).TrxnMID := l_settlement_trxn_rec.TRXNMID;
5398: l_TrxnCore_Tab(trxnCoreIndx).REFERENCECODE := l_settlement_trxn_rec.TRXN_REF_NUMBER1;
5399: l_TrxnCore_Tab(trxnCoreIndx).PONumber := l_settlement_trxn_rec.PO_NUMBER;
5400: l_TrxnCore_Tab(trxnCoreIndx).last_update_date := sysdate;
5401: l_TrxnCore_Tab(trxnCoreIndx).last_updated_by := FND_GLOBAL.user_id;
5402: l_TrxnCore_Tab(trxnCoreIndx).creation_date := sysdate;
5403: l_TrxnCore_Tab(trxnCoreIndx).created_by := FND_GLOBAL.user_id;
5404: l_TrxnCore_Tab(trxnCoreIndx).last_update_login := FND_GLOBAL.login_id;
5405: l_TrxnCore_Tab(trxnCoreIndx).object_version_number := 1.0;

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

5399: l_TrxnCore_Tab(trxnCoreIndx).PONumber := l_settlement_trxn_rec.PO_NUMBER;
5400: l_TrxnCore_Tab(trxnCoreIndx).last_update_date := sysdate;
5401: l_TrxnCore_Tab(trxnCoreIndx).last_updated_by := FND_GLOBAL.user_id;
5402: l_TrxnCore_Tab(trxnCoreIndx).creation_date := sysdate;
5403: l_TrxnCore_Tab(trxnCoreIndx).created_by := FND_GLOBAL.user_id;
5404: l_TrxnCore_Tab(trxnCoreIndx).last_update_login := FND_GLOBAL.login_id;
5405: l_TrxnCore_Tab(trxnCoreIndx).object_version_number := 1.0;
5406: l_TrxnCore_Tab(trxnCoreIndx).card_subtype_code := l_settlement_trxn_rec.card_subtype_code ;
5407: l_TrxnCore_Tab(trxnCoreIndx).card_data_level := l_settlement_trxn_rec.card_data_level;

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

5400: l_TrxnCore_Tab(trxnCoreIndx).last_update_date := sysdate;
5401: l_TrxnCore_Tab(trxnCoreIndx).last_updated_by := FND_GLOBAL.user_id;
5402: l_TrxnCore_Tab(trxnCoreIndx).creation_date := sysdate;
5403: l_TrxnCore_Tab(trxnCoreIndx).created_by := FND_GLOBAL.user_id;
5404: l_TrxnCore_Tab(trxnCoreIndx).last_update_login := FND_GLOBAL.login_id;
5405: l_TrxnCore_Tab(trxnCoreIndx).object_version_number := 1.0;
5406: l_TrxnCore_Tab(trxnCoreIndx).card_subtype_code := l_settlement_trxn_rec.card_subtype_code ;
5407: l_TrxnCore_Tab(trxnCoreIndx).card_data_level := l_settlement_trxn_rec.card_data_level;
5408:

Line 5800: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

5796: last_update_login, object_version_number
5797: )
5798: VALUES
5799: (p_trxn_entity_id, lx_creditresp.Trxn_Id,
5800: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
5801: fnd_global.login_id, 1
5802: );
5803: --
5804: -- back-propagate the credit

Line 5801: fnd_global.login_id, 1

5797: )
5798: VALUES
5799: (p_trxn_entity_id, lx_creditresp.Trxn_Id,
5800: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
5801: fnd_global.login_id, 1
5802: );
5803: --
5804: -- back-propagate the credit
5805: --

Line 5812: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

5808: created_by, creation_date, last_updated_by, last_update_date,
5809: last_update_login, object_version_number
5810: )
5811: SELECT source_trxn_extension_id, lx_creditresp.Trxn_Id,
5812: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
5813: fnd_global.login_id, 1
5814: FROM iby_fndcpt_tx_xe_copies
5815: START WITH copy_trxn_extension_id = p_trxn_entity_id
5816: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;

Line 5813: fnd_global.login_id, 1

5809: last_update_login, object_version_number
5810: )
5811: SELECT source_trxn_extension_id, lx_creditresp.Trxn_Id,
5812: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
5813: fnd_global.login_id, 1
5814: FROM iby_fndcpt_tx_xe_copies
5815: START WITH copy_trxn_extension_id = p_trxn_entity_id
5816: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
5817:

Line 6633: last_updated_by = fnd_global.user_id,

6629: SET
6630: instrument_security_code = LPAD('X',LENGTH(instrument_security_code),'X'),
6631: encrypted = 'Y',
6632: instr_code_sec_segment_id = lx_segment_id,
6633: last_updated_by = fnd_global.user_id,
6634: last_update_date = SYSDATE,
6635: last_update_login = fnd_global.login_id,
6636: object_version_number = object_version_number + 1
6637: WHERE trxn_extension_id = c_ext_rec.trxn_extension_id;

Line 6635: last_update_login = fnd_global.login_id,

6631: encrypted = 'Y',
6632: instr_code_sec_segment_id = lx_segment_id,
6633: last_updated_by = fnd_global.user_id,
6634: last_update_date = SYSDATE,
6635: last_update_login = fnd_global.login_id,
6636: object_version_number = object_version_number + 1
6637: WHERE trxn_extension_id = c_ext_rec.trxn_extension_id;
6638: ELSE
6639: fnd_file.put_line(fnd_file.log,'Could not encrypt the extension '|| c_ext_rec.trxn_extension_id

Line 6747: last_updated_by = fnd_global.user_id,

6743: c_ext_rec.segment_cipher_text,
6744: c_ext_rec.instr_sec_code_length),
6745: encrypted = 'N',
6746: instr_code_sec_segment_id = NULL,
6747: last_updated_by = fnd_global.user_id,
6748: last_update_date = SYSDATE,
6749: last_update_login = fnd_global.login_id,
6750: object_version_number = object_version_number + 1
6751: WHERE trxn_extension_id = c_ext_rec.trxn_extension_id;

Line 6749: last_update_login = fnd_global.login_id,

6745: encrypted = 'N',
6746: instr_code_sec_segment_id = NULL,
6747: last_updated_by = fnd_global.user_id,
6748: last_update_date = SYSDATE,
6749: last_update_login = fnd_global.login_id,
6750: object_version_number = object_version_number + 1
6751: WHERE trxn_extension_id = c_ext_rec.trxn_extension_id;
6752:
6753: DELETE iby_security_segments