123: g_over_allocation VARCHAR2(1);
124:
125: PROCEDURE apply
126: (p_api_version IN NUMBER ,
127: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
128: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
129: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
130: x_return_status OUT NOCOPY VARCHAR2 ,
131: x_msg_count OUT NOCOPY NUMBER ,
124:
125: PROCEDURE apply
126: (p_api_version IN NUMBER ,
127: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
128: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
129: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
130: x_return_status OUT NOCOPY VARCHAR2 ,
131: x_msg_count OUT NOCOPY NUMBER ,
132: x_msg_data OUT NOCOPY VARCHAR2 ,
125: PROCEDURE apply
126: (p_api_version IN NUMBER ,
127: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
128: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
129: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
130: x_return_status OUT NOCOPY VARCHAR2 ,
131: x_msg_count OUT NOCOPY NUMBER ,
132: x_msg_data OUT NOCOPY VARCHAR2 ,
133: p_rule_id IN NUMBER DEFAULT NULL ,
251: -- Notes : calls API's of WMS_RE_Common_PVT
252: --
253: PROCEDURE CheckSyntax
254: (p_api_version IN NUMBER ,
255: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
256: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
257: x_return_status OUT NOCOPY VARCHAR2 ,
258: x_msg_count OUT NOCOPY NUMBER ,
259: x_msg_data OUT NOCOPY VARCHAR2 ,
252: --
253: PROCEDURE CheckSyntax
254: (p_api_version IN NUMBER ,
255: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
256: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
257: x_return_status OUT NOCOPY VARCHAR2 ,
258: x_msg_count OUT NOCOPY NUMBER ,
259: x_msg_data OUT NOCOPY VARCHAR2 ,
260: p_rule_id IN NUMBER DEFAULT NULL
311: -- Notes : calls API's of WMS_RE_Common_PVT
312: --
313: PROCEDURE find_rule
314: ( p_api_version IN NUMBER
315: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
316: ,x_return_status OUT NOCOPY VARCHAR2
317: ,x_msg_count OUT NOCOPY NUMBER
318: ,x_msg_data OUT NOCOPY VARCHAR2
319: ,p_rule_id IN NUMBER
339:
340:
341: PROCEDURE GenerateRulePackage
342: (p_api_version IN NUMBER ,
343: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
344: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
345: x_return_status OUT NOCOPY VARCHAR2 ,
346: x_msg_count OUT NOCOPY NUMBER ,
347: x_msg_data OUT NOCOPY VARCHAR2 ,
340:
341: PROCEDURE GenerateRulePackage
342: (p_api_version IN NUMBER ,
343: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
344: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
345: x_return_status OUT NOCOPY VARCHAR2 ,
346: x_msg_count OUT NOCOPY NUMBER ,
347: x_msg_data OUT NOCOPY VARCHAR2 ,
348: p_rule_id IN NUMBER DEFAULT NULL
363: --
364:
365: PROCEDURE assignTTs
366: (p_api_version IN NUMBER ,
367: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
368: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
369: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_msg_count OUT NOCOPY NUMBER ,
364:
365: PROCEDURE assignTTs
366: (p_api_version IN NUMBER ,
367: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
368: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
369: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_msg_count OUT NOCOPY NUMBER ,
372: x_msg_data OUT NOCOPY VARCHAR2 ,
365: PROCEDURE assignTTs
366: (p_api_version IN NUMBER ,
367: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
368: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
369: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_msg_count OUT NOCOPY NUMBER ,
372: x_msg_data OUT NOCOPY VARCHAR2 ,
373: p_move_order_header_id IN NUMBER);
388: --
389:
390: PROCEDURE AssignTT(
391: p_api_version IN NUMBER ,
392: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
393: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
394: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
395: x_return_status OUT NOCOPY VARCHAR2,
396: x_msg_count OUT NOCOPY NUMBER ,
389:
390: PROCEDURE AssignTT(
391: p_api_version IN NUMBER ,
392: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
393: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
394: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
395: x_return_status OUT NOCOPY VARCHAR2,
396: x_msg_count OUT NOCOPY NUMBER ,
397: x_msg_data OUT NOCOPY VARCHAR2 ,
390: PROCEDURE AssignTT(
391: p_api_version IN NUMBER ,
392: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
393: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
394: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
395: x_return_status OUT NOCOPY VARCHAR2,
396: x_msg_count OUT NOCOPY NUMBER ,
397: x_msg_data OUT NOCOPY VARCHAR2 ,
398: p_task_id IN NUMBER DEFAULT NULL );
452:
453:
454: PROCEDURE ApplyLabel(
455: p_api_version IN NUMBER,
456: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
457: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
458: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
459: p_label_request_id IN NUMBER,
460: x_return_status OUT NOCOPY VARCHAR2,
453:
454: PROCEDURE ApplyLabel(
455: p_api_version IN NUMBER,
456: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
457: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
458: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
459: p_label_request_id IN NUMBER,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_msg_count OUT NOCOPY NUMBER,
454: PROCEDURE ApplyLabel(
455: p_api_version IN NUMBER,
456: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
457: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
458: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
459: p_label_request_id IN NUMBER,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_msg_count OUT NOCOPY NUMBER,
462: x_msg_data OUT NOCOPY VARCHAR2,
526: --
527:
528: PROCEDURE assign_operation_plans
529: (p_api_version IN NUMBER ,
530: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
531: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
532: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
533: x_return_status OUT NOCOPY VARCHAR2,
534: x_msg_count OUT NOCOPY NUMBER ,
527:
528: PROCEDURE assign_operation_plans
529: (p_api_version IN NUMBER ,
530: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
531: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
532: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
533: x_return_status OUT NOCOPY VARCHAR2,
534: x_msg_count OUT NOCOPY NUMBER ,
535: x_msg_data OUT NOCOPY VARCHAR2 ,
528: PROCEDURE assign_operation_plans
529: (p_api_version IN NUMBER ,
530: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
531: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
532: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
533: x_return_status OUT NOCOPY VARCHAR2,
534: x_msg_count OUT NOCOPY NUMBER ,
535: x_msg_data OUT NOCOPY VARCHAR2 ,
536: p_move_order_header_id IN NUMBER);
551: --
552:
553: PROCEDURE Assign_operation_plan(
554: p_api_version IN NUMBER ,
555: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
556: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
557: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER ,
552:
553: PROCEDURE Assign_operation_plan(
554: p_api_version IN NUMBER ,
555: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
556: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
557: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER ,
560: x_msg_data OUT NOCOPY VARCHAR2 ,
553: PROCEDURE Assign_operation_plan(
554: p_api_version IN NUMBER ,
555: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
556: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
557: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER ,
560: x_msg_data OUT NOCOPY VARCHAR2 ,
561: p_task_id IN NUMBER);
588: -- Notes : calls APPLY() API's of WMS_STRATEGY_PVT
589:
590: PROCEDURE QuickPick
591: (p_api_version IN NUMBER ,
592: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
593: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
594: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
595: x_return_status OUT NOCOPY VARCHAR2 ,
596: x_msg_count OUT NOCOPY NUMBER ,
589:
590: PROCEDURE QuickPick
591: (p_api_version IN NUMBER ,
592: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
593: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
594: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
595: x_return_status OUT NOCOPY VARCHAR2 ,
596: x_msg_count OUT NOCOPY NUMBER ,
597: x_msg_data OUT NOCOPY VARCHAR2 ,
590: PROCEDURE QuickPick
591: (p_api_version IN NUMBER ,
592: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
593: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
594: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
595: x_return_status OUT NOCOPY VARCHAR2 ,
596: x_msg_count OUT NOCOPY NUMBER ,
597: x_msg_data OUT NOCOPY VARCHAR2 ,
598: p_type_code IN NUMBER DEFAULT NULL ,