DBA Data[Home] [Help]

APPS.GMD_RECIPE_DESIGNER_PKG dependencies on GMD_RECIPE_DETAIL

Line 2245: l_cust_tbl GMD_RECIPE_DETAIL.recipe_detail_tbl;

2241: x_return_code OUT NOCOPY VARCHAR2,
2242: x_error_msg OUT NOCOPY VARCHAR2) IS
2243:
2244:
2245: l_cust_tbl GMD_RECIPE_DETAIL.recipe_detail_tbl;
2246: l_status VARCHAR2(30);
2247: l_msg_cnt NUMBER;
2248: l_msg_dat VARCHAR2(30);
2249: l_message VARCHAR2(1000);

Line 2277: GMD_RECIPE_DETAIL.Create_Recipe_Customers(p_api_version => 1.0,

2273: l_cust_tbl(1).last_updated_by := l_user_id;
2274: l_cust_tbl(1).last_update_login := l_login_id;
2275: l_cust_tbl(1).last_update_date := p_last_update_date;
2276:
2277: GMD_RECIPE_DETAIL.Create_Recipe_Customers(p_api_version => 1.0,
2278: p_init_msg_list => 'T',
2279: p_commit => 'F',
2280: p_called_from_forms => 'NO',
2281: x_return_status => l_status,

Line 2415: l_loss_tbl GMD_RECIPE_DETAIL.recipe_dtl;

2411: CURSOR Cur_loss_id IS
2412: SELECT gmd_recipe_process_loss_id_s.NEXTVAL
2413: FROM SYS.DUAL;
2414:
2415: l_loss_tbl GMD_RECIPE_DETAIL.recipe_dtl;
2416: l_status VARCHAR2(30);
2417: l_msg_cnt NUMBER;
2418: l_msg_dat VARCHAR2(30);
2419: l_message VARCHAR2(1000);

Line 2456: GMD_RECIPE_DETAIL_PVT.Create_Recipe_Process_Loss(

2452: l_loss_tbl.last_updated_by := l_user_id;
2453: l_loss_tbl.last_update_login := l_login_id;
2454: l_loss_tbl.last_update_date := p_last_update_date;
2455:
2456: GMD_RECIPE_DETAIL_PVT.Create_Recipe_Process_Loss(
2457: p_recipe_detail_rec => l_loss_tbl,
2458: x_return_status => l_status);
2459:
2460:

Line 2641: l_loss_tbl GMD_RECIPE_DETAIL.recipe_dtl;

2637: WHERE
2638: recipe_process_loss_id = p_recipe_loss_id AND
2639: last_update_date = p_last_update_date_orig;
2640:
2641: l_loss_tbl GMD_RECIPE_DETAIL.recipe_dtl;
2642: l_status VARCHAR2(30);
2643: l_msg_cnt NUMBER;
2644: l_msg_dat VARCHAR2(30);
2645: l_message VARCHAR2(1000);

Line 2683: GMD_RECIPE_DETAIL_PVT.Update_Recipe_Process_Loss(

2679: l_loss_tbl.last_updated_by := l_user_id;
2680: l_loss_tbl.last_update_login := l_login_id;
2681: l_loss_tbl.last_update_date := p_last_update_date;
2682:
2683: GMD_RECIPE_DETAIL_PVT.Update_Recipe_Process_Loss(
2684: p_recipe_detail_rec => l_loss_tbl,
2685: x_return_status => l_status);
2686:
2687: