APPS.IGP_WZ_PUBLISH_TEMPLATE_PKG dependencies on IGP_WZ_TEMPLATES

Line 13: PROCEDURE submit_approval( p_template_id igp_wz_templates.template_id%TYPE,

9: Change History
10: Who When What
11: ******************************************************************/
12:
13: PROCEDURE submit_approval( p_template_id igp_wz_templates.template_id%TYPE,
14: p_template_name igp_wz_templates.template_name%TYPE,
15: p_user_id fnd_user.user_id%TYPE) AS
16: /******************************************************************
17: Created By : Prabhat Patel

Line 14: p_template_name igp_wz_templates.template_name%TYPE,

10: Who When What
11: ******************************************************************/
12:
13: PROCEDURE submit_approval( p_template_id igp_wz_templates.template_id%TYPE,
14: p_template_name igp_wz_templates.template_name%TYPE,
15: p_user_id fnd_user.user_id%TYPE) AS
16: /******************************************************************
17: Created By : Prabhat Patel
18: Date Created By : 20-Feb-2004

Line 55: p_template_id igp_wz_templates.template_id%TYPE,

51:
52: END submit_approval;
53:
54: PROCEDURE update_template (
55: p_template_id igp_wz_templates.template_id%TYPE,
56: p_status VARCHAR2) IS
57: /******************************************************************
58: Created By : Prabhat Patel
59: Date Created By : 25-Feb-2004

Line 67: CURSOR lock_temp_cur(cp_template_id igp_wz_templates.template_id%TYPE) IS

63: Who When What
64: ******************************************************************/
65: l_var NUMBER;
66:
67: CURSOR lock_temp_cur(cp_template_id igp_wz_templates.template_id%TYPE) IS
68: SELECT 1
69: FROM igp_wz_templates
70: WHERE template_id = cp_template_id;
71: BEGIN

Line 69: FROM igp_wz_templates

65: l_var NUMBER;
66:
67: CURSOR lock_temp_cur(cp_template_id igp_wz_templates.template_id%TYPE) IS
68: SELECT 1
69: FROM igp_wz_templates
70: WHERE template_id = cp_template_id;
71: BEGIN
72:
73: OPEN lock_temp_cur(p_template_id);

Line 77: UPDATE igp_wz_templates

73: OPEN lock_temp_cur(p_template_id);
74: FETCH lock_temp_cur INTO l_var;
75: CLOSE lock_temp_cur;
76:
77: UPDATE igp_wz_templates
78: SET template_status_code = p_status
79: WHERE template_id = p_template_id;
80:
81: END update_template;

Line 84: p_template_id igp_wz_templates.template_id%TYPE) IS

80:
81: END update_template;
82:
83: PROCEDURE pending_status (
84: p_template_id igp_wz_templates.template_id%TYPE) IS
85: /******************************************************************
86: Created By : Prabhat Patel
87: Date Created By : 25-Feb-2004
88: Purpose : Procedure for updating to Pending status.

Line 112: l_template_id igp_wz_templates.template_id%TYPE;

108: remarks :
109: Change History
110: Who When What
111: ******************************************************************/
112: l_template_id igp_wz_templates.template_id%TYPE;
113: l_error_message VARCHAR2(500);
114: BEGIN
115: l_template_id := wf_engine.GetItemAttrText( itemtype => itemtype,
116: itemkey => itemkey,

Line 140: l_template_id igp_wz_templates.template_id%TYPE;

136: remarks :
137: Change History
138: Who When What
139: ******************************************************************/
140: l_template_id igp_wz_templates.template_id%TYPE;
141: l_error_message VARCHAR2(500);
142: BEGIN
143: l_template_id := wf_engine.GetItemAttrText( itemtype => itemtype,
144: itemkey => itemkey,

Line 193: l_template_id igp_wz_templates.template_id%TYPE;

189: l_login_user_id fnd_user.user_id%TYPE;
190: l_login_user_name fnd_user.user_name%TYPE;
191: l_item_key wf_items.item_key%TYPE;
192: l_item_exists VARCHAR2(1);
193: l_template_id igp_wz_templates.template_id%TYPE;
194: l_template_name igp_wz_templates.template_name%TYPE;
195: l_error_message VARCHAR2(500);
196:
197: nbsp VARCHAR2(10);

Line 194: l_template_name igp_wz_templates.template_name%TYPE;

190: l_login_user_name fnd_user.user_name%TYPE;
191: l_item_key wf_items.item_key%TYPE;
192: l_item_exists VARCHAR2(1);
193: l_template_id igp_wz_templates.template_id%TYPE;
194: l_template_name igp_wz_templates.template_name%TYPE;
195: l_error_message VARCHAR2(500);
196:
197: nbsp VARCHAR2(10);
198: l_preview_link VARCHAR2(500);

Line 222: FROM igp_wz_templates temp, igp_lookup_values lk

218: lk.meaning type,
219: NVL(temp.description,nbsp) description,
220: NVL(TO_CHAR(temp.expiry_date),nbsp) expiry_date,
221: created_by
222: FROM igp_wz_templates temp, igp_lookup_values lk
223: WHERE temp.template_id = cp_template_id AND
224: temp.template_type_code = lk.lookup_code AND
225: lk.lookup_type = cp_lookup_type;
226: