APPS.PSA_BC_XML_REPORT_PUB dependencies on PSA_BC_XML_CLOB

Line 3311: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table

3307: psa_utils.debug_other_string(g_state_level,l_api_name,'l_amount' || ' = ' || l_amount);
3308: psa_utils.debug_other_string(g_state_level,l_api_name,'l_length' || ' = ' || l_length);
3309: psa_utils.debug_other_string(g_state_level,l_api_name,'l_pos' || ' = ' || l_pos);
3310:
3311: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table
3312:
3313: IF x_source = 'FORM' THEN
3314: save_xml_to_db(x_return_status => x_return_status,
3315: p_application_id => p_application_id,

Line 3367: DELETE FROM psa_bc_xml_clob pbxc

3363: x_return_status := FND_API.G_RET_STS_SUCCESS;
3364:
3365: -- delete old data i.e. data for older expired sessions or created 1 day earlier
3366:
3367: DELETE FROM psa_bc_xml_clob pbxc
3368: WHERE (((SYSDATE - pbxc.creation_date) > 1) OR
3369: (NOT EXISTS (SELECT 'x'
3370: FROM v$session
3371: WHERE audsid = pbxc.session_id

Line 3375: 'No of rows deleted from psa_bc_xml_clob: '||SQL%ROWCOUNT);

3371: WHERE audsid = pbxc.session_id
3372: AND Serial# = pbxc.serial_id)));
3373:
3374: psa_utils.debug_other_string(g_state_level,l_api_name,
3375: 'No of rows deleted from psa_bc_xml_clob: '||SQL%ROWCOUNT);
3376:
3377:
3378: SELECT s.audsid, s.serial#
3379: INTO l_session_id, l_serial_id

Line 3384: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table

3380: FROM v$session s, v$process p
3381: WHERE s.paddr = p.addr
3382: AND audsid = USERENV('SESSIONID');
3383:
3384: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table
3385: INSERT INTO psa_bc_xml_clob(sequence_id, application_id, session_id, serial_id, creation_date, xml)
3386: VALUES (p_sequence_id, p_application_id, l_session_id, l_serial_id, sysdate, p_trxs);
3387:
3388: psa_utils.debug_other_string(g_state_level,l_api_name,

Line 3385: INSERT INTO psa_bc_xml_clob(sequence_id, application_id, session_id, serial_id, creation_date, xml)

3381: WHERE s.paddr = p.addr
3382: AND audsid = USERENV('SESSIONID');
3383:
3384: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table
3385: INSERT INTO psa_bc_xml_clob(sequence_id, application_id, session_id, serial_id, creation_date, xml)
3386: VALUES (p_sequence_id, p_application_id, l_session_id, l_serial_id, sysdate, p_trxs);
3387:
3388: psa_utils.debug_other_string(g_state_level,l_api_name,
3389: 'No of rows inserted into psa_bc_xml_clob: '||SQL%ROWCOUNT);

Line 3389: 'No of rows inserted into psa_bc_xml_clob: '||SQL%ROWCOUNT);

3385: INSERT INTO psa_bc_xml_clob(sequence_id, application_id, session_id, serial_id, creation_date, xml)
3386: VALUES (p_sequence_id, p_application_id, l_session_id, l_serial_id, sysdate, p_trxs);
3387:
3388: psa_utils.debug_other_string(g_state_level,l_api_name,
3389: 'No of rows inserted into psa_bc_xml_clob: '||SQL%ROWCOUNT);
3390:
3391: COMMIT;
3392:
3393: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml_to_db');