784: last_update_login out nocopy number)
785: is
786: begin
787: creation_date := sysdate;
788: created_by := fnd_global.user_id();
789: last_update_date := sysdate;
790: last_updated_by := fnd_global.user_id();
791: last_update_login := fnd_global.login_id();
792:
786: begin
787: creation_date := sysdate;
788: created_by := fnd_global.user_id();
789: last_update_date := sysdate;
790: last_updated_by := fnd_global.user_id();
791: last_update_login := fnd_global.login_id();
792:
793: end getWhoColumns;
794:
787: creation_date := sysdate;
788: created_by := fnd_global.user_id();
789: last_update_date := sysdate;
790: last_updated_by := fnd_global.user_id();
791: last_update_login := fnd_global.login_id();
792:
793: end getWhoColumns;
794:
795: --Bug 3164491: start
1603: if(L_count_value > 0) then
1604: --Row already exists with the specified event name and event key.
1605: --There update the row.
1606: update EDR_RAW_XML_T set RAW_XML = P_RAW_XML,
1607: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1608: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1609: LAST_UPDATE_DATE = sysdate
1610:
1611: where event_name = p_transaction_name
1604: --Row already exists with the specified event name and event key.
1605: --There update the row.
1606: update EDR_RAW_XML_T set RAW_XML = P_RAW_XML,
1607: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1608: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1609: LAST_UPDATE_DATE = sysdate
1610:
1611: where event_name = p_transaction_name
1612: and event_key = p_transaction_key;
1625: )
1626: values ( p_transaction_name,
1627: p_transaction_key,
1628: p_raw_xml,
1629: FND_GLOBAL.USER_ID,
1630: sysdate,
1631: FND_GLOBAL.USER_ID,
1632: FND_GLOBAL.LOGIN_ID,
1633: sysdate
1627: p_transaction_key,
1628: p_raw_xml,
1629: FND_GLOBAL.USER_ID,
1630: sysdate,
1631: FND_GLOBAL.USER_ID,
1632: FND_GLOBAL.LOGIN_ID,
1633: sysdate
1634: );
1635: end if;
1628: p_raw_xml,
1629: FND_GLOBAL.USER_ID,
1630: sysdate,
1631: FND_GLOBAL.USER_ID,
1632: FND_GLOBAL.LOGIN_ID,
1633: sysdate
1634: );
1635: end if;
1636: --Commit the transaction.
2160: LAST_UPDATED_BY,
2161: LAST_UPDATE_DATE)
2162: values(P_XML_CLOB_ID,
2163: l_event_xml,
2164: fnd_global.user_id,
2165: sysdate,
2166: fnd_global.user_id,
2167: sysdate);
2168:
2162: values(P_XML_CLOB_ID,
2163: l_event_xml,
2164: fnd_global.user_id,
2165: sysdate,
2166: fnd_global.user_id,
2167: sysdate);
2168:
2169: END GENERATE_EVENT_PAYLOAD;
2170: --Bug 3893101: End