DBA Data[Home] [Help]

APPS.RCV_TABLE_FUNCTIONS dependencies on RCV_PARAMETERS

Line 20: g_rp_row rcv_parameters%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;
24: g_fspa_row financials_system_params_all%ROWTYPE;

Line 1052: FUNCTION get_rp_row_from_org( p_org_id IN rcv_parameters.organization_id%TYPE )

1048: WHEN OTHERS THEN
1049: invalid_value(p_org_id, 'ORG_ID');
1050: END get_mp_row_from_org;
1051:
1052: FUNCTION get_rp_row_from_org( p_org_id IN rcv_parameters.organization_id%TYPE )
1053: RETURN rcv_parameters%ROWTYPE IS
1054: BEGIN
1055: IF ( p_org_id IS NULL ) THEN
1056: RETURN NULL;

Line 1053: RETURN rcv_parameters%ROWTYPE IS

1049: invalid_value(p_org_id, 'ORG_ID');
1050: END get_mp_row_from_org;
1051:
1052: FUNCTION get_rp_row_from_org( p_org_id IN rcv_parameters.organization_id%TYPE )
1053: RETURN rcv_parameters%ROWTYPE IS
1054: BEGIN
1055: IF ( p_org_id IS NULL ) THEN
1056: RETURN NULL;
1057: END IF;

Line 1065: FROM rcv_parameters

1061: END IF;
1062:
1063: SELECT *
1064: INTO g_rp_row
1065: FROM rcv_parameters
1066: WHERE organization_id = p_org_id
1067: AND rownum = 1;
1068:
1069: RETURN g_rp_row;

Line 1220: FROM rcv_parameters

1216: BEGIN
1217: IF ( nvl(g_rp_org_id,-99) <> p_organization_id) THEN
1218: SELECT nvl(pre_receive,'N')
1219: INTO g_pre_rcv_flag
1220: FROM rcv_parameters
1221: WHERE organization_id = p_organization_id;
1222:
1223: g_rp_org_id := p_organization_id;
1224: END IF;