APPS.ASG_PROD_PKG dependencies on ASG_PROD_INFO

Line 28: insert into ASG_PROD_INFO(

24:
25: begin
26:
27:
28: insert into ASG_PROD_INFO(
29: PROD_TOP,
30: RUN_ORDER,
31: INI_FILE,
32: ZIP_FILE,

Line 69: update asg_PROD_INFO set

65:
66: begin
67:
68: IF (x_RELEASE_VERSION IS NOT NULL ) THEN
69: update asg_PROD_INFO set
70: RUN_ORDER = X_RUN_ORDER,
71: PROD_TOP = x_PROD_TOP,
72: INI_FILE = X_INI_FILE,
73: ZIP_FILE = x_ZIP_FILE,

Line 86: select count(*) into x_count from asg_prod_info

82:
83:
84: if (sql%notfound) then
85: begin
86: select count(*) into x_count from asg_prod_info
87: where PROD_TOP = X_PROD_TOP;
88:
89: if (x_count = 0) then
90: raise no_data_found;

Line 100: select count(*) into x_count from asg_prod_info

96: /* if the release-version not set, and if the record is not
97: existing, we should raise and then insert_row will catch
98: and insert it then. */
99: begin
100: select count(*) into x_count from asg_prod_info
101: where PROD_TOP = X_PROD_TOP;
102:
103: if (x_count = 0) then
104: raise no_data_found;