DBA Data[Home] [Help]

APPS.GMDRTVAL_PUB dependencies on GMDRTVAL_PUB

Line 1: PACKAGE BODY GMDRTVAL_PUB AS

1: PACKAGE BODY GMDRTVAL_PUB AS
2: /* $Header: GMDPRTVB.pls 120.9 2011/07/25 09:36:33 rborpatl ship $ */
3:
4: --Bug 3222090, NSRIVAST 20-FEB-2004, BEGIN
5: --Forward declaration.

Line 31: /* l_ret := gmdrtval_pub.get_theoretical_process_loss(prouting_class, pquantity); */

27: /* REQUIREMENTS */
28: /* routing_class should be a non null value. */
29: /* */
30: /* SYNOPSIS: */
31: /* l_ret := gmdrtval_pub.get_theoretical_process_loss(prouting_class, pquantity); */
32: /* */
33: /* RETURNS: */
34: /* Theoretical Process loss value. */
35: /* ==================================================================== */

Line 73: /* l_ret := gmdrtval_pub.check_duplicate_routing(prouting_no, prouting_vers, */

69: /* REQUIREMENTS */
70: /* routing_no and routing_vers should be non null values. */
71: /* */
72: /* SYNOPSIS: */
73: /* l_ret := gmdrtval_pub.check_duplicate_routing(prouting_no, prouting_vers, */
74: /* pcalledby_form); */
75: /* */
76: /* RETURNS: */
77: /* 0 Success */

Line 130: /* l_ret := gmdrtval_pub.check_routing_class(prouting_class, pcalledby_form); */

126: /* REQUIREMENTS */
127: /* routing_class should be non null value. */
128: /* */
129: /* SYNOPSIS: */
130: /* l_ret := gmdrtval_pub.check_routing_class(prouting_class, pcalledby_form); */
131: /* */
132: /* RETURNS: */
133: /* 0 Success */
134: /* -1 Some required fields for the procedure are missing. */

Line 183: /* l_ret := gmdrtval_pub.check_routingstep_no(proutingstep_no, */

179: /* REQUIREMENTS */
180: /* routing_id and routingstep_no should be non null values. */
181: /* */
182: /* SYNOPSIS: */
183: /* l_ret := gmdrtval_pub.check_routingstep_no(proutingstep_no, */
184: /* prouting_id, */
185: /* pcalledby_form); */
186: /* */
187: /* RETURNS: */

Line 228: /* Procedure Check_Routing in GMDRTVAL_PUB package */

224: END check_routingstep_no;
225:
226:
227: /*- =========================================================== */
228: /* Procedure Check_Routing in GMDRTVAL_PUB package */
229: /* */
230: /* Decription */
231: /* Check if the routing header exists in the database. */
232: /* If all 3 parameters are sent in, validates no/vers rather than id */

Line 297: /* l_ret := gmdrtval_pub.check_oprn(poprn_no, poprn_vers, */

293: /* REQUIREMENTS */
294: /* oprn_no and oprn_vers should be non null values. */
295: /* */
296: /* SYNOPSIS: */
297: /* l_ret := gmdrtval_pub.check_oprn(poprn_no, poprn_vers, */
298: /* pcalledby_form); */
299: /* */
300: /* RETURNS: */
301: /* 0 Success */

Line 387: /* l_ret := gmdrtval_pub.circular_dependencies_exist(prouting_id, */

383: /* REQUIREMENTS */
384: /* parent_key routing_id or batch_id should be non null values. */
385: /* called_from_batch could be null if checking at the routing level. */
386: /* SYNOPSIS: */
387: /* l_ret := gmdrtval_pub.circular_dependencies_exist(prouting_id, */
388: /* 0); */
389: /* */
390: /* RETURNS: */
391: /* TRUE Dependencies Exist */

Line 467: /* gmdrtval_pub.generate_step_dependencies(prouting_id); */

463: /* */
464: /* REQUIREMENTS */
465: /* prouting_id non null value. */
466: /* SYNOPSIS: */
467: /* gmdrtval_pub.generate_step_dependencies(prouting_id); */
468: /* */
469: /* */
470: /*===================================================================== */
471:

Line 585: /* gmdrtval_pub.generate_step_dependencies(prouting_id, pDep_type, x_return_status); */

581: /* REQUIREMENTS */
582: /* prouting_id non null value. */
583: /* pDep_type non null value */
584: /* SYNOPSIS: */
585: /* gmdrtval_pub.generate_step_dependencies(prouting_id, pDep_type, x_return_status); */
586: /* */
587: /* */
588: /*===================================================================== */
589:

Line 1004: /* l_ret := gmdrtval_pub.check_delete_mark(pdelete_mark, pcalledby_form); */

1000: /* REQUIREMENTS */
1001: /* delete_mark should be non null value. */
1002: /* */
1003: /* SYNOPSIS: */
1004: /* l_ret := gmdrtval_pub.check_delete_mark(pdelete_mark, pcalledby_form); */
1005: /* ==================================================================== */
1006:
1007: PROCEDURE check_delete_mark(pdelete_mark IN NUMBER,
1008: x_return_status OUT NOCOPY VARCHAR2) IS

Line 1034: /* l_ret := gmdrtval_pub.check_ownerorgn_code(pownerorgn_code, pcalledby_form); */

1030: /* REQUIREMENTS */
1031: /* validate ownerorgn_code. */
1032: /* */
1033: /* SYNOPSIS: */
1034: /* l_ret := gmdrtval_pub.check_ownerorgn_code(pownerorgn_code, pcalledby_form); */
1035: /* ==================================================================== */
1036:
1037: PROCEDURE check_ownerorgn_code(powner_id IN NUMBER,powner_orgn IN VARCHAR2,
1038: x_return_status OUT NOCOPY VARCHAR2) IS

Line 1082: /* l_ret := gmdrtval_pub.check_deprouting(pownerorgn_code,proutingStep_no,pdeproutingStep_no); */

1078: /* REQUIREMENTS */
1079: /* validate dep_routingsteps. */
1080: /* */
1081: /* SYNOPSIS: */
1082: /* l_ret := gmdrtval_pub.check_deprouting(pownerorgn_code,proutingStep_no,pdeproutingStep_no); */
1083: /* ==================================================================== */
1084:
1085: PROCEDURE check_deprouting (prouting_id IN gmd_routings.routing_id%TYPE
1086: ,proutingStep_no IN fm_rout_dtl.routingStep_no%TYPE

Line 1133: /* l_ret := gmdrtval_pub.get_theoretical_process_loss(prouting_class ); */

1129: /* REQUIREMENTS */
1130: /* routing_class should be a non null value. */
1131: /* */
1132: /* SYNOPSIS: */
1133: /* l_ret := gmdrtval_pub.get_theoretical_process_loss(prouting_class ); */
1134: /* */
1135: /* RETURNS: */
1136: /* Fixed Process loss value. */
1137: /* ==================================================================== */

Line 1162: END GMDRTVAL_PUB;

1158: RETURN l_process_loss;
1159: END get_fixed_process_loss;
1160:
1161:
1162: END GMDRTVAL_PUB;