APPS.PSA_BC_XML_REPORT_PUB dependencies on DBMS_LOB

Line 3137: IF DBMS_LOB.getlength(p_trxs) IS NULL THEN

3133:
3134: -- Process the XML data source and save to output file
3135: psa_utils.debug_other_string(g_state_level,l_api_name,'construct both');
3136:
3137: IF DBMS_LOB.getlength(p_trxs) IS NULL THEN
3138: psa_utils.debug_other_string(g_state_level,l_api_name,' NO DATA FOUND - No XML Output Generated');
3139: ELSE
3140: -- trim header of trxs
3141: -- save trxs

Line 3142: l_offset := DBMS_LOB.instr (lob_loc => p_trxs,

3138: psa_utils.debug_other_string(g_state_level,l_api_name,' NO DATA FOUND - No XML Output Generated');
3139: ELSE
3140: -- trim header of trxs
3141: -- save trxs
3142: l_offset := DBMS_LOB.instr (lob_loc => p_trxs,
3143: pattern => '?>',
3144: offset => 1,
3145: nth => 1);
3146: psa_utils.debug_other_string(g_state_level,l_api_name,'l_offset' || ' = ' || l_offset);

Line 3218: l_length := DBMS_LOB.getlength(p_trxs);

3214:
3215: -- Initialize API return status to success
3216: x_return_status := FND_API.G_RET_STS_SUCCESS;
3217:
3218: l_length := DBMS_LOB.getlength(p_trxs);
3219:
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);

Line 3237: DBMS_LOB.read(p_trxs, l_amount, l_pos, l_buffer);

3233:
3234: /* commit; remove this */
3235: WHILE (l_pos <= l_length)
3236: LOOP
3237: DBMS_LOB.read(p_trxs, l_amount, l_pos, l_buffer);
3238: FND_FILE.put(FND_FILE.output, l_buffer);
3239: l_pos := l_pos + l_amount;
3240: END LOOP;
3241: