APPS.IGF_SE_PAYMENT_PUB dependencies on IGF_SE_PAYMENT

Line 1: PACKAGE BODY igf_se_payment_pub AS

1: PACKAGE BODY igf_se_payment_pub AS
2: /* $Header: IGFSE02B.pls 120.0 2005/06/01 15:00:56 appldev noship $ */
3: /*=======================================================================+
4: | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|
5: | All rights reserved. |

Line 9: | PL/SQL body for package: igf_se_payment_pub |

5: | All rights reserved. |
6: +=======================================================================+
7: | |
8: | DESCRIPTION |
9: | PL/SQL body for package: igf_se_payment_pub |
10: | |
11: | NOTES |
12: | |
13: | |

Line 79: fnd_message.set_token('NAME','IGF_SE_PAYMENT_PUB '||SQLERRM);

75:
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
79: fnd_message.set_token('NAME','IGF_SE_PAYMENT_PUB '||SQLERRM);
80: fnd_msg_pub.add;
81:
82: fnd_msg_pub.count_and_get(
83: p_encoded => fnd_api.g_false,

Line 96: CURSOR c_check_payroll (p_payroll_id igf_se_payment.payroll_id%TYPE,

92: ) IS
93:
94: -- cursor to check if the existing payroll id, person id and authorization id
95: -- is already existing in the system. this cursor will have FTS ?
96: CURSOR c_check_payroll (p_payroll_id igf_se_payment.payroll_id%TYPE,
97: p_auth_id igf_se_auth.auth_id%TYPE,
98: p_person_id hz_parties.party_id%TYPE) IS
99: SELECT ROWID, p.*
100: FROM igf_se_payment p

Line 100: FROM igf_se_payment p

96: CURSOR c_check_payroll (p_payroll_id igf_se_payment.payroll_id%TYPE,
97: p_auth_id igf_se_auth.auth_id%TYPE,
98: p_person_id hz_parties.party_id%TYPE) IS
99: SELECT ROWID, p.*
100: FROM igf_se_payment p
101: WHERE p.payroll_id = p_payroll_id
102: AND p.auth_id = p_auth_id
103: AND p.person_id = p_person_id;
104:

Line 117: l_transaction_id igf_se_payment.transaction_id%TYPE;

113:
114: c_check_payroll_rec c_check_payroll%ROWTYPE;
115: l_fund_id igf_aw_award_all.fund_id%TYPE;
116: l_rowid VARCHAR2(25);
117: l_transaction_id igf_se_payment.transaction_id%TYPE;
118:
119: CURSOR c_pers_num(
120: cp_person_id hz_parties.party_id%TYPE
121: ) IS

Line 148: igf_se_payment_pkg.update_row(

144: OPEN c_check_payroll(p_payment_record.payroll_id, p_payment_record.authorization_id, p_payment_record.person_id);
145: FETCH c_check_payroll INTO c_check_payroll_rec; CLOSE c_check_payroll;
146: IF(c_check_payroll_rec.transaction_id IS NOT NULL)THEN
147: -- call to update the new payment information
148: igf_se_payment_pkg.update_row(
149: x_rowid => c_check_payroll_rec.rowid,
150: x_transaction_id => c_check_payroll_rec.transaction_id,
151: x_payroll_id => c_check_payroll_rec.payroll_id,
152: x_payroll_date => p_payment_record.payroll_date,

Line 168: igf_se_payment_pkg.insert_row(

164: FETCH c_get_fund_id INTO l_fund_id; CLOSE c_get_fund_id;
165: IF(l_fund_id IS NOT NULL)THEN
166: -- call to record the existing payment information
167:
168: igf_se_payment_pkg.insert_row(
169: x_rowid => l_rowid,
170: x_transaction_id => l_transaction_id,
171: x_payroll_id => p_payment_record.payroll_id,
172: x_payroll_date => p_payment_record.payroll_date,

Line 203: END igf_se_payment_pub;

199: END IF;
200: END IF; -- end of payroll exists check
201: END do_create_payment;
202:
203: END igf_se_payment_pub;