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.IGS_FI_PRC_SP_FEES dependencies on IGS_FI_SPA_FEE_PRDS

Line 44: FUNCTION fisp_lock_records(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,

40: g_v_no CONSTANT VARCHAR2(1) := 'N';
41: g_v_sua_status CONSTANT VARCHAR2(20) := 'UNIT_ATTEMPT_STATUS';
42: g_v_alternatecode igs_ca_inst.alternate_code%TYPE;
43:
44: FUNCTION fisp_lock_records(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
45: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
46: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
47: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE) RETURN BOOLEAN;
48:

Line 45: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,

41: g_v_sua_status CONSTANT VARCHAR2(20) := 'UNIT_ATTEMPT_STATUS';
42: g_v_alternatecode igs_ca_inst.alternate_code%TYPE;
43:
44: FUNCTION fisp_lock_records(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
45: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
46: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
47: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE) RETURN BOOLEAN;
48:
49: PROCEDURE log_details(p_v_person_number IN hz_parties.party_number%TYPE,

Line 46: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,

42: g_v_alternatecode igs_ca_inst.alternate_code%TYPE;
43:
44: FUNCTION fisp_lock_records(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
45: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
46: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
47: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE) RETURN BOOLEAN;
48:
49: PROCEDURE log_details(p_v_person_number IN hz_parties.party_number%TYPE,
50: p_v_fee_period IN VARCHAR2,

Line 47: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE) RETURN BOOLEAN;

43:
44: FUNCTION fisp_lock_records(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
45: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
46: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
47: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE) RETURN BOOLEAN;
48:
49: PROCEDURE log_details(p_v_person_number IN hz_parties.party_number%TYPE,
50: p_v_fee_period IN VARCHAR2,
51: p_v_unit_section_desc IN VARCHAR2,

Line 1364: -- Before processing, obtain a lock in table IGS_FI_SPA_FEE_PRDS for the given Person-Course-Fee Period.

1360: cp_v_ld_cal_type => p_v_load_cal_type,
1361: cp_n_ld_seq_number => p_n_load_ci_seq_number )
1362: LOOP
1363: --If fee period is provided
1364: -- Before processing, obtain a lock in table IGS_FI_SPA_FEE_PRDS for the given Person-Course-Fee Period.
1365: IF (l_v_fee_cal_type IS NOT NULL) AND (l_n_fee_ci_sequence_number IS NOT NULL) THEN
1366: IF NOT fisp_lock_records (p_n_person_id => l_c_get_todo_ref_recs.person_id,
1367: p_v_course_cd => l_c_get_todo_ref_recs.course_cd,
1368: p_v_fee_cal_type => l_v_fee_cal_type,

Line 1398: -- Before processing, obtain a lock in table IGS_FI_SPA_FEE_PRDS for the given Person-Course-Fee Period.

1394: p_v_message_name =>l_message_name);
1395: END IF;
1396: END IF ; --igs_fi_gen_001
1397:
1398: -- Before processing, obtain a lock in table IGS_FI_SPA_FEE_PRDS for the given Person-Course-Fee Period.
1399: -- if fee period is not provided
1400: IF NOT fisp_lock_records (p_n_person_id => l_c_get_todo_ref_recs.person_id,
1401: p_v_course_cd => l_c_get_todo_ref_recs.course_cd,
1402: p_v_fee_cal_type => l_v_fee_cal_type,

Line 1554: FUNCTION fisp_insert_record(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,

1550:
1551: END process_special_fees;
1552:
1553:
1554: FUNCTION fisp_insert_record(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
1555: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
1556: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1557: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE)
1558: RETURN BOOLEAN

Line 1555: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,

1551: END process_special_fees;
1552:
1553:
1554: FUNCTION fisp_insert_record(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
1555: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
1556: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1557: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE)
1558: RETURN BOOLEAN
1559: IS

Line 1556: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,

1552:
1553:
1554: FUNCTION fisp_insert_record(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
1555: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
1556: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1557: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE)
1558: RETURN BOOLEAN
1559: IS
1560: PRAGMA AUTONOMOUS_TRANSACTION;

Line 1557: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE)

1553:
1554: FUNCTION fisp_insert_record(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
1555: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
1556: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1557: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE)
1558: RETURN BOOLEAN
1559: IS
1560: PRAGMA AUTONOMOUS_TRANSACTION;
1561: /*************************************************************

Line 1564: Purpose : This function locks the record in the table IGS_FI_SPA_FEE_PRDS

1560: PRAGMA AUTONOMOUS_TRANSACTION;
1561: /*************************************************************
1562: Created By : akandreg
1563: Date Created By : 25-May-2006
1564: Purpose : This function locks the record in the table IGS_FI_SPA_FEE_PRDS
1565: based on the combination of Person-Course-Fee Period that is
1566: passed as the input parameters. Added as a fix to prevent
1567: concurrent running of multiple instances of the process.
1568:

Line 1581: igs_fi_spa_fee_prds_pkg.insert_row ( x_rowid => l_rowid,

1577:
1578: BEGIN
1579:
1580: l_rowid := NULL;
1581: igs_fi_spa_fee_prds_pkg.insert_row ( x_rowid => l_rowid,
1582: x_person_id => p_n_person_id,
1583: x_course_cd => p_v_course_cd,
1584: x_fee_cal_type => p_v_fee_cal_type,
1585: x_fee_ci_sequence_number => p_n_fee_ci_sequence_number,

Line 1604: FUNCTION fisp_lock_records(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,

1600: RETURN FALSE;
1601:
1602: END fisp_insert_record;
1603:
1604: FUNCTION fisp_lock_records(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
1605: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
1606: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1607: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE)
1608: RETURN BOOLEAN IS

Line 1605: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,

1601:
1602: END fisp_insert_record;
1603:
1604: FUNCTION fisp_lock_records(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
1605: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
1606: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1607: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE)
1608: RETURN BOOLEAN IS
1609: /*************************************************************

Line 1606: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,

1602: END fisp_insert_record;
1603:
1604: FUNCTION fisp_lock_records(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
1605: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
1606: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1607: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE)
1608: RETURN BOOLEAN IS
1609: /*************************************************************
1610: Created By : akandreg

Line 1607: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE)

1603:
1604: FUNCTION fisp_lock_records(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
1605: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
1606: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1607: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE)
1608: RETURN BOOLEAN IS
1609: /*************************************************************
1610: Created By : akandreg
1611: Date Created By : 25-May-2006

Line 1612: Purpose : Bug 5134636. This function locks the record in the table IGS_FI_SPA_FEE_PRDS

1608: RETURN BOOLEAN IS
1609: /*************************************************************
1610: Created By : akandreg
1611: Date Created By : 25-May-2006
1612: Purpose : Bug 5134636. This function locks the record in the table IGS_FI_SPA_FEE_PRDS
1613: based on the combination of Person-Course-Fee Period that is
1614: passed as the input parameters. Added as a fix to prevent
1615: concurrent running of multiple instances of the process.
1616:

Line 1624: CURSOR cur_fee_spa (cp_person_id igs_fi_spa_fee_prds.person_id%TYPE,

1620: Change History
1621: Who When What
1622: ***************************************************************/
1623:
1624: CURSOR cur_fee_spa (cp_person_id igs_fi_spa_fee_prds.person_id%TYPE,
1625: cp_course_cd igs_fi_spa_fee_prds.course_cd%TYPE,
1626: cp_fee_cal_type igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1627: cp_fee_ci_sequence_number igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE,
1628: cp_transaction_type igs_fi_spa_fee_prds.transaction_type%TYPE) IS

Line 1625: cp_course_cd igs_fi_spa_fee_prds.course_cd%TYPE,

1621: Who When What
1622: ***************************************************************/
1623:
1624: CURSOR cur_fee_spa (cp_person_id igs_fi_spa_fee_prds.person_id%TYPE,
1625: cp_course_cd igs_fi_spa_fee_prds.course_cd%TYPE,
1626: cp_fee_cal_type igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1627: cp_fee_ci_sequence_number igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE,
1628: cp_transaction_type igs_fi_spa_fee_prds.transaction_type%TYPE) IS
1629: SELECT 'x'

Line 1626: cp_fee_cal_type igs_fi_spa_fee_prds.fee_cal_type%TYPE,

1622: ***************************************************************/
1623:
1624: CURSOR cur_fee_spa (cp_person_id igs_fi_spa_fee_prds.person_id%TYPE,
1625: cp_course_cd igs_fi_spa_fee_prds.course_cd%TYPE,
1626: cp_fee_cal_type igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1627: cp_fee_ci_sequence_number igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE,
1628: cp_transaction_type igs_fi_spa_fee_prds.transaction_type%TYPE) IS
1629: SELECT 'x'
1630: FROM igs_fi_spa_fee_prds

Line 1627: cp_fee_ci_sequence_number igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE,

1623:
1624: CURSOR cur_fee_spa (cp_person_id igs_fi_spa_fee_prds.person_id%TYPE,
1625: cp_course_cd igs_fi_spa_fee_prds.course_cd%TYPE,
1626: cp_fee_cal_type igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1627: cp_fee_ci_sequence_number igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE,
1628: cp_transaction_type igs_fi_spa_fee_prds.transaction_type%TYPE) IS
1629: SELECT 'x'
1630: FROM igs_fi_spa_fee_prds
1631: WHERE person_id = cp_person_id

Line 1628: cp_transaction_type igs_fi_spa_fee_prds.transaction_type%TYPE) IS

1624: CURSOR cur_fee_spa (cp_person_id igs_fi_spa_fee_prds.person_id%TYPE,
1625: cp_course_cd igs_fi_spa_fee_prds.course_cd%TYPE,
1626: cp_fee_cal_type igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1627: cp_fee_ci_sequence_number igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE,
1628: cp_transaction_type igs_fi_spa_fee_prds.transaction_type%TYPE) IS
1629: SELECT 'x'
1630: FROM igs_fi_spa_fee_prds
1631: WHERE person_id = cp_person_id
1632: AND course_cd = cp_course_cd

Line 1630: FROM igs_fi_spa_fee_prds

1626: cp_fee_cal_type igs_fi_spa_fee_prds.fee_cal_type%TYPE,
1627: cp_fee_ci_sequence_number igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE,
1628: cp_transaction_type igs_fi_spa_fee_prds.transaction_type%TYPE) IS
1629: SELECT 'x'
1630: FROM igs_fi_spa_fee_prds
1631: WHERE person_id = cp_person_id
1632: AND course_cd = cp_course_cd
1633: AND fee_cal_type = cp_fee_cal_type
1634: AND fee_ci_sequence_number = cp_fee_ci_sequence_number

Line 1651: -- Call autonomous function to insert into IGS_FI_SPA_FEE_PRDS

1647: FETCH cur_fee_spa INTO l_v_dummy;
1648: IF cur_fee_spa%NOTFOUND THEN
1649: -- If the record does not exist in igs_fi_spa_fee_period table, then insert into the table.
1650: CLOSE cur_fee_spa;
1651: -- Call autonomous function to insert into IGS_FI_SPA_FEE_PRDS
1652: IF fisp_insert_record(p_n_person_id,
1653: p_v_course_cd,
1654: p_v_fee_cal_type,
1655: p_n_fee_ci_sequence_number) THEN