APPS.PSA_BC_XML_REPORT_PUB dependencies on DBMS_LOB

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

3220:
3221: -- Process the XML data source and save to output file
3222: psa_utils.debug_other_string(g_state_level,l_api_name,'construct both');
3223:
3224: IF DBMS_LOB.getlength(p_trxs) IS NULL THEN
3225: psa_utils.debug_other_string(g_state_level,l_api_name,' NO DATA FOUND - No XML Output Generated');
3226: ELSE
3227: -- trim header of trxs
3228: -- save trxs

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

3225: psa_utils.debug_other_string(g_state_level,l_api_name,' NO DATA FOUND - No XML Output Generated');
3226: ELSE
3227: -- trim header of trxs
3228: -- save trxs
3229: l_offset := DBMS_LOB.instr (lob_loc => p_trxs,
3230: pattern => '?>',
3231: offset => 1,
3232: nth => 1);
3233: psa_utils.debug_other_string(g_state_level,l_api_name,'l_offset' || ' = ' || l_offset);

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

3301:
3302: -- Initialize API return status to success
3303: x_return_status := FND_API.G_RET_STS_SUCCESS;
3304:
3305: l_length := DBMS_LOB.getlength(p_trxs);
3306:
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);

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

3320:
3321: /* commit; remove this */
3322: WHILE (l_pos <= l_length)
3323: LOOP
3324: DBMS_LOB.read(p_trxs, l_amount, l_pos, l_buffer);
3325: FND_FILE.put(FND_FILE.output, l_buffer);
3326: l_pos := l_pos + l_amount;
3327: END LOOP;
3328: