[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
325: /* */
326: /* DESCRIPTION: */
327: /* */
328: /* The following Procedure checks the Record and then Inserts */
329: /* the row into cr_rsrc_mst table and Returns S code if inserted */
330: /* Successfully */
331: /* */
332: /* History : */
333: /* Sgidugu 09/10/2002 Initial implementation */
370: and process_enabled_flag = 'Y';
371:
372: CURSOR Cur_resources IS
373: SELECT COUNT(1)
374: FROM cr_rsrc_mst
375: where resources = p_resources
376: and delete_mark = 0;
377:
378: /* B4724360 Rajesh Patangya changed the where clause include org+id and resource_id*/
1141: /* */
1142: /* DESCRIPTION: */
1143: /* */
1144: /* The following Procedure checks the Record and then Inserts */
1145: /* the row into cr_rsrc_mst table and Returns S code if inserted */
1146: /* Successfully */
1147: /* */
1148: /* History : */
1149: /* Sgidugu 09/10/2002 Initial implementation */
1670: /* */
1671: /* DESCRIPTION: */
1672: /* */
1673: /* The following Procedure checks the Record and then Inserts */
1674: /* the row into cr_rsrc_mst table and Returns S code if inserted */
1675: /* Successfully */
1676: /* */
1677: /* History : */
1678: /* Sgidugu 09/10/2002 Initial implementation */