APPS.IGS_AS_ORDER_HDR_PKG dependencies on IGS_AS_ORDER_HDR

Line 1: PACKAGE BODY Igs_As_Order_Hdr_Pkg AS

1: PACKAGE BODY Igs_As_Order_Hdr_Pkg AS
2: /* $Header: IGSDI70B.pls 120.2 2006/05/26 05:16:53 shimitta ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_as_order_hdr%ROWTYPE;
5: new_references igs_as_order_hdr%ROWTYPE;

Line 4: old_references igs_as_order_hdr%ROWTYPE;

1: PACKAGE BODY Igs_As_Order_Hdr_Pkg AS
2: /* $Header: IGSDI70B.pls 120.2 2006/05/26 05:16:53 shimitta ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_as_order_hdr%ROWTYPE;
5: new_references igs_as_order_hdr%ROWTYPE;
6: PROCEDURE set_column_values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 ,

Line 5: new_references igs_as_order_hdr%ROWTYPE;

1: PACKAGE BODY Igs_As_Order_Hdr_Pkg AS
2: /* $Header: IGSDI70B.pls 120.2 2006/05/26 05:16:53 shimitta ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_as_order_hdr%ROWTYPE;
5: new_references igs_as_order_hdr%ROWTYPE;
6: PROCEDURE set_column_values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 ,
9: x_order_number IN NUMBER ,

Line 55: FROM igs_as_order_hdr

51: || (reverse chronological order - newest change first)
52: */
53: CURSOR cur_old_ref_values IS
54: SELECT *
55: FROM igs_as_order_hdr
56: WHERE ROWID = x_rowid;
57: BEGIN
58: l_rowid := x_rowid;
59: -- Code for setting the Old and New Reference Values.

Line 166: igs_as_doc_details_pkg.get_fk_igs_as_order_hdr (

162: || Who When What
163: || (reverse chronological order - newest change first)
164: */
165: BEGIN
166: igs_as_doc_details_pkg.get_fk_igs_as_order_hdr (
167: old_references.order_number
168: );
169: NULL;
170: --commented for testing by sjalasut

Line 186: FROM igs_as_order_hdr

182: || (reverse chronological order - newest change first)
183: */
184: CURSOR cur_rowid IS
185: SELECT ROWID
186: FROM igs_as_order_hdr
187: WHERE order_number = x_order_number
188: FOR UPDATE NOWAIT;
189: lv_rowid cur_rowid%ROWTYPE;
190: BEGIN

Line 215: FROM igs_as_order_hdr

211: || (reverse chronological order - newest change first)
212: */
213: CURSOR cur_rowid IS
214: SELECT ROWID
215: FROM igs_as_order_hdr
216: WHERE ((invoice_id = x_invoice_id));
217: lv_rowid cur_rowid%ROWTYPE;
218: BEGIN
219: OPEN cur_rowid;

Line 396: FROM igs_as_order_hdr

392: || (reverse chronological order - newest change first)
393: */
394: CURSOR c IS
395: SELECT ROWID
396: FROM igs_as_order_hdr
397: WHERE order_number = x_order_number;
398: x_last_update_date DATE;
399: x_last_updated_by NUMBER;
400: x_last_update_login NUMBER;

Line 442: SELECT igs_as_order_hdr_s.NEXTVAL

438:
439: END IF;
440: -- adding this if codition to avoid Lock row problem from self service pages
441: IF x_order_number IS NULL THEN
442: SELECT igs_as_order_hdr_s.NEXTVAL
443: INTO x_order_number
444: FROM dual;
445: END IF;
446: before_dml(

Line 484: INSERT INTO igs_as_order_hdr (

480: x_last_update_login => x_last_update_login ,
481: x_order_description => x_order_description,
482: x_order_placed_by => x_order_placed_by
483: );
484: INSERT INTO igs_as_order_hdr (
485: order_number,
486: order_status,
487: date_completed,
488: person_id,

Line 687: FROM igs_as_order_hdr

683: invoice_id,
684: order_description ,
685: order_placed_by
686:
687: FROM igs_as_order_hdr
688: WHERE ROWID = x_rowid
689: FOR UPDATE NOWAIT;
690: tlinfo c1%ROWTYPE;
691: BEGIN

Line 908: UPDATE igs_as_order_hdr

904: ELSE
905: x_program_update_date := SYSDATE;
906: END IF;
907: END IF;
908: UPDATE igs_as_order_hdr
909: SET
910: order_status = new_references.order_status,
911: date_completed = new_references.date_completed,
912: person_id = new_references.person_id,

Line 1035: FROM igs_as_order_hdr

1031: || (reverse chronological order - newest change first)
1032: */
1033: CURSOR c1 IS
1034: SELECT ROWID
1035: FROM igs_as_order_hdr
1036: WHERE order_number = x_order_number;
1037: BEGIN
1038:
1039: -- Initailize the error count, error data etc.

Line 1230: DELETE FROM igs_as_order_hdr

1226: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1227: RAISE FND_API.G_EXC_ERROR;
1228: END IF;
1229: END IF;
1230: DELETE FROM igs_as_order_hdr
1231: WHERE ROWID = x_rowid;
1232: IF (SQL%NOTFOUND) THEN
1233: RAISE NO_DATA_FOUND;
1234: END IF;

Line 1271: END Igs_As_Order_Hdr_Pkg;

1267: p_count => x_MSG_COUNT,
1268: p_data => X_MSG_DATA);
1269: RETURN;
1270: END delete_row;
1271: END Igs_As_Order_Hdr_Pkg;