66: --| IN : |
67: --| p_api_version IN NUMBER |
68: --| p_init_msg_list IN VARCHAR2 |
69: --| p_header_rec IN OUT NOCOPY |
70: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
71: --| p_dtl_Tbl IN OUT NOCOPY |
72: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
73: --| |
74: --| OUT : |
68: --| p_init_msg_list IN VARCHAR2 |
69: --| p_header_rec IN OUT NOCOPY |
70: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
71: --| p_dtl_Tbl IN OUT NOCOPY |
72: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
73: --| |
74: --| OUT : |
75: --| x_return_status OUT NOCOPY VARCHAR2 |
76: --| x_msg_count OUT NOCOPY VARCHAR2 |
100: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
101: , x_return_status OUT NOCOPY VARCHAR2
102: , x_msg_count OUT NOCOPY NUMBER
103: , x_msg_data OUT NOCOPY VARCHAR2
104: , p_header_rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
105: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
106: , p_user_id IN NUMBER
107: )
108: IS
101: , x_return_status OUT NOCOPY VARCHAR2
102: , x_msg_count OUT NOCOPY NUMBER
103: , x_msg_data OUT NOCOPY VARCHAR2
104: , p_header_rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
105: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
106: , p_user_id IN NUMBER
107: )
108: IS
109: l_api_name CONSTANT VARCHAR2(30) := 'Create_LotCost_Adjustment' ;
408: --| IN : |
409: --| p_api_version IN NUMBER |
410: --| p_init_msg_list IN VARCHAR2 |
411: --| p_header_rec IN OUT NOCOPY |
412: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
413: --| p_dtl_Tbl IN OUT NOCOPY |
414: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
415: --| |
416: --| OUT : |
410: --| p_init_msg_list IN VARCHAR2 |
411: --| p_header_rec IN OUT NOCOPY |
412: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
413: --| p_dtl_Tbl IN OUT NOCOPY |
414: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
415: --| |
416: --| OUT : |
417: --| x_return_status OUT NOCOPY VARCHAR2 |
418: --| x_msg_count OUT NOCOPY VARCHAR2 |
438: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
439: , x_return_status OUT NOCOPY VARCHAR2
440: , x_msg_count OUT NOCOPY NUMBER
441: , x_msg_data OUT NOCOPY VARCHAR2
442: , p_header_rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
443: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
444: , p_user_id IN NUMBER
445: )
446: IS
439: , x_return_status OUT NOCOPY VARCHAR2
440: , x_msg_count OUT NOCOPY NUMBER
441: , x_msg_data OUT NOCOPY VARCHAR2
442: , p_header_rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
443: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
444: , p_user_id IN NUMBER
445: )
446: IS
447: l_api_name CONSTANT VARCHAR2(30) := 'Update_LotCost_Adjustment' ;
562: --| IN : |
563: --| p_api_version IN NUMBER |
564: --| p_init_msg_list IN VARCHAR2 |
565: --| p_header_rec IN OUT NOCOPY |
566: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
567: --| p_dtl_Tbl IN OUT NOCOPY |
568: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
569: --| |
570: --| OUT : |
564: --| p_init_msg_list IN VARCHAR2 |
565: --| p_header_rec IN OUT NOCOPY |
566: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
567: --| p_dtl_Tbl IN OUT NOCOPY |
568: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
569: --| |
570: --| OUT : |
571: --| x_return_status OUT NOCOPY VARCHAR2 |
572: --| x_msg_count OUT NOCOPY VARCHAR2 |
591: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
592: , x_return_status OUT NOCOPY VARCHAR2
593: , x_msg_count OUT NOCOPY NUMBER
594: , x_msg_data OUT NOCOPY VARCHAR2
595: , p_header_rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
596: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
597: )
598: IS
599: l_api_name CONSTANT VARCHAR2(30) := 'Delete_LotCost_Adjustment' ;
592: , x_return_status OUT NOCOPY VARCHAR2
593: , x_msg_count OUT NOCOPY NUMBER
594: , x_msg_data OUT NOCOPY VARCHAR2
595: , p_header_rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
596: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
597: )
598: IS
599: l_api_name CONSTANT VARCHAR2(30) := 'Delete_LotCost_Adjustment' ;
600: l_api_version CONSTANT NUMBER := 2.0 ;
772: --| IN : |
773: --| p_api_version IN NUMBER |
774: --| p_init_msg_list IN VARCHAR2 |
775: --| p_header_rec IN OUT NOCOPY |
776: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
777: --| p_dtl_Tbl IN OUT NOCOPY |
778: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
779: --| |
780: --| OUT : |
774: --| p_init_msg_list IN VARCHAR2 |
775: --| p_header_rec IN OUT NOCOPY |
776: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
777: --| p_dtl_Tbl IN OUT NOCOPY |
778: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
779: --| |
780: --| OUT : |
781: --| x_return_status OUT NOCOPY VARCHAR2 |
782: --| x_msg_count OUT NOCOPY VARCHAR2 |
801: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
802: , x_return_status OUT NOCOPY VARCHAR2
803: , x_msg_count OUT NOCOPY NUMBER
804: , x_msg_data OUT NOCOPY VARCHAR2
805: , p_header_rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
806: , p_dtl_Tbl OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
807: )
808: IS
809: CURSOR Adjustment_Header_csr
802: , x_return_status OUT NOCOPY VARCHAR2
803: , x_msg_count OUT NOCOPY NUMBER
804: , x_msg_data OUT NOCOPY VARCHAR2
805: , p_header_rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
806: , p_dtl_Tbl OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
807: )
808: IS
809: CURSOR Adjustment_Header_csr
810: IS