eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FPA_PORTFOLIO_PVT dependencies on DBMS_AW

Line 54: dbms_aw.execute('MAINTAIN portfolio_d ADD '|| portfolio_s_r.portfolio_id );

50:
51: -- Change it to handle for exception seciton *****
52:
53: -- Add the new portfolio to the dimension
54: dbms_aw.execute('MAINTAIN portfolio_d ADD '|| portfolio_s_r.portfolio_id );
55: dbms_aw.execute('LMT portfolio_d TO '|| portfolio_s_r.portfolio_id );
56: dbms_aw.execute('portfolio_class_code_m='|| p_portfolio_rec.portfolio_type );
57:
58: -- check if the organization is null , then update with NA

Line 55: dbms_aw.execute('LMT portfolio_d TO '|| portfolio_s_r.portfolio_id );

51: -- Change it to handle for exception seciton *****
52:
53: -- Add the new portfolio to the dimension
54: dbms_aw.execute('MAINTAIN portfolio_d ADD '|| portfolio_s_r.portfolio_id );
55: dbms_aw.execute('LMT portfolio_d TO '|| portfolio_s_r.portfolio_id );
56: dbms_aw.execute('portfolio_class_code_m='|| p_portfolio_rec.portfolio_type );
57:
58: -- check if the organization is null , then update with NA
59: IF p_portfolio_rec.portfolio_start_org_id IS NULL THEN

Line 56: dbms_aw.execute('portfolio_class_code_m='|| p_portfolio_rec.portfolio_type );

52:
53: -- Add the new portfolio to the dimension
54: dbms_aw.execute('MAINTAIN portfolio_d ADD '|| portfolio_s_r.portfolio_id );
55: dbms_aw.execute('LMT portfolio_d TO '|| portfolio_s_r.portfolio_id );
56: dbms_aw.execute('portfolio_class_code_m='|| p_portfolio_rec.portfolio_type );
57:
58: -- check if the organization is null , then update with NA
59: IF p_portfolio_rec.portfolio_start_org_id IS NULL THEN
60: dbms_aw.execute('portfolio_organization_m = NA');

Line 60: dbms_aw.execute('portfolio_organization_m = NA');

56: dbms_aw.execute('portfolio_class_code_m='|| p_portfolio_rec.portfolio_type );
57:
58: -- check if the organization is null , then update with NA
59: IF p_portfolio_rec.portfolio_start_org_id IS NULL THEN
60: dbms_aw.execute('portfolio_organization_m = NA');
61: ELSE
62: dbms_aw.execute('portfolio_organization_m= '|| p_portfolio_rec.portfolio_start_org_id );
63: END IF;
64:

Line 62: dbms_aw.execute('portfolio_organization_m= '|| p_portfolio_rec.portfolio_start_org_id );

58: -- check if the organization is null , then update with NA
59: IF p_portfolio_rec.portfolio_start_org_id IS NULL THEN
60: dbms_aw.execute('portfolio_organization_m = NA');
61: ELSE
62: dbms_aw.execute('portfolio_organization_m= '|| p_portfolio_rec.portfolio_start_org_id );
63: END IF;
64:
65:
66: --dbms_output.put_line('owner id is'||p_portfolio_rec.portfolio_owner_id);

Line 70: dbms_aw.execute('MAINTAIN person_id_d ADD '|| p_portfolio_rec.portfolio_owner_id);

66: --dbms_output.put_line('owner id is'||p_portfolio_rec.portfolio_owner_id);
67: -- the below is deperecated , as the person id will nto be mainted in the AW
68: /*
69: BEGIN
70: dbms_aw.execute('MAINTAIN person_id_d ADD '|| p_portfolio_rec.portfolio_owner_id);
71: EXCEPTION
72: WHEN OTHERS THEN
73: --dbms_output.put_line(SQLCODE);
74: -- Check for existing dim values, if it already exists during MAINTAIN, then ignore it.

Line 80: dbms_aw.execute('owner_portfolio_r= '|| p_portfolio_rec.portfolio_owner_id);

76: NULL;
77: END IF;
78: END;
79:
80: dbms_aw.execute('owner_portfolio_r= '|| p_portfolio_rec.portfolio_owner_id);
81: */
82:
83: IF (c_language%ISOPEN) THEN
84: CLOSE c_language;

Line 196: dbms_aw.Execute('maintain portfolio_d delete ' || p_portfolio_id );

192: );
193: END IF;
194:
195: -- Delete the portfolio from the AW space.
196: dbms_aw.Execute('maintain portfolio_d delete ' || p_portfolio_id );
197: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
198: fnd_log.string
199: (
200: FND_LOG.LEVEL_PROCEDURE,

Line 340: dbms_aw.execute('LMT portfolio_d TO '||p_portfolio_id);

336: 'Entering fpa_portfolo_pvt.update_portfolio_type'
337: );
338: END IF;
339: -- Update name and description
340: dbms_aw.execute('LMT portfolio_d TO '||p_portfolio_id);
341: dbms_aw.execute('portfolio_class_code_m='|| p_portfolio_class_code );
342:
343: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
344: fnd_log.string

Line 341: dbms_aw.execute('portfolio_class_code_m='|| p_portfolio_class_code );

337: );
338: END IF;
339: -- Update name and description
340: dbms_aw.execute('LMT portfolio_d TO '||p_portfolio_id);
341: dbms_aw.execute('portfolio_class_code_m='|| p_portfolio_class_code );
342:
343: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
344: fnd_log.string
345: (

Line 399: dbms_aw.execute('LMT portfolio_d TO '||p_portfolio_id);

395: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_organization.begin',
396: 'Entering fpa_portfolo_pvt.update_portfolio_organization'
397: );
398: END IF;
399: dbms_aw.execute('LMT portfolio_d TO '||p_portfolio_id);
400: IF p_portfolio_organization IS NULL THEN
401: dbms_aw.execute('portfolio_organization_m = NA');
402: ELSE
403: dbms_aw.execute('portfolio_organization_m= '|| p_portfolio_organization );

Line 401: dbms_aw.execute('portfolio_organization_m = NA');

397: );
398: END IF;
399: dbms_aw.execute('LMT portfolio_d TO '||p_portfolio_id);
400: IF p_portfolio_organization IS NULL THEN
401: dbms_aw.execute('portfolio_organization_m = NA');
402: ELSE
403: dbms_aw.execute('portfolio_organization_m= '|| p_portfolio_organization );
404: END IF;
405:

Line 403: dbms_aw.execute('portfolio_organization_m= '|| p_portfolio_organization );

399: dbms_aw.execute('LMT portfolio_d TO '||p_portfolio_id);
400: IF p_portfolio_organization IS NULL THEN
401: dbms_aw.execute('portfolio_organization_m = NA');
402: ELSE
403: dbms_aw.execute('portfolio_organization_m= '|| p_portfolio_organization );
404: END IF;
405:
406: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
407: fnd_log.string