APPS.PAY_CA_PMED dependencies on PAY_CA_PMED

Line 1: PACKAGE BODY pay_ca_pmed AS

1: PACKAGE BODY pay_ca_pmed AS
2: /* $Header: pycapmcl.pkb 115.1 2003/03/20 00:34:20 ssattini noship $ */
3:
4: ----------------------------- get_source_id ------------------------------
5: /*

Line 31: FROM pay_ca_pmed_accounts pma

27: CURSOR csr_get_src_id1(p_juris VARCHAR2,
28: p_ac_no VARCHAR2,
29: p_bg_no number) IS
30: SELECT pma.source_id
31: FROM pay_ca_pmed_accounts pma
32: WHERE pma.account_number = p_ac_no
33: AND pma.enabled = 'Y'
34: AND pma.business_group_id = p_bg_no;
35:

Line 42: pay_ca_pmed_accounts pma,

38: SELECT pma.source_id,
39: pma.account_number
40: FROM hr_organization_information ogi1,
41: hr_organization_information ogi2,
42: pay_ca_pmed_accounts pma,
43: hr_organization_information ogi3,
44: hr_organization_information ogi4
45: WHERE ogi1.organization_id = p_gre
46: AND ogi1.org_information_context = 'CLASS'

Line 69: pay_ca_pmed_accounts pma,

65: SELECT pma.source_id,
66: pma.account_number
67: FROM hr_organization_information ogi1,
68: hr_organization_information ogi2,
69: pay_ca_pmed_accounts pma,
70: hr_organization_information ogi3,
71: hr_organization_information ogi4
72: WHERE ogi1.organization_id = p_gre
73: AND ogi1.org_information_context = 'CLASS'

Line 94: hr_utility.set_location('pay_ca_pmed', 10);

90: l_source_id NUMBER;
91:
92: BEGIN
93:
94: hr_utility.set_location('pay_ca_pmed', 10);
95: IF p_account_number IS NOT NULL AND
96: p_account_number <> 'NOT ENTERED' THEN
97: hr_utility.set_location('pay_ca_pmed', 20);
98: OPEN csr_get_src_id1(p_jurisdiction_code,

Line 97: hr_utility.set_location('pay_ca_pmed', 20);

93:
94: hr_utility.set_location('pay_ca_pmed', 10);
95: IF p_account_number IS NOT NULL AND
96: p_account_number <> 'NOT ENTERED' THEN
97: hr_utility.set_location('pay_ca_pmed', 20);
98: OPEN csr_get_src_id1(p_jurisdiction_code,
99: p_account_number,p_business_group_id);
100: FETCH csr_get_src_id1 INTO l_source_id;
101: CLOSE csr_get_src_id1;

Line 104: hr_utility.set_location('pay_ca_pmed', 30);

100: FETCH csr_get_src_id1 INTO l_source_id;
101: CLOSE csr_get_src_id1;
102: ELSIF p_different_jd IS NOT NULL AND
103: p_different_jd <> 'NOT ENTERED' THEN
104: hr_utility.set_location('pay_ca_pmed', 30);
105: OPEN csr_get_src_id2(p_different_jd,
106: p_tax_unit_id,p_business_group_id);
107: FETCH csr_get_src_id2 INTO l_source_id,
108: p_account_number;

Line 111: hr_utility.set_location('pay_ca_pmed', 40);

107: FETCH csr_get_src_id2 INTO l_source_id,
108: p_account_number;
109: CLOSE csr_get_src_id2;
110: ELSE
111: hr_utility.set_location('pay_ca_pmed', 40);
112: OPEN csr_get_src_id3(p_jurisdiction_code,
113: p_tax_unit_id,p_business_group_id);
114: FETCH csr_get_src_id3 INTO l_source_id,
115: p_account_number;

Line 119: hr_utility.set_location('pay_ca_pmed', 50);

115: p_account_number;
116: CLOSE csr_get_src_id3;
117: END IF;
118:
119: hr_utility.set_location('pay_ca_pmed', 50);
120: RETURN l_source_id;
121:
122: END;
123:

Line 124: END pay_ca_pmed;

120: RETURN l_source_id;
121:
122: END;
123:
124: END pay_ca_pmed;