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.AMS_APPROVAL_PVT dependencies on AMS_APPR_HIST_PVT

Line 1655: l_appr_hist_rec AMS_Appr_Hist_PVT.appr_hist_rec_type;

1651: x_resource_id NUMBER;
1652:
1653: l_save_threshold NUMBER := Wf_Engine.threshold;
1654:
1655: l_appr_hist_rec AMS_Appr_Hist_PVT.appr_hist_rec_type;
1656:
1657: -- [BEGIN OF BUG2741039 FIXING by vmodur 09-Jan-2003]
1658: l_user_id NUMBER;
1659: l_resp_id NUMBER;

Line 1673: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

1669: Fnd_Msg_Pub.initialize();
1670:
1671: /* Delete any previous history rows for this object and approval type Bug 2761026*/
1672:
1673: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
1674: p_api_version_number => 1.0,
1675: p_init_msg_list => FND_API.G_FALSE,
1676: p_commit => FND_API.G_FALSE,
1677: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1868: AMS_Appr_Hist_PVT.Create_Appr_Hist(

1864: l_appr_hist_rec.note := p_notes_from_requester;
1865: l_appr_hist_rec.approval_type := p_approval_type;
1866: l_appr_hist_rec.approver_type := 'USER'; -- User always submits
1867: --
1868: AMS_Appr_Hist_PVT.Create_Appr_Hist(
1869: p_api_version_number => 1.0,
1870: p_init_msg_list => FND_API.G_FALSE,
1871: p_commit => FND_API.G_FALSE,
1872: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2533: l_appr_hist_rec AMS_Appr_Hist_PVT.appr_hist_rec_type;

2529: l_version NUMBER;
2530: l_appr_seq NUMBER;
2531: l_appr_type VARCHAR2(30);
2532: l_obj_appr_id NUMBER;
2533: l_appr_hist_rec AMS_Appr_Hist_PVT.appr_hist_rec_type;
2534:
2535: CURSOR c_API_Name(rule_id_in IN NUMBER) IS
2536: SELECT package_name, procedure_name
2537: FROM ams_object_rules_b

Line 2621: AMS_Appr_Hist_PVT.Create_Appr_Hist(

2617: l_appr_hist_rec.sequence_num := l_appr_seq;
2618: l_appr_hist_rec.approver_type := l_appr_type;
2619: l_appr_hist_rec.approver_id := l_obj_appr_id;
2620:
2621: AMS_Appr_Hist_PVT.Create_Appr_Hist(
2622: p_api_version_number => 1.0,
2623: p_init_msg_list => FND_API.G_FALSE,
2624: p_commit => FND_API.G_FALSE,
2625: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2758: AMS_Appr_Hist_PVT.Update_Appr_Hist(

2754: l_appr_hist_rec.approver_type := l_approver_type;
2755: l_appr_hist_rec.sequence_num := l_current_seq;
2756: l_appr_hist_rec.approver_id := l_object_approver_id;
2757:
2758: AMS_Appr_Hist_PVT.Update_Appr_Hist(
2759: p_api_version_number => 1.0,
2760: p_init_msg_list => FND_API.G_FALSE,
2761: p_commit => FND_API.G_FALSE,
2762: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2862: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

2858: l_error_msg VARCHAR2(4000);
2859: -- 11.5.9
2860: l_version NUMBER;
2861: l_approval_type VARCHAR2(30);
2862: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
2863: l_new_approver_id NUMBER;
2864: BEGIN
2865: Fnd_Msg_Pub.initialize();
2866: IF (funcmode = 'RUN') THEN

Line 2959: AMS_Appr_Hist_PVT.Update_Appr_Hist(

2955: l_appr_hist_rec.approver_id := l_approver_id;
2956: l_appr_hist_rec.note := l_note;
2957: l_appr_hist_rec.action_date := sysdate;
2958:
2959: AMS_Appr_Hist_PVT.Update_Appr_Hist(
2960: p_api_version_number => 1.0,
2961: p_init_msg_list => FND_API.G_FALSE,
2962: p_commit => FND_API.G_FALSE,
2963: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3145: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

3141: -- Delete all history rows
3142: ELSE
3143:
3144: -- Delete all rows
3145: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
3146: p_api_version_number => 1.0,
3147: p_init_msg_list => FND_API.G_FALSE,
3148: p_commit => FND_API.G_FALSE,
3149: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3355: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

3351: l_approver_id NUMBER;
3352: l_approval_detail_id NUMBER;
3353: l_approval_type VARCHAR2(30);
3354: l_note VARCHAR2(4000);
3355: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
3356: l_new_approver_id NUMBER;
3357: --
3358: BEGIN
3359:

Line 3448: AMS_Appr_Hist_PVT.Update_Appr_Hist(

3444:
3445: -- should i reset approver_id-- yes
3446: l_appr_hist_rec.approver_id := l_approver_id;
3447:
3448: AMS_Appr_Hist_PVT.Update_Appr_Hist(
3449: p_api_version_number => 1.0,
3450: p_init_msg_list => FND_API.G_FALSE,
3451: p_commit => FND_API.G_FALSE,
3452: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3464: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

3460: RAISE Fnd_Api.G_EXC_ERROR;
3461: END IF;
3462:
3463: -- Delete any 'OPEN' rows
3464: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
3465: p_api_version_number => 1.0,
3466: p_init_msg_list => FND_API.G_FALSE,
3467: p_commit => FND_API.G_FALSE,
3468: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3779: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

3775: l_full_name VARCHAR2(360); --l_full_name VARCHAR2(60); -- SVEERAVE, 04/10/02
3776: l_justification_text VARCHAR2(2000);
3777:
3778: -- 11.5.9
3779: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
3780:
3781: -- [BEGIN OF BUG2741039 FIXING by vmodur 09-Jan-2003]
3782: l_user_id NUMBER;
3783: l_resp_id NUMBER;

Line 3813: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

3809: Fnd_Msg_Pub.initialize();
3810:
3811: -- Delete any previous approval history rows Bug 2761026
3812:
3813: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
3814: p_api_version_number => 1.0,
3815: p_init_msg_list => FND_API.G_FALSE,
3816: p_commit => FND_API.G_FALSE,
3817: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4262: AMS_Appr_Hist_PVT.Create_Appr_Hist(

4258: l_appr_hist_rec.approval_detail_id := l_activity_detail_id;
4259: l_appr_hist_rec.approval_type := 'BUDGET';
4260: l_appr_hist_rec.approver_type := 'USER';
4261: --
4262: AMS_Appr_Hist_PVT.Create_Appr_Hist(
4263: p_api_version_number => 1.0,
4264: p_init_msg_list => FND_API.G_FALSE,
4265: p_commit => FND_API.G_FALSE,
4266: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4763: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

4759: l_appr_type VARCHAR2(30);
4760: l_obj_appr_id NUMBER;
4761: l_act_budget_id NUMBER;
4762: l_version NUMBER;
4763: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
4764:
4765: CURSOR c_API_Name (rule_id_in IN NUMBER) is
4766: SELECT package_name, procedure_name
4767: FROM ams_object_rules_b

Line 4863: AMS_Appr_Hist_PVT.Create_Appr_Hist(

4859: l_appr_hist_rec.sequence_num := l_appr_seq;
4860: l_appr_hist_rec.approver_type := l_appr_type;
4861: l_appr_hist_rec.approver_id := l_obj_appr_id;
4862:
4863: AMS_Appr_Hist_PVT.Create_Appr_Hist(
4864: p_api_version_number => 1.0,
4865: p_init_msg_list => FND_API.G_FALSE,
4866: p_commit => FND_API.G_FALSE,
4867: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5037: AMS_Appr_Hist_PVT.Update_Appr_Hist(

5033: l_appr_hist_rec.sequence_num := l_current_seq;
5034: l_appr_hist_rec.approver_id := l_object_approver_id;
5035:
5036:
5037: AMS_Appr_Hist_PVT.Update_Appr_Hist(
5038: p_api_version_number => 1.0,
5039: p_init_msg_list => FND_API.G_FALSE,
5040: p_commit => FND_API.G_FALSE,
5041: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5149: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

5145: -- Added for 11.5.9
5146: l_approver_id NUMBER;
5147: l_version NUMBER;
5148: l_return_status VARCHAR2(1);
5149: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
5150: l_new_approver_id NUMBER;
5151:
5152: BEGIN
5153:

Line 5245: AMS_Appr_Hist_PVT.Update_Appr_Hist(

5241: l_appr_hist_rec.note := l_note;
5242: l_appr_hist_rec.action_date := SYSDATE;
5243:
5244:
5245: AMS_Appr_Hist_PVT.Update_Appr_Hist(
5246: p_api_version_number => 1.0,
5247: p_init_msg_list => FND_API.G_FALSE,
5248: p_commit => FND_API.G_FALSE,
5249: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5584: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

5580: l_approved_currency VARCHAR2(30);
5581: l_rejected_status_id NUMBER;
5582: l_comment VARCHAR2(4000); -- was 2000
5583: -- 11.5.9
5584: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
5585: l_version NUMBER;
5586: l_approver_seq NUMBER;
5587: l_note VARCHAR2(4000);
5588: l_new_approver_id NUMBER;

Line 5740: AMS_Appr_Hist_PVT.Update_Appr_Hist(

5736:
5737: -- should i reset approver_id? yes
5738: l_appr_hist_rec.approver_id := l_approver_id;
5739:
5740: AMS_Appr_Hist_PVT.Update_Appr_Hist(
5741: p_api_version_number => 1.0,
5742: p_init_msg_list => FND_API.G_FALSE,
5743: p_commit => FND_API.G_FALSE,
5744: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5756: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

5752: RAISE Fnd_Api.G_EXC_ERROR;
5753: END IF;
5754:
5755: -- Delete any 'OPEN' rows
5756: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
5757: p_api_version_number => 1.0,
5758: p_init_msg_list => FND_API.G_FALSE,
5759: p_commit => FND_API.G_FALSE,
5760: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5970: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

5966: itemkey => itemkey,
5967: aname => 'AMS_OBJECT_VERSION_NUMBER' );
5968:
5969: -- Delete all rows
5970: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
5971: p_api_version_number => 1.0,
5972: p_init_msg_list => FND_API.G_FALSE,
5973: p_commit => FND_API.G_FALSE,
5974: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 7292: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

7288: l_msg_count NUMBER;
7289: l_msg_data VARCHAR2(4000);
7290: l_error_msg VARCHAR2(4000);
7291:
7292: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
7293:
7294: BEGIN
7295: l_nid := wf_engine.context_nid;
7296:

Line 7392: AMS_Appr_Hist_PVT.Update_Appr_Hist(

7388: l_appr_hist_rec.approver_type := 'USER'; -- Always
7389: l_appr_hist_rec.sequence_num := l_current_seq;
7390: l_appr_hist_rec.approver_id := l_new_approver_id;
7391:
7392: AMS_Appr_Hist_PVT.Update_Appr_Hist(
7393: p_api_version_number => 1.0,
7394: p_init_msg_list => FND_API.G_FALSE,
7395: p_commit => FND_API.G_FALSE,
7396: p_validation_level => FND_API.G_VALID_LEVEL_FULL,