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 1691: l_appr_hist_rec AMS_Appr_Hist_PVT.appr_hist_rec_type;

1687: x_resource_id NUMBER;
1688:
1689: l_save_threshold NUMBER := Wf_Engine.threshold;
1690:
1691: l_appr_hist_rec AMS_Appr_Hist_PVT.appr_hist_rec_type;
1692:
1693: -- [BEGIN OF BUG2741039 FIXING by vmodur 09-Jan-2003]
1694: l_user_id NUMBER;
1695: l_resp_id NUMBER;

Line 1709: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

1705: Fnd_Msg_Pub.initialize();
1706:
1707: /* Delete any previous history rows for this object and approval type Bug 2761026*/
1708:
1709: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
1710: p_api_version_number => 1.0,
1711: p_init_msg_list => FND_API.G_FALSE,
1712: p_commit => FND_API.G_FALSE,
1713: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1904: AMS_Appr_Hist_PVT.Create_Appr_Hist(

1900: l_appr_hist_rec.note := p_notes_from_requester;
1901: l_appr_hist_rec.approval_type := p_approval_type;
1902: l_appr_hist_rec.approver_type := 'USER'; -- User always submits
1903: --
1904: AMS_Appr_Hist_PVT.Create_Appr_Hist(
1905: p_api_version_number => 1.0,
1906: p_init_msg_list => FND_API.G_FALSE,
1907: p_commit => FND_API.G_FALSE,
1908: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2569: l_appr_hist_rec AMS_Appr_Hist_PVT.appr_hist_rec_type;

2565: l_version NUMBER;
2566: l_appr_seq NUMBER;
2567: l_appr_type VARCHAR2(30);
2568: l_obj_appr_id NUMBER;
2569: l_appr_hist_rec AMS_Appr_Hist_PVT.appr_hist_rec_type;
2570:
2571: CURSOR c_API_Name(rule_id_in IN NUMBER) IS
2572: SELECT package_name, procedure_name
2573: FROM ams_object_rules_b

Line 2657: AMS_Appr_Hist_PVT.Create_Appr_Hist(

2653: l_appr_hist_rec.sequence_num := l_appr_seq;
2654: l_appr_hist_rec.approver_type := l_appr_type;
2655: l_appr_hist_rec.approver_id := l_obj_appr_id;
2656:
2657: AMS_Appr_Hist_PVT.Create_Appr_Hist(
2658: p_api_version_number => 1.0,
2659: p_init_msg_list => FND_API.G_FALSE,
2660: p_commit => FND_API.G_FALSE,
2661: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2794: AMS_Appr_Hist_PVT.Update_Appr_Hist(

2790: l_appr_hist_rec.approver_type := l_approver_type;
2791: l_appr_hist_rec.sequence_num := l_current_seq;
2792: l_appr_hist_rec.approver_id := l_object_approver_id;
2793:
2794: AMS_Appr_Hist_PVT.Update_Appr_Hist(
2795: p_api_version_number => 1.0,
2796: p_init_msg_list => FND_API.G_FALSE,
2797: p_commit => FND_API.G_FALSE,
2798: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2898: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

2894: l_error_msg VARCHAR2(4000);
2895: -- 11.5.9
2896: l_version NUMBER;
2897: l_approval_type VARCHAR2(30);
2898: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
2899: l_new_approver_id NUMBER;
2900: BEGIN
2901: Fnd_Msg_Pub.initialize();
2902: IF (funcmode = 'RUN') THEN

Line 2995: AMS_Appr_Hist_PVT.Update_Appr_Hist(

2991: l_appr_hist_rec.approver_id := l_approver_id;
2992: l_appr_hist_rec.note := l_note;
2993: l_appr_hist_rec.action_date := sysdate;
2994:
2995: AMS_Appr_Hist_PVT.Update_Appr_Hist(
2996: p_api_version_number => 1.0,
2997: p_init_msg_list => FND_API.G_FALSE,
2998: p_commit => FND_API.G_FALSE,
2999: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3181: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

3177: -- Delete all history rows
3178: ELSE
3179:
3180: -- Delete all rows
3181: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
3182: p_api_version_number => 1.0,
3183: p_init_msg_list => FND_API.G_FALSE,
3184: p_commit => FND_API.G_FALSE,
3185: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3442: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

3438: l_approver_id NUMBER;
3439: l_approval_detail_id NUMBER;
3440: l_approval_type VARCHAR2(30);
3441: l_note VARCHAR2(4000);
3442: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
3443: l_new_approver_id NUMBER;
3444: --
3445: BEGIN
3446:

Line 3535: AMS_Appr_Hist_PVT.Update_Appr_Hist(

3531:
3532: -- should i reset approver_id-- yes
3533: l_appr_hist_rec.approver_id := l_approver_id;
3534:
3535: AMS_Appr_Hist_PVT.Update_Appr_Hist(
3536: p_api_version_number => 1.0,
3537: p_init_msg_list => FND_API.G_FALSE,
3538: p_commit => FND_API.G_FALSE,
3539: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3551: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

3547: RAISE Fnd_Api.G_EXC_ERROR;
3548: END IF;
3549:
3550: -- Delete any 'OPEN' rows
3551: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
3552: p_api_version_number => 1.0,
3553: p_init_msg_list => FND_API.G_FALSE,
3554: p_commit => FND_API.G_FALSE,
3555: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3866: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

3862: l_full_name VARCHAR2(360); --l_full_name VARCHAR2(60); -- SVEERAVE, 04/10/02
3863: l_justification_text VARCHAR2(2000);
3864:
3865: -- 11.5.9
3866: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
3867:
3868: -- [BEGIN OF BUG2741039 FIXING by vmodur 09-Jan-2003]
3869: l_user_id NUMBER;
3870: l_resp_id NUMBER;

Line 3900: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

3896: Fnd_Msg_Pub.initialize();
3897:
3898: -- Delete any previous approval history rows Bug 2761026
3899:
3900: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
3901: p_api_version_number => 1.0,
3902: p_init_msg_list => FND_API.G_FALSE,
3903: p_commit => FND_API.G_FALSE,
3904: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4353: AMS_Appr_Hist_PVT.Create_Appr_Hist(

4349: l_appr_hist_rec.approval_detail_id := l_activity_detail_id;
4350: l_appr_hist_rec.approval_type := 'BUDGET';
4351: l_appr_hist_rec.approver_type := 'USER';
4352: --
4353: AMS_Appr_Hist_PVT.Create_Appr_Hist(
4354: p_api_version_number => 1.0,
4355: p_init_msg_list => FND_API.G_FALSE,
4356: p_commit => FND_API.G_FALSE,
4357: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4854: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

4850: l_appr_type VARCHAR2(30);
4851: l_obj_appr_id NUMBER;
4852: l_act_budget_id NUMBER;
4853: l_version NUMBER;
4854: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
4855:
4856: CURSOR c_API_Name (rule_id_in IN NUMBER) is
4857: SELECT package_name, procedure_name
4858: FROM ams_object_rules_b

Line 4954: AMS_Appr_Hist_PVT.Create_Appr_Hist(

4950: l_appr_hist_rec.sequence_num := l_appr_seq;
4951: l_appr_hist_rec.approver_type := l_appr_type;
4952: l_appr_hist_rec.approver_id := l_obj_appr_id;
4953:
4954: AMS_Appr_Hist_PVT.Create_Appr_Hist(
4955: p_api_version_number => 1.0,
4956: p_init_msg_list => FND_API.G_FALSE,
4957: p_commit => FND_API.G_FALSE,
4958: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5128: AMS_Appr_Hist_PVT.Update_Appr_Hist(

5124: l_appr_hist_rec.sequence_num := l_current_seq;
5125: l_appr_hist_rec.approver_id := l_object_approver_id;
5126:
5127:
5128: AMS_Appr_Hist_PVT.Update_Appr_Hist(
5129: p_api_version_number => 1.0,
5130: p_init_msg_list => FND_API.G_FALSE,
5131: p_commit => FND_API.G_FALSE,
5132: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5240: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

5236: -- Added for 11.5.9
5237: l_approver_id NUMBER;
5238: l_version NUMBER;
5239: l_return_status VARCHAR2(1);
5240: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
5241: l_new_approver_id NUMBER;
5242:
5243: BEGIN
5244:

Line 5336: AMS_Appr_Hist_PVT.Update_Appr_Hist(

5332: l_appr_hist_rec.note := l_note;
5333: l_appr_hist_rec.action_date := SYSDATE;
5334:
5335:
5336: AMS_Appr_Hist_PVT.Update_Appr_Hist(
5337: p_api_version_number => 1.0,
5338: p_init_msg_list => FND_API.G_FALSE,
5339: p_commit => FND_API.G_FALSE,
5340: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5675: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

5671: l_approved_currency VARCHAR2(30);
5672: l_rejected_status_id NUMBER;
5673: l_comment VARCHAR2(4000); -- was 2000
5674: -- 11.5.9
5675: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
5676: l_version NUMBER;
5677: l_approver_seq NUMBER;
5678: l_note VARCHAR2(4000);
5679: l_new_approver_id NUMBER;

Line 5831: AMS_Appr_Hist_PVT.Update_Appr_Hist(

5827:
5828: -- should i reset approver_id? yes
5829: l_appr_hist_rec.approver_id := l_approver_id;
5830:
5831: AMS_Appr_Hist_PVT.Update_Appr_Hist(
5832: p_api_version_number => 1.0,
5833: p_init_msg_list => FND_API.G_FALSE,
5834: p_commit => FND_API.G_FALSE,
5835: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5847: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

5843: RAISE Fnd_Api.G_EXC_ERROR;
5844: END IF;
5845:
5846: -- Delete any 'OPEN' rows
5847: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
5848: p_api_version_number => 1.0,
5849: p_init_msg_list => FND_API.G_FALSE,
5850: p_commit => FND_API.G_FALSE,
5851: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 6061: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

6057: itemkey => itemkey,
6058: aname => 'AMS_OBJECT_VERSION_NUMBER' );
6059:
6060: -- Delete all rows
6061: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
6062: p_api_version_number => 1.0,
6063: p_init_msg_list => FND_API.G_FALSE,
6064: p_commit => FND_API.G_FALSE,
6065: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 7383: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

7379: l_msg_count NUMBER;
7380: l_msg_data VARCHAR2(4000);
7381: l_error_msg VARCHAR2(4000);
7382:
7383: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
7384:
7385: BEGIN
7386: l_nid := wf_engine.context_nid;
7387:

Line 7483: AMS_Appr_Hist_PVT.Update_Appr_Hist(

7479: l_appr_hist_rec.approver_type := 'USER'; -- Always
7480: l_appr_hist_rec.sequence_num := l_current_seq;
7481: l_appr_hist_rec.approver_id := l_new_approver_id;
7482:
7483: AMS_Appr_Hist_PVT.Update_Appr_Hist(
7484: p_api_version_number => 1.0,
7485: p_init_msg_list => FND_API.G_FALSE,
7486: p_commit => FND_API.G_FALSE,
7487: p_validation_level => FND_API.G_VALID_LEVEL_FULL,