14: Procedure rollback_row;
15:
16: FUNCTION Query_Row
17: ( p_pull_sequence_id IN NUMBER
18: ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
19:
20: FUNCTION Convert_Miss_To_Null
21: ( p_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
22: ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
17: ( p_pull_sequence_id IN NUMBER
18: ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
19:
20: FUNCTION Convert_Miss_To_Null
21: ( p_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
22: ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
23:
24: FUNCTION Complete_Record
25: ( p_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
18: ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
19:
20: FUNCTION Convert_Miss_To_Null
21: ( p_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
22: ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
23:
24: FUNCTION Complete_Record
25: ( p_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
26: , p_old_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
21: ( p_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
22: ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
23:
24: FUNCTION Complete_Record
25: ( p_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
26: , p_old_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
27: ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
28:
29: PROCEDURE Insert_Row(p_pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type);
22: ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
23:
24: FUNCTION Complete_Record
25: ( p_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
26: , p_old_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
27: ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
28:
29: PROCEDURE Insert_Row(p_pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type);
30: /*
23:
24: FUNCTION Complete_Record
25: ( p_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
26: , p_old_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
27: ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
28:
29: PROCEDURE Insert_Row(p_pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type);
30: /*
31: PROCEDURE Insert_Row( x_return_status OUT NOCOPY VARCHAR2,
25: ( p_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
26: , p_old_pull_sequence_rec IN INV_Kanban_PVT.Pull_Sequence_Rec_Type
27: ) RETURN INV_Kanban_PVT.Pull_Sequence_Rec_Type;
28:
29: PROCEDURE Insert_Row(p_pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type);
30: /*
31: PROCEDURE Insert_Row( x_return_status OUT NOCOPY VARCHAR2,
32: p_pull_sequence_id IN OUT NOCOPY NUMBER,
33: p_Inventory_item_id NUMBER,
144: p_auto_request VARCHAR2 DEFAULT NULL,
145: p_Auto_Allocate_Flag NUMBER DEFAULT NULL); --Added P_Auto_Allocate_Flag for 3905884.
146:
147:
148: PROCEDURE Update_Row(p_pull_sequence_rec INV_Kanban_PVT.Pull_sequence_Rec_Type);
149: /*
150: PROCEDURE Update_Row( x_return_status OUT NOCOPY VARCHAR2,
151: p_Pull_sequence_Id NUMBER,
152: p_Inventory_item_id NUMBER,