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 912: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

908: l_appl_id NUMBER;
909: l_security_group_id NUMBER;
910: -- [END OF BUG2631497 FIXING]
911:
912: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
913:
914: CURSOR c_resource IS
915: SELECT resource_id ,employee_id source_id,full_name resource_name
916: FROM ams_jtf_rs_emp_v

Line 924: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

920:
921: -- 11.5.9
922: -- Delete any previous approval history
923:
924: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
925: p_api_version_number => 1.0,
926: p_init_msg_list => FND_API.G_FALSE,
927: p_commit => FND_API.G_FALSE,
928: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1106: AMS_Appr_Hist_PVT.Create_Appr_Hist(

1102: l_appr_hist_rec.note := p_notes_from_requester;
1103: l_appr_hist_rec.approval_type := p_approval_type;
1104: l_appr_hist_rec.approver_type := 'USER'; -- User always submits
1105: --
1106: AMS_Appr_Hist_PVT.Create_Appr_Hist(
1107: p_api_version_number => 1.0,
1108: p_init_msg_list => FND_API.G_FALSE,
1109: p_commit => FND_API.G_FALSE,
1110: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1369: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

1365: l_proc_name varchar2(80);
1366: l_appr_id NUMBER;
1367: dml_str VARCHAR2(2000);
1368: -- 11.5.9
1369: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
1370: l_version NUMBER;
1371: l_approval_type VARCHAR2(30);
1372: l_activity_id NUMBER;
1373: l_appr_seq NUMBER;

Line 1468: AMS_Appr_Hist_PVT.Create_Appr_Hist(

1464: l_appr_hist_rec.sequence_num := l_appr_seq;
1465: l_appr_hist_rec.approver_type := l_appr_type;
1466: l_appr_hist_rec.approver_id := l_obj_appr_id;
1467:
1468: AMS_Appr_Hist_PVT.Create_Appr_Hist(
1469: p_api_version_number => 1.0,
1470: p_init_msg_list => FND_API.G_FALSE,
1471: p_commit => FND_API.G_FALSE,
1472: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1571: AMS_Appr_Hist_PVT.Update_Appr_Hist(

1567: l_appr_hist_rec.approver_type := l_approver_type;
1568: l_appr_hist_rec.sequence_num := l_current_seq;
1569: l_appr_hist_rec.approver_id := l_object_approver_id;
1570:
1571: AMS_Appr_Hist_PVT.Update_Appr_Hist(
1572: p_api_version_number => 1.0,
1573: p_init_msg_list => FND_API.G_FALSE,
1574: p_commit => FND_API.G_FALSE,
1575: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1674: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

1670: l_error_msg VARCHAR2(4000);
1671: -- 11.5.9
1672: l_version NUMBER;
1673: l_approval_type VARCHAR2(30);
1674: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
1675: --
1676: l_forward_nid NUMBER;
1677: l_responder VARCHAR2(320);
1678: l_appr_display_name VARCHAR2(360);

Line 1789: AMS_Appr_Hist_PVT.Update_Appr_Hist(

1785: l_appr_hist_rec.approver_id := l_approver_id;
1786: l_appr_hist_rec.note := l_note;
1787: l_appr_hist_rec.action_date := sysdate;
1788:
1789: AMS_Appr_Hist_PVT.Update_Appr_Hist(
1790: p_api_version_number => 1.0,
1791: p_init_msg_list => FND_API.G_FALSE,
1792: p_commit => FND_API.G_FALSE,
1793: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1897: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

1893: l_error_msg VARCHAR2(4000);
1894: -- 11.5.9
1895: l_version NUMBER;
1896: l_approval_type VARCHAR2(30);
1897: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
1898: BEGIN
1899: FND_MSG_PUB.initialize();
1900: /*
1901: UPDATE AMS_CAMPAIGNS_ALL_B

Line 1968: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

1964: x_error_msg => l_error_msg
1965: );
1966: ELSE
1967: -- Delete all rows
1968: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
1969: p_api_version_number => 1.0,
1970: p_init_msg_list => FND_API.G_FALSE,
1971: p_commit => FND_API.G_FALSE,
1972: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2639: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

2635: actid in number,
2636: funcmode in varchar2,
2637: resultout OUT NOCOPY varchar2 )
2638: IS
2639: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
2640: l_activity_id NUMBER;
2641: l_activity_type VARCHAR2(30);
2642: l_approver_seq NUMBER;
2643: l_version NUMBER;

Line 2768: AMS_Appr_Hist_PVT.Update_Appr_Hist(

2764:
2765: -- should i reset approver_id? yes
2766: l_appr_hist_rec.approver_id := l_approver_id;
2767:
2768: AMS_Appr_Hist_PVT.Update_Appr_Hist(
2769: p_api_version_number => 1.0,
2770: p_init_msg_list => FND_API.G_FALSE,
2771: p_commit => FND_API.G_FALSE,
2772: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2784: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

2780: RAISE Fnd_Api.G_EXC_ERROR;
2781: END IF;
2782:
2783: -- Delete any 'OPEN' rows
2784: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
2785: p_api_version_number => 1.0,
2786: p_init_msg_list => FND_API.G_FALSE,
2787: p_commit => FND_API.G_FALSE,
2788: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3238: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;

3234: l_msg_count NUMBER;
3235: l_msg_data VARCHAR2(4000);
3236: l_error_msg VARCHAR2(4000);
3237:
3238: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
3239:
3240: BEGIN
3241: l_nid := wf_engine.context_nid;
3242:

Line 3327: AMS_Appr_Hist_PVT.Update_Appr_Hist(

3323: l_appr_hist_rec.approver_type := 'USER'; -- Always
3324: l_appr_hist_rec.sequence_num := l_current_seq;
3325: l_appr_hist_rec.approver_id := l_new_approver_id;
3326:
3327: AMS_Appr_Hist_PVT.Update_Appr_Hist(
3328: p_api_version_number => 1.0,
3329: p_init_msg_list => FND_API.G_FALSE,
3330: p_commit => FND_API.G_FALSE,
3331: p_validation_level => FND_API.G_VALID_LEVEL_FULL,