DBA Data[Home] [Help]

APPS.GMF_LOTCOSTADJUSTMENT_PUB dependencies on GMF_LOTCOSTADJUSTMENT_PUB

Line 1: PACKAGE BODY GMF_LOTCOSTADJUSTMENT_PUB AS

1: PACKAGE BODY GMF_LOTCOSTADJUSTMENT_PUB AS
2: /* $Header: GMFPLCAB.pls 120.8.12000000.2 2007/03/15 10:16:03 pmarada ship $ */
3:
4: --+==========================================================================+
5: --| Copyright (c) 1998 Oracle Corporation |

Line 10: --| Package Name : GMF_LotCostAdjustment_PUB |

6: --| Redwood Shores, CA, USA |
7: --| All rights reserved. |
8: --+==========================================================================+
9: --| File Name : GMFPLCAB.pls |
10: --| Package Name : GMF_LotCostAdjustment_PUB |
11: --| API name : GMF_LotCostAdjustment_PUB |
12: --| Type : Public |
13: --| Pre-reqs : N/A |
14: --| Function : Lot Cost Adjustment Creation, Updation, Query and |

Line 11: --| API name : GMF_LotCostAdjustment_PUB |

7: --| All rights reserved. |
8: --+==========================================================================+
9: --| File Name : GMFPLCAB.pls |
10: --| Package Name : GMF_LotCostAdjustment_PUB |
11: --| API name : GMF_LotCostAdjustment_PUB |
12: --| Type : Public |
13: --| Pre-reqs : N/A |
14: --| Function : Lot Cost Adjustment Creation, Updation, Query and |
15: --| Deletion |

Line 41: p_header_rec GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type

37:
38: --Procedure to add header record into error stack
39: PROCEDURE add_header_to_error_stack
40: (
41: p_header_rec GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
42: );
43:
44: --Procedure to validate parameters
45: PROCEDURE Validate_Input_Params

Line 47: p_header_Rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type

43:
44: --Procedure to validate parameters
45: PROCEDURE Validate_Input_Params
46: (
47: p_header_Rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
48: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
49: , p_operation IN VARCHAR2
50: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
51: , x_return_status OUT NOCOPY VARCHAR2

Line 48: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type

44: --Procedure to validate parameters
45: PROCEDURE Validate_Input_Params
46: (
47: p_header_Rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
48: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
49: , p_operation IN VARCHAR2
50: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
51: , x_return_status OUT NOCOPY VARCHAR2
52: );

Line 55: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_LotCostAdjustment_PUB ';

51: , x_return_status OUT NOCOPY VARCHAR2
52: );
53:
54: --Global Variables
55: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_LotCostAdjustment_PUB ';
56:
57: --
58: -- Bug 3655773: Added following variable to initialize G_Msg_Level_Threshold global
59: -- variable from the profile 'FND: Message Level Threshold'. Otherwise next assignment

Line 85: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |

81: --| IN : |
82: --| p_api_version IN NUMBER |
83: --| p_init_msg_list IN VARCHAR2 |
84: --| p_header_rec IN OUT NOCOPY |
85: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
86: --| p_dtl_Tbl IN OUT NOCOPY |
87: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
88: --| |
89: --| OUT : |

Line 87: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |

83: --| p_init_msg_list IN VARCHAR2 |
84: --| p_header_rec IN OUT NOCOPY |
85: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
86: --| p_dtl_Tbl IN OUT NOCOPY |
87: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
88: --| |
89: --| OUT : |
90: --| x_return_status OUT NOCOPY VARCHAR2 |
91: --| x_msg_count OUT NOCOPY NUMBER |

Line 304: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |

300: --| IN : |
301: --| p_api_version IN NUMBER |
302: --| p_init_msg_list IN VARCHAR2 |
303: --| p_header_rec IN OUT NOCOPY |
304: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
305: --| p_dtl_Tbl IN OUT NOCOPY |
306: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
307: --| |
308: --| OUT : |

Line 306: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |

302: --| p_init_msg_list IN VARCHAR2 |
303: --| p_header_rec IN OUT NOCOPY |
304: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
305: --| p_dtl_Tbl IN OUT NOCOPY |
306: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
307: --| |
308: --| OUT : |
309: --| x_return_status OUT NOCOPY VARCHAR2 |
310: --| x_msg_count OUT NOCOPY NUMBER |

Line 522: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |

518: --| IN : |
519: --| p_api_version IN NUMBER |
520: --| p_init_msg_list IN VARCHAR2 |
521: --| p_header_rec IN OUT NOCOPY |
522: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
523: --| p_dtl_Tbl IN OUT NOCOPY |
524: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
525: --| |
526: --| OUT : |

Line 524: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |

520: --| p_init_msg_list IN VARCHAR2 |
521: --| p_header_rec IN OUT NOCOPY |
522: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
523: --| p_dtl_Tbl IN OUT NOCOPY |
524: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
525: --| |
526: --| OUT : |
527: --| x_return_status OUT NOCOPY VARCHAR2 |
528: --| x_msg_count OUT NOCOPY NUMBER |

Line 739: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |

735: --| IN : |
736: --| p_api_version IN NUMBER |
737: --| p_init_msg_list IN VARCHAR2 |
738: --| p_header_rec IN OUT NOCOPY |
739: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
740: --| p_dtl_Tbl IN OUT NOCOPY |
741: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
742: --| |
743: --| OUT : |

Line 741: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |

737: --| p_init_msg_list IN VARCHAR2 |
738: --| p_header_rec IN OUT NOCOPY |
739: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
740: --| p_dtl_Tbl IN OUT NOCOPY |
741: --| GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type |
742: --| |
743: --| OUT : |
744: --| x_return_status OUT NOCOPY VARCHAR2 |
745: --| x_msg_count OUT NOCOPY NUMBER |

Line 931: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |

927: --| Validates all the input parameters. |
928: --| |
929: --| PARAMETERS |
930: --| p_header_rec IN |
931: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
932: --| p_dtl_tbl IN |
933: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_dtls_tbl_Type |
934: --| p_operation IN VARCHAR2 |
935: --| x_user_id OUT fnd_user.user_id%TYPE |

Line 933: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_dtls_tbl_Type |

929: --| PARAMETERS |
930: --| p_header_rec IN |
931: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
932: --| p_dtl_tbl IN |
933: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_dtls_tbl_Type |
934: --| p_operation IN VARCHAR2 |
935: --| x_user_id OUT fnd_user.user_id%TYPE |
936: --| x_return_status OUT VARCHAR2 |
937: --| |

Line 951: p_header_Rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type

947: -- Proc end of comments
948:
949: PROCEDURE Validate_Input_Params
950: (
951: p_header_Rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
952: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
953: , p_operation IN VARCHAR2
954: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
955: , x_return_status OUT NOCOPY VARCHAR2

Line 952: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type

948:
949: PROCEDURE Validate_Input_Params
950: (
951: p_header_Rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
952: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
953: , p_operation IN VARCHAR2
954: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
955: , x_return_status OUT NOCOPY VARCHAR2
956: )

Line 1817: p_header_rec GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type

1813: -- Func end of comments
1814:
1815: PROCEDURE add_header_to_error_stack
1816: (
1817: p_header_rec GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
1818: )
1819: IS
1820: BEGIN
1821:

Line 1841: END GMF_LotCostAdjustment_PUB;

1837: END IF;
1838:
1839: END add_header_to_error_stack;
1840:
1841: END GMF_LotCostAdjustment_PUB;