DBA Data[Home] [Help]

APPS.GMD_RECIPE_DESIGNER_PKG dependencies on GMD_RECIPE_CUSTOMERS

Line 2352: gmd_recipe_customers

2348:
2349: --- This statement should be replaced by an API when it is available ...
2350:
2351: DELETE
2352: gmd_recipe_customers
2353: WHERE
2354: recipe_id = p_recipe_id AND
2355: customer_id = p_customer_id AND
2356: last_update_date = p_last_update_date;

Line 3250: FROM gmd_recipe_customers

3246: WHERE recipe_id = p_copy_from_recipe_id;
3247:
3248: CURSOR Cur_get_rcp_cust IS
3249: SELECT *
3250: FROM gmd_recipe_customers
3251: WHERE recipe_id = p_copy_from_recipe_id;
3252:
3253: CURSOR Cur_get_rcp_loss IS
3254: SELECT *

Line 4625: DELETE gmd_recipe_customers WHERE recipe_id = p_copy_from_recipe_id;

4621: ---
4622: l_txt_ind := 1;
4623:
4624: IF NOT l_copy_recipe THEN
4625: DELETE gmd_recipe_customers WHERE recipe_id = p_copy_from_recipe_id;
4626: END IF;
4627:
4628: FOR i IN 1..l_rcp_cust_tbl.count LOOP
4629:

Line 4641: l_table_lnk := 'gmd_recipe_customers' || '|' ||

4637: l_text_code := l_rcp_cust_tbl(i).text_code;
4638: DELETE fm_text_tbl WHERE text_code = l_text_code;
4639: END IF;
4640:
4641: l_table_lnk := 'gmd_recipe_customers' || '|' ||
4642: x_recipe_id ||
4643: '|' || l_rcp_cust_tbl(i).customer_id;
4644:
4645: WHILE (l_txt_ind <= l_rcp_cust_text_tbl.COUNT AND