DBA Data[Home] [Help]

APPS.IGC_CC_REP_YEP_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 2515: -- p_req_encumbrance_type_id IN financials_system_params_all.req_encumbrance_type_id%TYPE,

2511: PROCEDURE Process_Interface_Row(
2512: /*Bug No : 6341012. SLA Uptake. Encumbrance_Type_Ids are not required*/
2513: -- p_cc_prov_enc_type_id IN NUMBER,
2514: -- p_cc_conf_enc_type_id IN NUMBER,
2515: -- p_req_encumbrance_type_id IN financials_system_params_all.req_encumbrance_type_id%TYPE,
2516: -- p_purch_encumbrance_type_id IN financials_system_params_all.purch_encumbrance_type_id%TYPE,
2517: p_currency_code IN VARCHAR2,
2518: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
2519: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,

Line 2516: -- p_purch_encumbrance_type_id IN financials_system_params_all.purch_encumbrance_type_id%TYPE,

2512: /*Bug No : 6341012. SLA Uptake. Encumbrance_Type_Ids are not required*/
2513: -- p_cc_prov_enc_type_id IN NUMBER,
2514: -- p_cc_conf_enc_type_id IN NUMBER,
2515: -- p_req_encumbrance_type_id IN financials_system_params_all.req_encumbrance_type_id%TYPE,
2516: -- p_purch_encumbrance_type_id IN financials_system_params_all.purch_encumbrance_type_id%TYPE,
2517: p_currency_code IN VARCHAR2,
2518: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
2519: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,
2520: p_cc_pmt_fcst_rec IN igc_cc_det_pf%ROWTYPE,

Line 3856: -- l_req_encumbrance_type_id financials_system_params_all.req_encumbrance_type_id%TYPE;

3852: l_currency_code gl_sets_of_books.currency_code%TYPE;
3853: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
3854: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;
3855: /*Bug No : 6341012. SLA Uptake. Encumbrance Types are not required*/
3856: -- l_req_encumbrance_type_id financials_system_params_all.req_encumbrance_type_id%TYPE;
3857: -- l_purch_encumbrance_type_id financials_system_params_all.purch_encumbrance_type_id%TYPE;
3858: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;
3859: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
3860: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;

Line 3857: -- l_purch_encumbrance_type_id financials_system_params_all.purch_encumbrance_type_id%TYPE;

3853: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
3854: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;
3855: /*Bug No : 6341012. SLA Uptake. Encumbrance Types are not required*/
3856: -- l_req_encumbrance_type_id financials_system_params_all.req_encumbrance_type_id%TYPE;
3857: -- l_purch_encumbrance_type_id financials_system_params_all.purch_encumbrance_type_id%TYPE;
3858: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;
3859: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
3860: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
3861: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;

Line 3858: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;

3854: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;
3855: /*Bug No : 6341012. SLA Uptake. Encumbrance Types are not required*/
3856: -- l_req_encumbrance_type_id financials_system_params_all.req_encumbrance_type_id%TYPE;
3857: -- l_purch_encumbrance_type_id financials_system_params_all.purch_encumbrance_type_id%TYPE;
3858: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;
3859: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
3860: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
3861: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
3862: -- l_cc_prov_enc_type_id igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_type_id%TYPE;

Line 3859: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;

3855: /*Bug No : 6341012. SLA Uptake. Encumbrance Types are not required*/
3856: -- l_req_encumbrance_type_id financials_system_params_all.req_encumbrance_type_id%TYPE;
3857: -- l_purch_encumbrance_type_id financials_system_params_all.purch_encumbrance_type_id%TYPE;
3858: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;
3859: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
3860: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
3861: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
3862: -- l_cc_prov_enc_type_id igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_type_id%TYPE;
3863: -- l_cc_conf_enc_type_id igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_type_id%TYPE;

Line 3926: FROM financials_system_params_all

3922: /*Bug No : 6341012. SLA Uptake. Encumbrance Type ID's are not required*/
3923: BEGIN
3924: SELECT req_encumbrance_flag, purch_encumbrance_flag
3925: INTO l_req_encumbrance_flag, l_purch_encumbrance_flag
3926: FROM financials_system_params_all
3927: WHERE set_of_books_id = p_sob_id AND
3928: org_id = p_org_id;
3929: EXCEPTION
3930: WHEN NO_DATA_FOUND