DBA Data[Home] [Help]

APPS.EDR_UTILITIES dependencies on EDR_RAW_XML_T

Line 1584: --This method is used to save the raw xml run-time data in the table EDR_RAW_XML_T

1580: P_PAYLOAD_TYPE => 'ERECORDPAYLOAD'
1581: );
1582: end XSLT_TRANSFORMATION;
1583:
1584: --This method is used to save the raw xml run-time data in the table EDR_RAW_XML_T
1585: --This API is called when the developer mode is on.
1586: PROCEDURE SAVE_RAW_XML( P_TRANSACTION_NAME IN VARCHAR2,
1587: P_TRANSACTION_KEY IN VARCHAR2,
1588: P_RAW_XML CLOB)

Line 1598: from EDR_RAW_XML_T

1594: BEGIN
1595:
1596: --Verify if the row already exists with the given event name and event key
1597: select count(*) into L_count_Value
1598: from EDR_RAW_XML_T
1599: where event_name = p_transaction_name
1600: and event_key = p_transaction_key;
1601:
1602:

Line 1606: update EDR_RAW_XML_T set RAW_XML = P_RAW_XML,

1602:
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:

Line 1617: insert into EDR_RAW_XML_T(EVENT_NAME,

1613:
1614: else
1615: --No row exists with the specified event name and event key.
1616: --There insert a row into the table with the required details
1617: insert into EDR_RAW_XML_T(EVENT_NAME,
1618: EVENT_KEY,
1619: RAW_XML,
1620: CREATED_BY,
1621: CREATION_DATE,