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.PO_PCARD_PKG dependencies on PO_TBL_NUMBER

Line 49: -- PO_TBL_NUMBER consisting of P-Card IDs to validate

45: -- corresponding ID in the input table is a valid and active P-Card.
46: --Parameters:
47: --IN:
48: --p_pcard_id_tbl
49: -- PO_TBL_NUMBER consisting of P-Card IDs to validate
50: --Returns:
51: -- PO_TBL_VARCHAR1 consisting of 'Y' or 'N' indicating whether the
52: -- corresponding ID in the input table is a valid and active P-Card.
53: --Testing:

Line 60: p_pcard_id_tbl IN PO_TBL_NUMBER

56: -------------------------------------------------------------------------------
57: -------------------------------------------------------------------------------
58: FUNCTION get_pcard_valid_active_tbl
59: (
60: p_pcard_id_tbl IN PO_TBL_NUMBER
61: )
62: RETURN PO_TBL_VARCHAR1
63: IS
64: l_result_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

Line 65: l_valid_pcard_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

61: )
62: RETURN PO_TBL_VARCHAR1
63: IS
64: l_result_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
65: l_valid_pcard_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
66: l_key NUMBER;
67: l_pcard_id NUMBER;
68: l_pcard_is_valid BOOLEAN;
69: l_valid_pcards_exist BOOLEAN := false;

Line 212: -- PO_TBL_NUMBER consisting of Supplier identifier

208: -- whether each Vendor Site is P-Card enabled.
209: --Parameters:
210: --IN:
211: --p_vendor_id_tbl
212: -- PO_TBL_NUMBER consisting of Supplier identifier
213: --p_vendor_site_id_tbl
214: -- PO_TBL_NUMBER consisting of Supplier Site identifier
215: --Returns:
216: -- PO_TBL_VARCHAR1 consisting of 'Y' or 'N' indicating whether the

Line 214: -- PO_TBL_NUMBER consisting of Supplier Site identifier

210: --IN:
211: --p_vendor_id_tbl
212: -- PO_TBL_NUMBER consisting of Supplier identifier
213: --p_vendor_site_id_tbl
214: -- PO_TBL_NUMBER consisting of Supplier Site identifier
215: --Returns:
216: -- PO_TBL_VARCHAR1 consisting of 'Y' or 'N' indicating whether the
217: -- corresponding Supplier Site is P-Card enabled.
218: --Testing:

Line 225: p_vendor_id_tbl IN PO_TBL_NUMBER

221: -------------------------------------------------------------------------------
222: -------------------------------------------------------------------------------
223: FUNCTION get_site_pcard_enabled_tbl
224: (
225: p_vendor_id_tbl IN PO_TBL_NUMBER
226: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
227: )
228: RETURN PO_TBL_VARCHAR1
229: IS

Line 226: , p_vendor_site_id_tbl IN PO_TBL_NUMBER

222: -------------------------------------------------------------------------------
223: FUNCTION get_site_pcard_enabled_tbl
224: (
225: p_vendor_id_tbl IN PO_TBL_NUMBER
226: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
227: )
228: RETURN PO_TBL_VARCHAR1
229: IS
230: l_result_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();