APPS.PO_INTERFACE_S dependencies on GL_SETS_OF_BOOKS

Line 83: (currency_code gl_sets_of_books.currency_code%type,

79: );
80:
81: /* Type declaration for System Parameters structure */
82: TYPE system_parameters_type IS RECORD
83: (currency_code gl_sets_of_books.currency_code%type,
84: coa_id number,
85: po_encumbrance_flag varchar2(1),
86: req_encumbrance_flag varchar2(1),
87: sob_id number,

Line 6670: , GL_SETS_OF_BOOKS GSOB

6666: SELECT PS1.period_name
6667: INTO params.period_name
6668: FROM GL_PERIOD_STATUSES PS1
6669: , GL_PERIOD_STATUSES PS2
6670: , GL_SETS_OF_BOOKS GSOB
6671: WHERE PS1.application_id = x_gl_appl_id
6672: AND PS1.set_of_books_id = params.sob_id
6673: AND PS1.adjustment_period_flag = 'N'
6674: AND trunc(sysdate) BETWEEN trunc(PS1.start_date)

Line 8459: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198

8455: l_ext_precision FND_CURRENCIES.extended_precision%TYPE;
8456: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
8457:
8458: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
8459: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198
8460: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
8461: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
8462: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
8463: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;

Line 8525: -- Bug 3794198: Join to financials_system_params_all and gl_sets_of_books to

8521:
8522: ELSE -- ( p_interface_source_code NOT IN ('SOURCING','CONSUMPTION_ADVICE') )
8523:
8524: -- Retrieve information from the backing Requisition Line.
8525: -- Bug 3794198: Join to financials_system_params_all and gl_sets_of_books to
8526: -- retrieve the value of l_req_ou_currency_code, the functional currency of ROU
8527: SELECT PRL.currency_code
8528: , GSB.currency_code
8529: , PRL.unit_price

Line 8541: gl_sets_of_books GSB

8537: , l_req_amount
8538: , l_req_currency_amount
8539: FROM po_requisition_lines_all PRL,
8540: financials_system_params_all FSP,
8541: gl_sets_of_books GSB
8542: WHERE PRL.requisition_line_id = p_requisition_line_id
8543: AND nvl(PRL.org_id, -99) = nvl(FSP.org_id, -99)
8544: AND FSP.set_of_books_id = GSB.set_of_books_id;
8545:

Line 13903: l_req_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

13899: x_rate OUT NOCOPY NUMBER
13900: )
13901: IS
13902:
13903: l_req_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
13904: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
13905: l_inverse_rate_display_flag VARCHAR2(1) := 'N';
13906: l_display_rate NUMBER;
13907: l_progress VARCHAR2(3) := '000';

Line 13904: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

13900: )
13901: IS
13902:
13903: l_req_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
13904: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
13905: l_inverse_rate_display_flag VARCHAR2(1) := 'N';
13906: l_display_rate NUMBER;
13907: l_progress VARCHAR2(3) := '000';
13908: l_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;