DBA Data[Home] [Help]

APPS.RCV_TABLE_FUNCTIONS dependencies on MTL_PARAMETERS

Line 19: g_mp_row mtl_parameters%ROWTYPE;

15: g_prl_row po_requisition_lines_all%ROWTYPE;
16: g_prd_row po_req_distributions_all%ROWTYPE;
17: g_msi_row mtl_system_items%ROWTYPE;
18: g_mic_row mtl_item_categories%ROWTYPE;
19: g_mp_row mtl_parameters%ROWTYPE;
20: g_rp_row rcv_parameters%ROWTYPE;
21: g_fc_row fnd_currencies%ROWTYPE;
22: g_sob_row gl_sets_of_books%ROWTYPE;
23: g_fsp_row financials_system_parameters%ROWTYPE;

Line 1002: FUNCTION get_mp_row_from_org( p_org_id IN mtl_parameters.organization_id%TYPE )

998: WHEN OTHERS THEN
999: invalid_value(p_item_id, 'ITEM_ID');
1000: END get_mic_row_from_num;
1001:
1002: FUNCTION get_mp_row_from_org( p_org_id IN mtl_parameters.organization_id%TYPE )
1003: RETURN mtl_parameters%ROWTYPE IS
1004: BEGIN
1005: IF ( p_org_id IS NULL ) THEN
1006: RETURN NULL;

Line 1003: RETURN mtl_parameters%ROWTYPE IS

999: invalid_value(p_item_id, 'ITEM_ID');
1000: END get_mic_row_from_num;
1001:
1002: FUNCTION get_mp_row_from_org( p_org_id IN mtl_parameters.organization_id%TYPE )
1003: RETURN mtl_parameters%ROWTYPE IS
1004: BEGIN
1005: IF ( p_org_id IS NULL ) THEN
1006: RETURN NULL;
1007: END IF;

Line 1015: FROM mtl_parameters

1011: END IF;
1012:
1013: SELECT *
1014: INTO g_mp_row
1015: FROM mtl_parameters
1016: WHERE organization_id = p_org_id
1017: AND rownum = 1;
1018:
1019: RETURN g_mp_row;

Line 1166: FROM mtl_parameters

1162: BEGIN
1163: IF ( nvl(g_mp_org_id,-99) <> p_organization_id) THEN
1164: SELECT nvl(lcm_enabled_flag,'N')
1165: INTO g_lcm_enabled_flag
1166: FROM mtl_parameters
1167: WHERE organization_id = p_organization_id;
1168:
1169: g_mp_org_id := p_organization_id;
1170: END IF;