PACKAGE: APPS.WIP_SF_CUSTOM_API

Source

1 PACKAGE wip_sf_custom_api AUTHID CURRENT_USER AS
2 /* $Header: wipsfcas.pls 115.8 2002/12/12 15:59:07 rmahidha ship $ */
3 
4 /* ***************************************************************
5 
6    schedule_custom_api
7 
8    INPUT PARAMETERS (and the db columns they correspond to)
9    scheduleNumber : wip_flow_schedules.schedule_number
10    orgCode : org_organization_definitions.organization_code
11    lineCode : wip_lines.line_code
12    opSeqID : bom_operation_sequences.operation_sequence_id
13    salesOrderNumber : mtl_sales_orders_kfv.concatenated_segments
14    assemblyName : mtl_system_items_kfv.concatenated_segments
15    scheduleGroup : wip_schedule_groups.schedule_group_name
16    buildSequence : wip_flow_schedules.build_sequence
17    completionDate : wip_flow_schedules.scheduled_completion_date
18    projectName : pjm_projects_v.project_name
19    taskName : pjm_tasks_v.task_name
20 
21    note that a set of orgCode, lineCode, scheduleNumber, and
22    opSeqID uniquely identifies a schedule node.  These input
23    parameters are guaranteed to have non-null values.
24    Some of the other input parameters may be null.
25 
26 *************************************************************** */
27 
28 PROCEDURE schedule_custom_api (
29 	scheduleNumber IN VARCHAR2,
30 	orgCode IN VARCHAR2,
31 	lineCode IN VARCHAR2,
32 	opSeqID IN NUMBER,
33 	salesOrderNumber IN VARCHAR2,
34 	assemblyName IN VARCHAR2,
35 	scheduleGroup IN VARCHAR2,
36 	buildSequence IN NUMBER,
37 	completionDate IN DATE,
38 	projectName IN VARCHAR2,
39 	taskName IN VARCHAR2,
40 	x_num_attr OUT NOCOPY NUMBER,
41 	x_labels OUT NOCOPY system.wip_attr_labels,
42 	x_values OUT NOCOPY system.wip_attr_values,
43 	x_colors OUT NOCOPY system.wip_attr_colors);
44 
45 /* ***************************************************************
46 
47    event_custom_api
48 
49    INPUT PARAMETERS
50    scheduleNumber : wip_flow_schedules.schedule_number
51    orgCode : org_organization_definitions.organization_code
52    lineCode : wip_lines.line_code
53    lineopSeqID : bom_operation_sequences.operation_sequence_id
54    opSeqNum : bom_operation_sequences.operation_seq_num
55    opCode : bom_standard_operations.operation_code
56    deptCode : bom_departments.department_code
57 
58    note that a set of orgCode, lineCode, scheduleNumber,
59    lineopSeqID, and opSeqNum uniquely identifies a schedule node.
60 
61 *************************************************************** */
62 
63 PROCEDURE event_custom_api (
64 	scheduleNumber IN VARCHAR2,
65 	orgCode IN VARCHAR2,
66 	lineCode IN VARCHAR2,
67 	lineopSeqID IN NUMBER,    -- equals schedule's opSeqID
68 	opSeqNum IN NUMBER,
69 	opCode IN VARCHAR2,
70 	deptCode IN VARCHAR2,
71 	x_num_attr OUT NOCOPY NUMBER,
72 	x_labels OUT NOCOPY system.wip_attr_labels,
73 	x_values OUT NOCOPY system.wip_attr_values,
74 	x_colors OUT NOCOPY system.wip_attr_colors);
75 
76 END wip_sf_custom_api;