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.PQP_PENSION_PROVIDERS dependencies on HR_ORG_INFORMATION_PKG

Line 299: hr_org_information_pkg.insert_row(

295: x_attribute19 => NULL,
296: x_attribute20 => NULL );
297:
298: -- Add a Organization classification of Pension Provider to the Org
299: hr_org_information_pkg.insert_row(
300: x_rowid => l_org_info_rowid,
301: x_org_information_id => l_org_information_id,
302: x_org_information_context => p_org_information_context,
303: x_organization_id => l_organization_id,

Line 451: hr_org_information_pkg.insert_row

447: l_org_information_id number;
448:
449: BEGIN
450:
451: hr_org_information_pkg.insert_row
452: (x_rowid => l_hoi_rowid,
453: x_org_information_id => l_org_information_id,
454: x_org_information_context => p_org_information_context,
455: x_organization_id => p_organization_id,

Line 520: hr_org_information_pkg.insert_row

516: l_org_information_id number;
517:
518: BEGIN
519:
520: hr_org_information_pkg.insert_row
521: (x_rowid => l_hoi_rowid,
522: x_org_information_id => l_org_information_id,
523: x_org_information_context => p_org_information_context,
524: x_organization_id => p_organization_id,

Line 584: hr_org_information_pkg.insert_row

580: l_org_information_id number;
581:
582: BEGIN
583:
584: hr_org_information_pkg.insert_row
585: (x_rowid => l_hoi_rowid,
586: x_org_information_id => l_org_information_id,
587: x_org_information_context => 'CLASS',
588: x_organization_id => p_organization_id,

Line 706: hr_utility.set_location(' INSERT Mode, Calling: hr_org_information_pkg.Insert_Row', 15);

702: Close csr_pen_type;
703: End If;
704: -- Insert the information into the hr_organization_information table
705: If p_transaction_mode = 'INSERT' Then
706: hr_utility.set_location(' INSERT Mode, Calling: hr_org_information_pkg.Insert_Row', 15);
707:
708: open csr_assigned_pen_types;
709: Fetch csr_assigned_pen_types Into l_assigned_pen_type;
710: If csr_assigned_pen_types%Found Then

Line 718: hr_org_information_pkg.insert_row

714: fnd_message.raise_error;
715: Close csr_assigned_pen_types;
716: End If;
717:
718: hr_org_information_pkg.insert_row
719: (x_rowid => l_hoi_rowid,
720: x_org_information_id => l_org_information_id,
721: x_org_information_context => 'PQP_NL_ER_PENSION_TYPES',
722: x_organization_id => p_organization_id,

Line 768: hr_utility.set_location(' UPDATE Mode, Calling: hr_org_information_pkg.Update_Row', 25);

764: );
765: p_org_information_id := l_org_information_id;
766: ElsIf p_transaction_mode = 'UPDATE' Then
767:
768: hr_utility.set_location(' UPDATE Mode, Calling: hr_org_information_pkg.Update_Row', 25);
769: --
770: -- Get the rowid for the org_information_id passed
771: --
772: Open csr_org_info;

Line 786: hr_org_information_pkg.Update_Row

782: Else
783: Close csr_org_info;
784: End If;
785: -- Update the information in the hr_organization_information table
786: hr_org_information_pkg.Update_Row
787: (X_Rowid => l_hoi_rowid,
788: X_Org_Information_Id => p_org_information_id,
789: x_org_information_context => 'PQP_NL_ER_PENSION_TYPES',
790: x_organization_id => p_organization_id,

Line 951: hr_org_information_pkg.delete_row(l_org_info_rowid);

947: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');
948: fnd_message.raise_error;
949: ELSE
950: close c_is_pentype_attached_nl;
951: hr_org_information_pkg.delete_row(l_org_info_rowid);
952: END IF; -- if c_is_pentype_attached_nl
953: END IF; -- if c_chk_asg_employer
954: ELSIF p_legislation_code = 'GB' THEN
955: -- if the legislation code is GB

Line 966: hr_org_information_pkg.delete_row(l_org_info_rowid);

962: fnd_message.raise_error;
963: ELSE
964: -- It is not assigned so it can be deleted.
965: close c_is_pentype_attached_gb;
966: hr_org_information_pkg.delete_row(l_org_info_rowid);
967: END IF;
968: ELSIF p_legislation_code = 'HU' THEN
969: -- if the legislation code is HU
970: OPEN c_is_pentype_attached_hu;

Line 980: hr_org_information_pkg.delete_row(l_org_info_rowid);

976: fnd_message.raise_error;
977: ELSE
978: -- It is not assigned so it can be deleted.
979: close c_is_pentype_attached_hu;
980: hr_org_information_pkg.delete_row(l_org_info_rowid);
981: END IF;
982: ELSIF p_legislation_code = 'IE' THEN
983: -- if the legislation code is IE
984: OPEN c_is_pentype_attached_ie;

Line 994: hr_org_information_pkg.delete_row(l_org_info_rowid);

990: fnd_message.raise_error;
991: ELSE
992: -- It is not assigned so it can be deleted.
993: close c_is_pentype_attached_ie;
994: hr_org_information_pkg.delete_row(l_org_info_rowid);
995: END IF;
996: END IF;
997: ELSE
998: close csr_org_info;

Line 1030: hr_org_information_pkg.delete_row(l_org_info_rowid);

1026: -- if a row has been found specifying third party payment
1027: -- then delete it from hr_org_information table
1028: IF csr_org_info%FOUND THEN
1029: close csr_org_info;
1030: hr_org_information_pkg.delete_row(l_org_info_rowid);
1031: ELSE
1032: close csr_org_info;
1033: END IF;
1034:

Line 1124: hr_org_information_pkg.delete_row(l_org_info_rowid);

1120: loop
1121: fetch csr_pen_types_org_info into l_org_info_rowid;
1122: exit when csr_pen_types_org_info%NOTFOUND;
1123: -- delete the org info row containing this pension type
1124: hr_org_information_pkg.delete_row(l_org_info_rowid);
1125: end loop;
1126:
1127: close csr_pen_types_org_info;
1128:

Line 1136: hr_org_information_pkg.update_row(

1132: close csr_org_info;
1133:
1134: hr_utility.set_location(' Leaving:' ,40);
1135: -- Disable the Organization classification of Pension Provider of the Org
1136: hr_org_information_pkg.update_row(
1137: x_rowid => l_org_info_rowid,
1138: x_org_information_id => l_org_information_id,
1139: x_org_information_context => l_org_information_context,
1140: x_organization_id => p_organization_id,

Line 1260: hr_org_information_pkg.update_row(

1256: l_org_information_context,l_org_classification;
1257: close csr_org_info;
1258: hr_utility.set_location(' Leaving:' ,40);
1259: -- Disable the Organization classification of Pension Provider of the Org
1260: hr_org_information_pkg.update_row(
1261: x_rowid => l_org_info_rowid,
1262: x_org_information_id => l_org_information_id,
1263: x_org_information_context => l_org_information_context,
1264: x_organization_id => p_organization_id,

Line 1315: hr_org_information_pkg.delete_row(l_org_info_rowid);

1311: loop
1312: fetch csr_pen_types_org_info into l_org_info_rowid;
1313: exit when csr_pen_types_org_info%NOTFOUND;
1314: -- delete the org info row containing this pension type
1315: hr_org_information_pkg.delete_row(l_org_info_rowid);
1316: end loop;
1317:
1318: close csr_pen_types_org_info;
1319:

Line 1330: hr_org_information_pkg.update_row(

1326: if csr_third_party_org_info%Found Then
1327: -- Disable the Third Party Payment Organization classification
1328: -- of Pension Provider
1329: close csr_third_party_org_info;
1330: hr_org_information_pkg.update_row(
1331: x_rowid => l_org_info_rowid,
1332: x_org_information_id => l_org_information_id,
1333: x_org_information_context => l_org_information_context,
1334: x_organization_id => p_organization_id,

Line 1506: hr_org_information_pkg.update_row(

1502: l_org_information_context,l_org_classification;
1503: close csr_org_info;
1504: hr_utility.set_location(' Leaving:' ,40);
1505: -- Disable the Organization classification of Pension Provider of the Org
1506: hr_org_information_pkg.update_row(
1507: x_rowid => l_org_info_rowid,
1508: x_org_information_id => l_org_information_id,
1509: x_org_information_context => l_org_information_context,
1510: x_organization_id => p_organization_id,

Line 1561: hr_org_information_pkg.delete_row(l_org_info_rowid);

1557: loop
1558: fetch csr_pen_types_org_info into l_org_info_rowid;
1559: exit when csr_pen_types_org_info%NOTFOUND;
1560: -- delete the org info row containing this pension type
1561: hr_org_information_pkg.delete_row(l_org_info_rowid);
1562: end loop;
1563:
1564: close csr_pen_types_org_info;
1565:

Line 1576: hr_org_information_pkg.update_row(

1572: if csr_third_party_org_info%Found Then
1573: -- Disable the Third Party Payment Organization classification
1574: -- of Pension Provider
1575: close csr_third_party_org_info;
1576: hr_org_information_pkg.update_row(
1577: x_rowid => l_org_info_rowid,
1578: x_org_information_id => l_org_information_id,
1579: x_org_information_context => l_org_information_context,
1580: x_organization_id => p_organization_id,

Line 1751: hr_org_information_pkg.update_row(

1747: l_org_information_context,l_org_classification;
1748: close csr_org_info;
1749: hr_utility.set_location(' Leaving:' ,40);
1750: -- Disable the Organization classification of Pension Provider of the Org
1751: hr_org_information_pkg.update_row(
1752: x_rowid => l_org_info_rowid,
1753: x_org_information_id => l_org_information_id,
1754: x_org_information_context => l_org_information_context,
1755: x_organization_id => p_organization_id,

Line 1806: hr_org_information_pkg.delete_row(l_org_info_rowid);

1802: loop
1803: fetch csr_pen_types_org_info into l_org_info_rowid;
1804: exit when csr_pen_types_org_info%NOTFOUND;
1805: -- delete the org info row containing this pension type
1806: hr_org_information_pkg.delete_row(l_org_info_rowid);
1807: end loop;
1808:
1809: close csr_pen_types_org_info;
1810:

Line 1821: hr_org_information_pkg.update_row(

1817: if csr_third_party_org_info%Found Then
1818: -- Disable the Third Party Payment Organization classification
1819: -- of Pension Provider
1820: close csr_third_party_org_info;
1821: hr_org_information_pkg.update_row(
1822: x_rowid => l_org_info_rowid,
1823: x_org_information_id => l_org_information_id,
1824: x_org_information_context => l_org_information_context,
1825: x_organization_id => p_organization_id,

Line 3132: hr_org_information_pkg.delete_row(l_hoi_rowid);

3128: fnd_message.raise_error;
3129: Else
3130: -- found the rowid,now call the delete procedure
3131: Close csr_org_info;
3132: hr_org_information_pkg.delete_row(l_hoi_rowid);
3133: End If;
3134:
3135: End delete_assigned_providers;
3136: