APPS.IEX_STRATEGY_DIAG_REPORT dependencies on IEX_STRATEGY_WF

Line 79: l_competence_tab IEX_STRATEGY_WF.tab_of_comp_id;

75: is
76: l_resource_id number;
77: l_resource_name VARCHAR2(360);
78: l_Assignment_level varchar2(100);
79: l_competence_tab IEX_STRATEGY_WF.tab_of_comp_id;
80: l_index NUMBER :=1;
81: l_default_resource_id number;
82: bReturn Boolean;
83: l_party_id number;

Line 118: IEX_STRATEGY_WF.get_resource(p_party_id => l_party_id,

114:
115: if p_strategy_rec.object_type = 'PARTY' then
116:
117: if l_Assignment_Level = 'PARTY' then
118: IEX_STRATEGY_WF.get_resource(p_party_id => l_party_id,
119: p_competence_tab => l_competence_tab,
120: x_resource_id => l_resource_id);
121: end if;
122: elsif p_strategy_rec.object_type = 'IEX_ACCOUNT' then

Line 125: IEX_STRATEGY_WF.get_resource(l_party_id,l_competence_tab,l_resource_id);

121: end if;
122: elsif p_strategy_rec.object_type = 'IEX_ACCOUNT' then
123:
124: if l_Assignment_Level = 'PARTY' then
125: IEX_STRATEGY_WF.get_resource(l_party_id,l_competence_tab,l_resource_id);
126: elsif l_Assignment_level = 'ACCOUNT' then
127: bReturn := IEX_STRATEGY_WF.get_account_resource(l_cust_acct_id, l_competence_tab, l_resource_id);
128: end if;
129:

Line 127: bReturn := IEX_STRATEGY_WF.get_account_resource(l_cust_acct_id, l_competence_tab, l_resource_id);

123:
124: if l_Assignment_Level = 'PARTY' then
125: IEX_STRATEGY_WF.get_resource(l_party_id,l_competence_tab,l_resource_id);
126: elsif l_Assignment_level = 'ACCOUNT' then
127: bReturn := IEX_STRATEGY_WF.get_account_resource(l_cust_acct_id, l_competence_tab, l_resource_id);
128: end if;
129:
130: else
131: if l_Assignment_Level = 'PARTY' then

Line 132: IEX_STRATEGY_WF.get_resource(l_party_id,l_competence_tab,l_resource_id);

128: end if;
129:
130: else
131: if l_Assignment_Level = 'PARTY' then
132: IEX_STRATEGY_WF.get_resource(l_party_id,l_competence_tab,l_resource_id);
133: elsif l_Assignment_level = 'ACCOUNT' then
134: bReturn := IEX_STRATEGY_WF.get_account_resource(l_cust_acct_id, l_competence_tab, l_resource_id);
135: else
136: bReturn := IEX_STRATEGY_WF.get_billto_resource(l_cust_site_use_id,l_competence_tab,l_resource_id);

Line 134: bReturn := IEX_STRATEGY_WF.get_account_resource(l_cust_acct_id, l_competence_tab, l_resource_id);

130: else
131: if l_Assignment_Level = 'PARTY' then
132: IEX_STRATEGY_WF.get_resource(l_party_id,l_competence_tab,l_resource_id);
133: elsif l_Assignment_level = 'ACCOUNT' then
134: bReturn := IEX_STRATEGY_WF.get_account_resource(l_cust_acct_id, l_competence_tab, l_resource_id);
135: else
136: bReturn := IEX_STRATEGY_WF.get_billto_resource(l_cust_site_use_id,l_competence_tab,l_resource_id);
137: end if;
138:

Line 136: bReturn := IEX_STRATEGY_WF.get_billto_resource(l_cust_site_use_id,l_competence_tab,l_resource_id);

132: IEX_STRATEGY_WF.get_resource(l_party_id,l_competence_tab,l_resource_id);
133: elsif l_Assignment_level = 'ACCOUNT' then
134: bReturn := IEX_STRATEGY_WF.get_account_resource(l_cust_acct_id, l_competence_tab, l_resource_id);
135: else
136: bReturn := IEX_STRATEGY_WF.get_billto_resource(l_cust_site_use_id,l_competence_tab,l_resource_id);
137: end if;
138:
139: end if;
140: