APPS.IGS_FI_CR_ACTIVITIES_PKG dependencies on IGS_FI_CR_ACTIVITIES

Line 1: PACKAGE BODY igs_fi_cr_activities_pkg AS

1: PACKAGE BODY igs_fi_cr_activities_pkg AS
2: /* $Header: IGSSI87B.pls 115.15 2003/02/17 09:01:48 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_cr_activities%ROWTYPE;

Line 5: old_references igs_fi_cr_activities%ROWTYPE;

1: PACKAGE BODY igs_fi_cr_activities_pkg AS
2: /* $Header: IGSSI87B.pls 115.15 2003/02/17 09:01:48 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_cr_activities%ROWTYPE;
6: new_references igs_fi_cr_activities%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_cr_activities%ROWTYPE;

2: /* $Header: IGSSI87B.pls 115.15 2003/02/17 09:01:48 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_cr_activities%ROWTYPE;
6: new_references igs_fi_cr_activities%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 47: FROM IGS_FI_CR_ACTIVITIES

43: */
44:
45: CURSOR cur_old_ref_values IS
46: SELECT *
47: FROM IGS_FI_CR_ACTIVITIES
48: WHERE rowid = x_rowid;
49:
50: BEGIN
51:

Line 199: igs_fi_applications_pkg.get_fk_igs_fi_cr_activities (

195: || shtatiko 04-Dec-2002 Added call to igs_fi_bill_dpsts_pkg, Bug# 2584741
196: */
197: BEGIN
198:
199: igs_fi_applications_pkg.get_fk_igs_fi_cr_activities (
200: old_references.credit_activity_id
201: );
202:
203: igs_fi_bill_trnsctns_pkg.get_fk_igs_fi_cr_activities (

Line 203: igs_fi_bill_trnsctns_pkg.get_fk_igs_fi_cr_activities (

199: igs_fi_applications_pkg.get_fk_igs_fi_cr_activities (
200: old_references.credit_activity_id
201: );
202:
203: igs_fi_bill_trnsctns_pkg.get_fk_igs_fi_cr_activities (
204: old_references.credit_activity_id
205: );
206:
207: igs_fi_bill_dpsts_pkg.get_fk_igs_fi_cr_activities (

Line 207: igs_fi_bill_dpsts_pkg.get_fk_igs_fi_cr_activities (

203: igs_fi_bill_trnsctns_pkg.get_fk_igs_fi_cr_activities (
204: old_references.credit_activity_id
205: );
206:
207: igs_fi_bill_dpsts_pkg.get_fk_igs_fi_cr_activities (
208: old_references.credit_activity_id
209: );
210:
211: END check_child_existance;

Line 228: FROM igs_fi_cr_activities

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

Line 297: FROM igs_fi_cr_activities

293: || (reverse chronological order - newest change first)
294: */
295: CURSOR cur_rowid IS
296: SELECT rowid
297: FROM igs_fi_cr_activities
298: WHERE ((credit_id = x_credit_id));
299:
300: lv_rowid cur_rowid%RowType;
301:

Line 332: FROM igs_fi_cr_activities

328: || (reverse chronological order - newest change first)
329: */
330: CURSOR cur_rowid IS
331: SELECT rowid
332: FROM igs_fi_cr_activities
333: WHERE ((posting_id = x_posting_id));
334:
335: lv_rowid cur_rowid%RowType;
336:

Line 486: FROM igs_fi_cr_activities

482: || (reverse chronological order - newest change first)
483: */
484: CURSOR c IS
485: SELECT rowid
486: FROM igs_fi_cr_activities
487: WHERE credit_activity_id = x_credit_activity_id;
488:
489: x_last_update_date DATE;
490: x_last_updated_by NUMBER;

Line 530: SELECT igs_fi_cr_activities_s.NEXTVAL

526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: END IF;
529:
530: SELECT igs_fi_cr_activities_s.NEXTVAL
531: INTO x_credit_activity_id
532: FROM dual;
533:
534: before_dml(

Line 560: INSERT INTO igs_fi_cr_activities (

556: x_gl_posted_date => x_gl_posted_date,
557: x_posting_control_id => x_posting_control_id
558: );
559:
560: INSERT INTO igs_fi_cr_activities (
561: credit_activity_id,
562: credit_id,
563: status,
564: transaction_date,

Line 673: FROM igs_fi_cr_activities

669: posting_id ,
670: gl_date,
671: gl_posted_date,
672: posting_control_id
673: FROM igs_fi_cr_activities
674: WHERE rowid = x_rowid
675: FOR UPDATE NOWAIT;
676:
677: tlinfo c1%ROWTYPE;

Line 821: UPDATE igs_fi_cr_activities

817: x_program_update_date := SYSDATE;
818: END IF;
819: END IF;
820:
821: UPDATE igs_fi_cr_activities
822: SET
823: credit_id = new_references.credit_id,
824: status = new_references.status,
825: transaction_date = new_references.transaction_date,

Line 887: FROM igs_fi_cr_activities

883: || (reverse chronological order - newest change first)
884: */
885: CURSOR c1 IS
886: SELECT rowid
887: FROM igs_fi_cr_activities
888: WHERE credit_activity_id = x_credit_activity_id;
889:
890: BEGIN
891:

Line 964: DELETE FROM igs_fi_cr_activities

960: p_action => 'DELETE',
961: x_rowid => x_rowid
962: );
963:
964: DELETE FROM igs_fi_cr_activities
965: WHERE rowid = x_rowid;
966:
967: IF (SQL%NOTFOUND) THEN
968: RAISE NO_DATA_FOUND;

Line 974: END igs_fi_cr_activities_pkg;

970:
971: END delete_row;
972:
973:
974: END igs_fi_cr_activities_pkg;