APPS.PSA_BC_XML_REPORT_PUB dependencies on PSA_BC_XML_CLOB

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

3220: psa_utils.debug_other_string(g_state_level,l_api_name,'l_amount' || ' = ' || l_amount);
3221: psa_utils.debug_other_string(g_state_level,l_api_name,'l_length' || ' = ' || l_length);
3222: psa_utils.debug_other_string(g_state_level,l_api_name,'l_pos' || ' = ' || l_pos);
3223:
3224: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table
3225:
3226: IF x_source = 'FORM' THEN
3227: save_xml_to_db(x_return_status => x_return_status,
3228: p_application_id => p_application_id,

Line 3280: DELETE FROM psa_bc_xml_clob pbxc

3276: x_return_status := FND_API.G_RET_STS_SUCCESS;
3277:
3278: -- delete old data i.e. data for older expired sessions or created 1 day earlier
3279:
3280: DELETE FROM psa_bc_xml_clob pbxc
3281: WHERE (((SYSDATE - pbxc.creation_date) > 1) OR
3282: (NOT EXISTS (SELECT 'x'
3283: FROM v$session
3284: WHERE audsid = pbxc.session_id

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

3284: WHERE audsid = pbxc.session_id
3285: AND Serial# = pbxc.serial_id)));
3286:
3287: psa_utils.debug_other_string(g_state_level,l_api_name,
3288: 'No of rows deleted from psa_bc_xml_clob: '||SQL%ROWCOUNT);
3289:
3290:
3291: SELECT s.audsid, s.serial#
3292: INTO l_session_id, l_serial_id

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

3293: FROM v$session s, v$process p
3294: WHERE s.paddr = p.addr
3295: AND audsid = USERENV('SESSIONID');
3296:
3297: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table
3298: INSERT INTO psa_bc_xml_clob(sequence_id, application_id, session_id, serial_id, creation_date, xml)
3299: VALUES (p_sequence_id, p_application_id, l_session_id, l_serial_id, sysdate, p_trxs);
3300:
3301: psa_utils.debug_other_string(g_state_level,l_api_name,

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

3294: WHERE s.paddr = p.addr
3295: AND audsid = USERENV('SESSIONID');
3296:
3297: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table
3298: INSERT INTO psa_bc_xml_clob(sequence_id, application_id, session_id, serial_id, creation_date, xml)
3299: VALUES (p_sequence_id, p_application_id, l_session_id, l_serial_id, sysdate, p_trxs);
3300:
3301: psa_utils.debug_other_string(g_state_level,l_api_name,
3302: 'No of rows inserted into psa_bc_xml_clob: '||SQL%ROWCOUNT);

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

3298: INSERT INTO psa_bc_xml_clob(sequence_id, application_id, session_id, serial_id, creation_date, xml)
3299: VALUES (p_sequence_id, p_application_id, l_session_id, l_serial_id, sysdate, p_trxs);
3300:
3301: psa_utils.debug_other_string(g_state_level,l_api_name,
3302: 'No of rows inserted into psa_bc_xml_clob: '||SQL%ROWCOUNT);
3303:
3304: COMMIT;
3305:
3306: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml_to_db');