2305: l_worksheet_names worksheetTable;
2306: l_worksheet_seq_numbers worksheetSeqNumTable;
2307:
2308: -- Person party id
2309: l_person_party_id fnd_user.person_party_id%TYPE;
2310:
2311: -- Timezone variables
2312: l_oex_timezone VARCHAR2(80);
2313: l_timezone VARCHAR2(80);
2322: BEGIN
2323:
2324: select person_party_id
2325: into l_person_party_id
2326: from fnd_user
2327: where user_id = p_user_id;
2328:
2329: -- Set timezone variables
2330: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
2498: l_worksheet_names worksheetTable;
2499: l_worksheet_seq_numbers worksheetSeqNumTable;
2500:
2501: -- Person party id
2502: l_person_party_id fnd_user.person_party_id%TYPE;
2503:
2504: -- Timezone variables
2505: l_oex_timezone VARCHAR2(80);
2506: l_timezone VARCHAR2(80);
2515: BEGIN
2516:
2517: select person_party_id
2518: into l_person_party_id
2519: from fnd_user
2520: where user_id = p_user_id;
2521:
2522: -- Set timezone variables
2523: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;