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_GEN_APPROVAL_PVT dependencies on AMS_APPR_HIST_PVT

Line 799: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

795: l_appl_id NUMBER;
796: l_security_group_id NUMBER;
797: -- [END OF BUG2631497 FIXING]
798:
799: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
800:
801: CURSOR c_resource IS
802: SELECT resource_id ,employee_id source_id,full_name resource_name
803: FROM ams_jtf_rs_emp_v

Line 811: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

807:
808: -- 11.5.9
809: -- Delete any previous approval history
810:
811: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
812: p_api_version_number => 1.0,
813: p_init_msg_list => FND_API.G_FALSE,
814: p_commit => FND_API.G_FALSE,
815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 993: AMS_Appr_Hist_PVT.Create_Appr_Hist(

989: l_appr_hist_rec.note := p_notes_from_requester;
990: l_appr_hist_rec.approval_type := p_approval_type;
991: l_appr_hist_rec.approver_type := 'USER'; -- User always submits
992: --
993: AMS_Appr_Hist_PVT.Create_Appr_Hist(
994: p_api_version_number => 1.0,
995: p_init_msg_list => FND_API.G_FALSE,
996: p_commit => FND_API.G_FALSE,
997: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1256: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

1252: l_proc_name varchar2(80);
1253: l_appr_id NUMBER;
1254: dml_str VARCHAR2(2000);
1255: -- 11.5.9
1256: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
1257: l_version NUMBER;
1258: l_approval_type VARCHAR2(30);
1259: l_activity_id NUMBER;
1260: l_appr_seq NUMBER;

Line 1355: AMS_Appr_Hist_PVT.Create_Appr_Hist(

1351: l_appr_hist_rec.sequence_num := l_appr_seq;
1352: l_appr_hist_rec.approver_type := l_appr_type;
1353: l_appr_hist_rec.approver_id := l_obj_appr_id;
1354:
1355: AMS_Appr_Hist_PVT.Create_Appr_Hist(
1356: p_api_version_number => 1.0,
1357: p_init_msg_list => FND_API.G_FALSE,
1358: p_commit => FND_API.G_FALSE,
1359: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1458: AMS_Appr_Hist_PVT.Update_Appr_Hist(

1454: l_appr_hist_rec.approver_type := l_approver_type;
1455: l_appr_hist_rec.sequence_num := l_current_seq;
1456: l_appr_hist_rec.approver_id := l_object_approver_id;
1457:
1458: AMS_Appr_Hist_PVT.Update_Appr_Hist(
1459: p_api_version_number => 1.0,
1460: p_init_msg_list => FND_API.G_FALSE,
1461: p_commit => FND_API.G_FALSE,
1462: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1561: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

1557: l_error_msg VARCHAR2(4000);
1558: -- 11.5.9
1559: l_version NUMBER;
1560: l_approval_type VARCHAR2(30);
1561: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
1562: --
1563: l_forward_nid NUMBER;
1564: l_responder VARCHAR2(320);
1565: l_appr_display_name VARCHAR2(360);

Line 1676: AMS_Appr_Hist_PVT.Update_Appr_Hist(

1672: l_appr_hist_rec.approver_id := l_approver_id;
1673: l_appr_hist_rec.note := l_note;
1674: l_appr_hist_rec.action_date := sysdate;
1675:
1676: AMS_Appr_Hist_PVT.Update_Appr_Hist(
1677: p_api_version_number => 1.0,
1678: p_init_msg_list => FND_API.G_FALSE,
1679: p_commit => FND_API.G_FALSE,
1680: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1784: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

1780: l_error_msg VARCHAR2(4000);
1781: -- 11.5.9
1782: l_version NUMBER;
1783: l_approval_type VARCHAR2(30);
1784: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
1785: BEGIN
1786: FND_MSG_PUB.initialize();
1787: /*
1788: UPDATE AMS_CAMPAIGNS_ALL_B

Line 1855: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

1851: x_error_msg => l_error_msg
1852: );
1853: ELSE
1854: -- Delete all rows
1855: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
1856: p_api_version_number => 1.0,
1857: p_init_msg_list => FND_API.G_FALSE,
1858: p_commit => FND_API.G_FALSE,
1859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2526: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

2522: actid in number,
2523: funcmode in varchar2,
2524: resultout OUT NOCOPY varchar2 )
2525: IS
2526: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
2527: l_activity_id NUMBER;
2528: l_activity_type VARCHAR2(30);
2529: l_approver_seq NUMBER;
2530: l_version NUMBER;

Line 2655: AMS_Appr_Hist_PVT.Update_Appr_Hist(

2651:
2652: -- should i reset approver_id? yes
2653: l_appr_hist_rec.approver_id := l_approver_id;
2654:
2655: AMS_Appr_Hist_PVT.Update_Appr_Hist(
2656: p_api_version_number => 1.0,
2657: p_init_msg_list => FND_API.G_FALSE,
2658: p_commit => FND_API.G_FALSE,
2659: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2671: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

2667: RAISE Fnd_Api.G_EXC_ERROR;
2668: END IF;
2669:
2670: -- Delete any 'OPEN' rows
2671: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
2672: p_api_version_number => 1.0,
2673: p_init_msg_list => FND_API.G_FALSE,
2674: p_commit => FND_API.G_FALSE,
2675: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3114: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

3110: l_msg_count NUMBER;
3111: l_msg_data VARCHAR2(4000);
3112: l_error_msg VARCHAR2(4000);
3113:
3114: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
3115:
3116: BEGIN
3117: l_nid := wf_engine.context_nid;
3118:

Line 3203: AMS_Appr_Hist_PVT.Update_Appr_Hist(

3199: l_appr_hist_rec.approver_type := 'USER'; -- Always
3200: l_appr_hist_rec.sequence_num := l_current_seq;
3201: l_appr_hist_rec.approver_id := l_new_approver_id;
3202:
3203: AMS_Appr_Hist_PVT.Update_Appr_Hist(
3204: p_api_version_number => 1.0,
3205: p_init_msg_list => FND_API.G_FALSE,
3206: p_commit => FND_API.G_FALSE,
3207: p_validation_level => FND_API.G_VALID_LEVEL_FULL,