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.IGF_AP_TD_ITEM_MST_PKG dependencies on IGF_AP_TD_ITEM_MST

Line 1: PACKAGE BODY igf_ap_td_item_mst_pkg AS

1: PACKAGE BODY igf_ap_td_item_mst_pkg AS
2: /* $Header: IGFAI37B.pls 120.2 2005/08/16 23:07:52 appldev ship $ */
3:
4: /*=======================================================================+
5: | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|

Line 10: | PL/SQL body for package: IGF_AP_TD_ITEM_MST_PKG |

6: | All rights reserved. |
7: +=======================================================================+
8: | |
9: | DESCRIPTION |
10: | PL/SQL body for package: IGF_AP_TD_ITEM_MST_PKG |
11: | |
12: | NOTES |
13: | |
14: | This package has a flag on the end of some of the procedures called |

Line 34: old_references igf_ap_td_item_mst_all%ROWTYPE;

30: | added new cloumn system_todo_type_code|
31: *=======================================================================*/
32:
33: l_rowid VARCHAR2(25);
34: old_references igf_ap_td_item_mst_all%ROWTYPE;
35: new_references igf_ap_td_item_mst_all%ROWTYPE;
36:
37: PROCEDURE set_column_values (
38: p_action IN VARCHAR2,

Line 35: new_references igf_ap_td_item_mst_all%ROWTYPE;

31: *=======================================================================*/
32:
33: l_rowid VARCHAR2(25);
34: old_references igf_ap_td_item_mst_all%ROWTYPE;
35: new_references igf_ap_td_item_mst_all%ROWTYPE;
36:
37: PROCEDURE set_column_values (
38: p_action IN VARCHAR2,
39: x_rowid IN VARCHAR2,

Line 74: FROM IGF_AP_TD_ITEM_MST_ALL

70: */
71:
72: CURSOR cur_old_ref_values IS
73: SELECT *
74: FROM IGF_AP_TD_ITEM_MST_ALL
75: WHERE rowid = x_rowid;
76:
77: BEGIN
78:

Line 166: igf_aw_fund_td_map_pkg.get_fk_igf_ap_td_item_mst(

162: || (reverse chronological order - newest change first)
163: */
164: BEGIN
165:
166: igf_aw_fund_td_map_pkg.get_fk_igf_ap_td_item_mst(
167: old_references.todo_number
168: );
169: igf_ap_td_item_inst_pkg.get_fk_igf_ap_td_item_mst(
170: old_references.todo_number

Line 169: igf_ap_td_item_inst_pkg.get_fk_igf_ap_td_item_mst(

165:
166: igf_aw_fund_td_map_pkg.get_fk_igf_ap_td_item_mst(
167: old_references.todo_number
168: );
169: igf_ap_td_item_inst_pkg.get_fk_igf_ap_td_item_mst(
170: old_references.todo_number
171: );
172:
173: END check_child_existance;

Line 191: FROM igf_ap_td_item_mst_all

187: || (reverse chronological order - newest change first)
188: */
189: CURSOR cur_rowid IS
190: SELECT rowid
191: FROM igf_ap_td_item_mst_all
192: WHERE ((ci_cal_type = x_ci_cal_type) AND
193: (ci_sequence_number = x_ci_sequence_number) AND
194: (application_code = x_application_code));
195:

Line 227: FROM igf_ap_td_item_mst_all

223: || (reverse chronological order - newest change first)
224: */
225: CURSOR cur_rowid IS
226: SELECT rowid
227: FROM igf_ap_td_item_mst_all
228: WHERE todo_number = x_todo_number
229: FOR UPDATE NOWAIT;
230:
231: lv_rowid cur_rowid%RowType;

Line 265: FROM igf_ap_td_item_mst

261: || (reverse chronological order - newest change first)
262: */
263: CURSOR cur_rowid IS
264: SELECT rowid
265: FROM igf_ap_td_item_mst
266: WHERE UPPER(item_code) =UPPER( x_item_code)
267: AND ci_cal_type = x_ci_cal_type
268: AND ci_sequence_number = x_ci_sequence_number
269: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 418: FROM igf_ap_td_item_mst_all

414: || (reverse chronological order - newest change first)
415: */
416: CURSOR c IS
417: SELECT rowid
418: FROM igf_ap_td_item_mst_all
419: WHERE todo_number = x_todo_number;
420:
421: x_last_update_date DATE;
422: x_last_updated_by NUMBER;

Line 446: SELECT igf_ap_td_item_mst_all_s.NEXTVAL

442: igs_ge_msg_stack.add;
443: app_exception.raise_exception;
444: END IF;
445:
446: SELECT igf_ap_td_item_mst_all_s.NEXTVAL
447: INTO x_todo_number
448: FROM dual;
449:
450: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 478: INSERT INTO igf_ap_td_item_mst_all (

474: x_allow_attachment_flag => x_allow_attachment_flag,
475: x_document_url_txt => x_document_url_txt
476: );
477:
478: INSERT INTO igf_ap_td_item_mst_all (
479: todo_number,
480: item_code,
481: ci_cal_type,
482: ci_sequence_number,

Line 582: FROM igf_ap_td_item_mst_all

578: display_in_ss_flag,
579: ss_instruction_txt,
580: allow_attachment_flag,
581: document_url_txt
582: FROM igf_ap_td_item_mst_all
583: WHERE rowid = x_rowid
584: FOR UPDATE NOWAIT;
585:
586: tlinfo c1%ROWTYPE;

Line 711: UPDATE igf_ap_td_item_mst_all

707: x_document_url_txt => x_document_url_txt
708:
709: );
710:
711: UPDATE igf_ap_td_item_mst_all
712: SET
713: item_code = new_references.item_code,
714: ci_cal_type = new_references.ci_cal_type,
715: ci_sequence_number = new_references.ci_sequence_number,

Line 771: FROM igf_ap_td_item_mst_all

767: || (reverse chronological order - newest change first)
768: */
769: CURSOR c1 IS
770: SELECT rowid
771: FROM igf_ap_td_item_mst_all
772: WHERE todo_number = x_todo_number;
773:
774: BEGIN
775:

Line 848: DELETE FROM igf_ap_td_item_mst_all

844: p_action => 'DELETE',
845: x_rowid => x_rowid
846: );
847:
848: DELETE FROM igf_ap_td_item_mst_all
849: WHERE rowid = x_rowid;
850:
851: IF (SQL%NOTFOUND) THEN
852: RAISE NO_DATA_FOUND;

Line 858: END igf_ap_td_item_mst_pkg;

854:
855: END delete_row;
856:
857:
858: END igf_ap_td_item_mst_pkg;