DBA Data[Home] [Help]

APPS.IEM_CLASSIFICATIONS_PVT dependencies on IEM_THEMES_PVT

Line 897: iem_themes_pvt.calculate_weight (l_email_account_id,

893: (select classification_id from iem_classifications);
894: delete from iem_theme_docs
895: where account_intent_doc_id not in
896: (select account_intent_doc_id from iem_account_intent_docs);
897: iem_themes_pvt.calculate_weight (l_email_account_id,
898: 'Q' ,
899: l_status );
900: iem_themes_pvt.calculate_weight (l_email_account_id,
901: 'R' ,

Line 900: iem_themes_pvt.calculate_weight (l_email_account_id,

896: (select account_intent_doc_id from iem_account_intent_docs);
897: iem_themes_pvt.calculate_weight (l_email_account_id,
898: 'Q' ,
899: l_status );
900: iem_themes_pvt.calculate_weight (l_email_account_id,
901: 'R' ,
902: l_status );
903:
904: --Standard check of p_commit

Line 1165: iem_themes_pvt.calculate_weight (t_email_account_id ,

1161: update iem_account_intent_docs
1162: set email_account_id=p_email_account_id
1163: where classification_id=p_classification_id;
1164: t_email_account_id:=l_email_account_id;
1165: iem_themes_pvt.calculate_weight (t_email_account_id ,
1166: 'Q' ,
1167: l_status );
1168: iem_themes_pvt.calculate_weight (t_email_account_id ,
1169: 'R' ,

Line 1168: iem_themes_pvt.calculate_weight (t_email_account_id ,

1164: t_email_account_id:=l_email_account_id;
1165: iem_themes_pvt.calculate_weight (t_email_account_id ,
1166: 'Q' ,
1167: l_status );
1168: iem_themes_pvt.calculate_weight (t_email_account_id ,
1169: 'R' ,
1170: l_status );
1171: t_email_account_id:=p_email_account_id;
1172: iem_themes_pvt.calculate_weight (p_email_account_id ,

Line 1172: iem_themes_pvt.calculate_weight (p_email_account_id ,

1168: iem_themes_pvt.calculate_weight (t_email_account_id ,
1169: 'R' ,
1170: l_status );
1171: t_email_account_id:=p_email_account_id;
1172: iem_themes_pvt.calculate_weight (p_email_account_id ,
1173: 'Q',
1174: l_status );
1175: iem_themes_pvt.calculate_weight (p_email_account_id ,
1176: 'R',

Line 1175: iem_themes_pvt.calculate_weight (p_email_account_id ,

1171: t_email_account_id:=p_email_account_id;
1172: iem_themes_pvt.calculate_weight (p_email_account_id ,
1173: 'Q',
1174: l_status );
1175: iem_themes_pvt.calculate_weight (p_email_account_id ,
1176: 'R',
1177: l_status );
1178: END IF;
1179: