[Home] [Help]
7: /* */
8: /* DESCRIPTION: */
9: /* */
10: /* API returns (x_return_code) = 'S' if the insert into resources */
11: /* header (cr_rsrc_mst ) table is successfully. */
12: /* */
13: /* History : */
14: /* Sridhar 09-SEP-2002 Initial implementation */
15: /* =================================================================== */
56:
57: /* B4724360 Rajesh Patangya INVCONV */
58: CURSOR Cur_uom IS
59: SELECT STD_USAGE_UOM,CAPACITY_UM,MIN_CAPACITY,MAX_CAPACITY
60: FROM cr_rsrc_mst
61: WHERE resources = l_resources_rec.resources
62: AND delete_mark = 0;
63:
64: BEGIN
326: /* */
327: /* DESCRIPTION: */
328: /* */
329: /* The following Procedure checks the Record and then Inserts */
330: /* the row into cr_rsrc_mst table and Returns S code if inserted */
331: /* Successfully */
332: /* */
333: /* History : */
334: /* Sgidugu 09/10/2002 Initial implementation */
371: and process_enabled_flag = 'Y';
372:
373: CURSOR Cur_resources IS
374: SELECT COUNT(1)
375: FROM cr_rsrc_mst
376: where resources = p_resources
377: and delete_mark = 0;
378:
379: /* B4724360 Rajesh Patangya changed the where clause include org+id and resource_id*/
1164: /* */
1165: /* DESCRIPTION: */
1166: /* */
1167: /* The following Procedure checks the Record and then Inserts */
1168: /* the row into cr_rsrc_mst table and Returns S code if inserted */
1169: /* Successfully */
1170: /* */
1171: /* History : */
1172: /* Sgidugu 09/10/2002 Initial implementation */
1697: /* */
1698: /* DESCRIPTION: */
1699: /* */
1700: /* The following Procedure checks the Record and then Inserts */
1701: /* the row into cr_rsrc_mst table and Returns S code if inserted */
1702: /* Successfully */
1703: /* */
1704: /* History : */
1705: /* Sgidugu 09/10/2002 Initial implementation */